execute procedure for a sequence of elements (execute theProc (select id from table))
- by Omu
I need to execute the procedure deleteQuestion for each element that was returned by this select query:
select id from questions where Stuff = @Stuff
execute deleteQuestion id
something like:
execute deleteQuestion each(select id fom questions where Stuff = @Stuff)
anybody knows how ?