Hi i have a SP which will pull the Data and another SP to organize that Data into proper format to fit my front end application reports.
below is the SP that we use to do formating the resultset form the original SP
Can Some one optimize this SP, i dont to use the while loop coz i have 18 such SP's and i cant do it in all the SP.
Can we get this kind of out put by using a regular query
View Complete Post