How to convert cursor base in set based

Last Post 02 Jul 2008 12:42 AM by SQLUSA. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
SQLUSA
New Member
New Member

--
02 Jul 2008 12:42 AM
Here is a general advice:

1. Use #temptables in converting to set-based
2. Just proceed step by step from one #temptable step to another
3. You can check the results immediately since #temptables stay for the duration of the session
4. Create a hardwired script from the stored procedure while converting, by mass replacing input parms
5. At the end, you may be able to eliminate some #temptables, naturally retest

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2008 Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/
You are not authorized to post a reply.

Acceptable Use Policy