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:

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:

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;