Loop on results, call sproc

jkmyoung

Hi,
I'm looking for a way to loop on a set of temporary results and run a stored procedure on each row of the results.

Simplified code of what I'm trying to do:

Expand|Select|Wrap|Line Numbers

 
Declare @TMP TABLE

(

field1 Int

field2 Int

)
 
INSERT INTO @TMP

SELECT id, otherVar

from ....blah join blah join blah

where bar = foo
 
Declare @RC = int

-- Want to loop here.

For each result.

Exec @RC = [Process].[dbo].[usp.storedProc1]   **field1** **field2**

End for

What is the syntax to do this? Also is this terminology correct, or is there another specific word for what I'm looking for?

jkmyoung

Finally managed to find a solution:

Expand|Select|Wrap|Line Numbers

 
Declare @TMP TABLE

(

field1 Int

field2 Int

)
 
INSERT INTO @TMP

SELECT id, otherVar

from ....blah join blah join blah

where bar = foo
 
Declare @RC = int

Declare @f1 = int

Declare @f2 = int

declare cur_1 cursor for select field1, field2 from @TMP
 
-- like a do-while

fetch next from cur_1 into @f1, @f2;

while @@FETCH_STATUS = 0

begin

    Exec @RC = [Process].[dbo].[usp.storedProc1]   @f1, @f2

    fetch next from cur_1 into @f1, @f2;

end 

close cur_1;

Loop on results, call sproc

Post your reply

Similar topics