hi all,
Im making one reporting system using sql server2000 and c# asp.net.I have to make some calculation inside the stored procedur.But it take long time to generate my report. Inside my stored procedur i used cursors and some t-sql functions.
so i want to know are there any method to do fast all calculations inside sp's .
My problem is normally my PC take 40 seconds to generate my report.
If i host this system i think it will take more than 1 mints for generate same report.
Now i indexces all my data filtering tables . But my problem is still same. Can anybody help me to do fast this in sqlserver 2000.
thankx


MSB

__________________
MSB

Without even seeing your query?

  You've likely identified most of your problems with speed right there... Cursors and functions... Cursors are almost always bad and if the same person who wrote the cursors also wrote the functions... well...

Get rid of the cursors... replace them with correct set based code. Forget about processing rows... process columns as sets.

--Jeff Moden