[dba-SQLServer]Do Loop in a sproc

The format is...
 
WHILE (condition = true)
BEGIN
    -- do processing
    
END
 
Keep in mind that a direct translation of programming logic from
whatever to TSql may not be the best way to go.  If you post what you
are trying to do, people may be able to give you an alternative to using
a loop (which tend to be much slower than set-based statements).
 

	-----Original Message-----
	From: Mark Boyd [mailto:MarkBoyd at mcbeeassociates.com] 
	Sent: 12 February 2003 9:26 AM
	To: SQLServerList
	Subject: [dba-SQLServer]Do Loop in a sproc
	
	

	I am converting VBA code to a stored procedure.

	This code includes a pretty large Do Loop.

	Is it possible to create a loop in a sproc?

	If so, what is the format?

	 

	Thanks,

	Mark Boyd

	Sr. Systems Analyst

	McBee Associates, Inc.

	 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030212/b582a787/attachment.html>