Create a single rowset out of returned multiple rowsets

[Gthompson]

Is it possible to create one rowset with the returned rowsets of 2 different
sprocs?

Example:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Create proc sp1
@ID1 int
as
Select fname, lname From Customer where ID = @ID1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Create proc sp2
@ID2 int
as
Select item from Product where ID=@ID2

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Create proc sp3
@ID1 int,
@ID2 int
as
//Here is where I want create one rowset out of 2 different sproc by executing
them.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[Michael Levy]

It can be done. You could use the INSERT EXECUTE statement to load the
results of both stored procedures into the same temp. table and SELECT from
the temp table to get the single result set. Remember the results from the
two stored procedure will have to have the same number of columns and
consist of compatible data types.

-Mike
--
Michael Levy MCSD, MCDBA, MCT
Consultant
GA Sullivan
michaell@gasullivan.com