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
Author Messages
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:

Acceptable Use Policy