SQL Server Performance Forum – Threads Archive

Performance of Server Side Cursors

I have a stored procedure in one server and a DTS in another server which just calls the stored procedure. The logic of the stored procedure is as follows: I need to select data from one table and I need to insert those records into a table for a specified date range. For example:-
Date Range : 1/1/2006 and 1/27/2006.
I am having 10,000 records to select from the source table. I need to insert these records for all the days between 1/1/2006 and 1/27/2006. So for this I am using a cursor to do the functionality. When I exexuted the stored procedure from a DTS (remote server) it took nearly 1 hour and 5 minutes to complete the job. Whether there is some other way to achieve the functionality without the cursor. It took a long time because of the usage of cursor. Please do the needful.

Hi, Please dont post duplicate threads, find your answers at : http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12589</a> moderators please lock this threads. <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

]]>