Executing a SP for each recordset of a Table

anandham · October 18th, 2005, 05:01 AM

Hi,
I would like to execute a Stored Procedure for each & every record of a particular table. The parameters passed will be the selected from each record of that table. Please help me in this regard.
Thanks
anandham

Prem Anandh P.
Ambition Never comes to an End

robprell · October 19th, 2005, 06:34 PM

You will probably want to put a cursor in a stored procedure that selects every row from a table. Then itterate through the cursor row by row executing a second stored procedure or some embedded code within the cursor.