I need to run a stored procedure on a set of id's, is it possible? I have a stored procedure called DeleteItem that takes a parameter @itemId. Now, can I do something like this:
SELECT itemId FROM userTbl WHERE userId = 1
For each itemId that was returned I want to run:
EXEC DeleteItem @itemId
Thanks in advance!
View Complete Post