[thelist] SQL: Using recordsets from nested store procedures

[Joshua Olson]

----- Original Message -----
From: "Steve Lewis" <slewis at macrovista.net>
Sent: Friday, November 08, 2002 3:44 PM


> IIRC you work primarily in SQL Server.

Good memory
> 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?

Okay, I gave it a shot but the parser didn't like EXEC within the FROM
clause.  It was a nobel idea, though.  I'm sure there's some syntax of SP's
I just don't know yet (and I'm sure there's plenty).  Thanks though.

-joshua