Ever written a stored procedure where you want to select from a table and then loop through each row returned and pass in values from each column in each row into a stored procedure.

Thanks to Andrew Kelly for his help in producing a working stored procedure as follows (fragment shown).

 DECLARE MYCURSOR CURSOR FOR
  (SELECT p1, p2
   FROM  tbl_MyTable
   WHERE p4=123)

 DECLARE @p1 INT
 DECLARE @p2 INT
 DECLARE @p3 INT

 OPEN MYCURSOR
  FETCH NEXT FROM MYCURSOR INTO @p1, @p2, @p3

  WHILE @@FETCH_STATUS = 0
   BEGIN

    -call stored procedure
    exec UpdateTable @p1, @p2, @p3

    FETCH NEXT FROM MYCURSOR

   END

    CLOSE MYCURSOR
    DEALLOCATE MYCURSOR

vtgo.net