I'm sure this is a very common question, but I searched Google for about 30
minutes and couldn't find an answer. I have a situation where I need to get
a result set, then execute a stored procedure using each record in that
result set. Is there any way I can do this without a cursor? I've been able
to do an update like this using WHERE...IN, like this:
UPDATE Table1 SET FieldName = 'somevalue' WHERE ID IN (SELECT Table2.ID FROM
Table2 WHERE Table2.FieldName2 = 'someothervalue')
But so far I've had no luck doing a similar thing with a stored procedure.
Is this at all possible?