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.