loop

[SBTBILL]

I need a loop in SQL server. I understand that there is a command called WHILE. Where can I get info on using it.

 

[gmmastros]

Books on line is a great place to start.

http://msdn.microsoft.com/en-us/library/ms178642.aspx

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[JoeAtWork]

http://www.google.com

 

[bborissov]

Just make sure you really need a LOOP.
SQL Server is optimized for datasets, not for loops.
Maybe if you post what is your problem, we could figure out a non-loop decision.
Of course this is depending of your needs (sometimes LOOPs are mandatory ))))

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[tcsbiz]

http://msdn.microsoft.com/en-us/library/aa260676(SQL.80).aspx

 

[SBTBILL]

Actually I've been working on a way to do it without a loop that seems to be coming together quite well. Use and update for is greater then period plus a second update for a different field for with is greater then or equal.