(SQL) How would I return the result set from multiple executed stored procedures?
Okay I have a queswtion about returning the recordset from multiple stored procedures.

If I have a sproc which does this:

    exec sproc1
    exec sproc2
    exec sproc3


Each sproc returns just one number, so it return

[no column name]
1500

[no column name]
18000

[no column name]
1253

Obviously a datareader won't be able to handle this, or at least I don't think it will.  So I thought about declaring a Table variable

    DECLARE @Table (Col1, Col2)
    
    INSERT INTO @Table
    exec sproc1,exec sproc2, etc...)

But that doesn't work.

Any ideas on how to handle this?
(SQL) How would I return the result set from multiple executed stored procedures?
===

Okay I have a queswtion about returning the recordset from multiple stored procedures.

If I have a sproc which does this:

    exec sproc1
    exec sproc2
    exec sproc3


Each sproc returns just one number, so it return

[no column name]
1500

[no column name]
18000

[no column name]
1253

Obviously a datareader won't be able to handle this, or at least I don't think it will.  So I thought about declaring a Table variable

    DECLARE @Table (Col1, Col2)
    
    INSERT INTO @Table
    exec sproc1,exec sproc2, etc...)

But that doesn't work.

Any ideas on how to handle this?