The sum of all
SQL Server
matter that exist,
and the space in which all
SQL Server
events
occur or could occur.
Welcome to SQL Server Universe.com
Sign in
|
Join
|
Help
Home
SS SLUG
Forums
Articles
Photos
Downloads
SQL Server Universe.com
»
SQL Server Components
»
T-SQL
»
Re: Stored in a loop
Re: Stored in a loop
07-06-2007, 21:24
Dinesh Priyankara
Joined on 11-22-2006
Colombo, Sri Lanka
Posts 102
Points 0
Re: Stored in a loop
Reply
Quote
Hi,
It depends on the way you have written the SP.
This post
may help you to find the problem.
Use CURSOR whenever you have no other options for implementation. Most of the time, WHILE loop can be used instead CURSOR.
If the above link does not help you on this, please let us know the content of the SP.
Filed under:
Performance
,
Stored Procedure
Post Points: 0
Report abuse
View Complete Thread
(Best viewed with a resolution of more than 1024 * 768)