Hi,
I have an application which generates a report . The application calls a Stored Procedure where the data from different tables is taken and formatted and dumped in a temporary file. This data is taken by the application , which is bascially dumped in the .csv file. Since the data taken from the temporary table is huge, we are not able to copy the entire data in the CSv.
What I am thinking is that if I divide the entire data in 5 parts i.e 20 % each and then try to populate the csv , i guess i can get the desired result. But the problem is how can take this data in parts ? should i use a loop in my c# code, calling it 5 times,in that case each time I call the stored procedure the data from the beginning will be generated in the SP and will get and overlapping records.
Can any one please suggest how can i proceed with it ? Does any one has a different approach ?
I need a solution at the earliest, the report is to be generated tomorrow after noon.