I have around 10 Stored Procedures each of which takes one argument as an input parameter. I have a table of around 200 ids against which I want to run these 10 stored procedures. What is the best way of executing this ? Also for each id for each stored procedure run I would like a count of the number of records affected or the stored procedure to return a true or false.
Please let me know if you have any other questions,