Thx everyone,

The two suggestions have started me thinking ... it might be possible to redesign the procedures in these situations to take a table variable as an input parameter.

Then I...

I guess the point of calling the stored procedure iteratively is that I need to keep the logic in the procedure encapsulated.

The procedure logic in these cases is usually very...

I don't quite understand your response.

I have a temp table with an integer identity column as well as a column for each parameter of the stored proc.

Now how does the...