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