Split in MS SQL SERVER

Here I shall describe about split in MS SQL. There is no built in function for splitting your text, that’s why I am describing two customize function for performing split operation in MS SQL. Split function 1: This function returns table that’s why we can say it table valued function. –select * from fnSplit(‘1,22,333,444,,5555,666’, ‘,’)

Read More

STUFF IN MS SQL, Getting data from table in a single row separated by comma or other sign

Consider following SQL statement for MS SQL Select UserName from UserInfo It will return UserName Anis Hasibul If you want to get these record in following way UserName Anis, Hasibul Then you have to use STAFF Consider following example of staff for getting above data SELECT STUFF ( (Select TOP 100 PERCENT ‘,’ + UserName

Read More

The maximum report processing jobs limit configured by your system administrator has been reached

This is very common error (“maximum report processing jobs limit”) when crystal report printing job limit over We can solve this problem using two way: 1. Need to write following code on CrystalReportViewer Unload event a. Perform reportDocument Deispose b.Perform reportDocument Clone c.Perform reportDocument Close d. Perform CrystalReportViewer Dispose Code ============ //Declare ReportDocument as a

Read More