Set Based Solution to call a stored procedure for each row in a view

113 Views Asked by At

I would like to call a stored procedure for each row returned in a database view and pass values from the row to the stored procedure. Note that the data within the view does NOT contain an ID column (or any unique column).

I see that using cursors and WHILE loops aren't recommended.

Does anyone have an example they can share?

0

There are 0 best solutions below