My first thought this morning is to create temporary tables for each stored procedure that have the exact same schema as the result set returned by the stored procedures.

Then, have...

I would like to do what cburleigh suggested with a little extra.

I'm looking to aggregate information from exec statements into the temporary table along with identifying information as...

I'm experiencing this issue as well. Did you ever find a resolution to this?

Another thanks!