Kurt,
Thanks for the hint. It was exactly what I needed.

Einar

>Search for DECLARE CURSOR in BOL.
>
>Kurt
>>How do I loop through a result set using T-SQL?
>>
>>Something like this pseudo code:
>>

>>SELECT pk from mytable where fk = @fk
>>
>>foreach_row_in_result_above
>>{
>>  do something with the fk from the row (pass fk to another SP)
>>}
>>

>>
>>Any help would be appreciated.
>>
>>Thanks,
>>Einar