March 11, 2009 at 2:53 pm
Hi,
I am trying to store multiple resultset of a stored procedure in to multiple tables.
Any ideas?
Example: sp_spaceused will give two resultsets.
You can save output of 1 resultset using "insert tablename exec sp" but that doesn't work when you have two resultsets specially when both have different # of columns and column names and all.
March 11, 2009 at 3:22 pm
Officially you can't do that!
there are many other scripts on this site that could probably help you.
What exactly are you trying to do?
* Noel
March 19, 2009 at 3:20 pm
I am trying to get both resultsets of stored procedure and save it in tables. Then parse through it.
I dont want to get code out of procedure and run the code. If there is a way to store both resultset into tables directly that would be ideal.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply