I have an operation I want to perform in a stored procedure. I am building a temp table that gradually gets larger. Now, what I want to do is this;
I have found some literature on the "while" statement, which sets a condition for a chunk of SQL to be repeated until a condition is met.
so, here would be the query, in English;
While (select....from...where) still has records
begin
some code I want to run
end
I hope my ranblings make sense. Thanks for any help.
I have found some literature on the "while" statement, which sets a condition for a chunk of SQL to be repeated until a condition is met.
so, here would be the query, in English;
While (select....from...where) still has records
begin
some code I want to run
end
I hope my ranblings make sense. Thanks for any help.