I have stored procedure written in SQL Server 2000 using various CURSORS.
Because of this CURSORS, the performance of the DTS Packages and Stored Procedures is getting poor. Currently, because of CURSORS, my stored procedure execution is taking almost 2 to 3 mins to complete execution, i need to reduce it to few seconds like 5 to 10 seconds.
I have been told to optimize the SQL Server CURSORS using either select statements or set based statements or WHILE LOOPS or something else ?
Can somebody suggest me how to do the same ?