[thelist] SQL: Using recordsets from nested store procedures

[Steve Lewis]

Joshua Olson wrote:

> I have a stored procedure that returns a recordset.  I want to call that
> stored procedure within another stored procedure and push the resulting
> recordset into a temp table in the outer procedure.  Anybody know how to do
> this?

IIRC you work primarily in SQL Server.  Presumably you would just

SELECT procset.column1, procset.column2, procset.column3
INTO #temptable
FROM (EXEC mystoredproc) procset

but I am not sure that you can treat the result set as a derived table
like this.  Give it a shot?

--Steve