How to do Loop in a store procedure?

[6656]

Hi all,

I'd like to have a loop in a stor procedure. It is simplar action like unix scrip.
i.e. for mystring in a b c d
do
print "$mystring is in mystring"
done

Someone can give me a example in SP?

Thanks in advance.
Mike

 

[inaranjo]

Hi,

Have you tried a while sentence in your SP?
i.e.
While @diff <= 0
begin
update....
...
if @diff < 0
...
else
select @diff = 1 => to exit loop
end

Hope this helps

 

[6656]

Thanks inaranjo,

I am not sure how does @diff pass the charactor string (a b c...) in your sample given?