creating a simple loop

[vorvad]

Can someone help me with the syntax for creating a simple loop.

I want to do the following:

Start with a number (lets say 5), then I want to multiply this value by a simple calculation (i.e. (5 * 3.14) / 10 = 1.8055).
I then want to take this new number, and apply it to the same calculation (i.e. 1.8055 * 3.14 / 10 = .5669), etc...

I also need to tell it when to stop the loop.
Thanks in advance!
VB

 

[tlbroadbent]

A basic looping structures in many programming langauges, including SQL is the While loop.

Declare @calc decimal(18,12), @cnt int
Select @calc=5, @cnt=0

While @cnt<6
Begin
Select @calc=@calc * 3.14 / 10, @cnt=@cnt+1
End

Select Result=@calc Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains &quot;Suggestions for Getting Quick and Appropriate Answers&quot; to your questions.