Stored procedure as CTE_query_definition

Asked Oct 30 '12 at 16:15

Active Oct 30 '12 at 17:12

Viewed 922 times

Can I use a stored procedure as the CTE_query_definition of a CTE?

For example:

WITH  CodesCTE
AS ( Exec sp_TableReturningProc )
SELECT * FROM CodesCTE;

If not, outside of declaring a batch / global temp table and using a Select statement against the temp table, is there a way around this limitation?

I am in the process of developing the associated stored procedure and would love to simply the use of it for this purpose if possible.

edited Oct 30 '12 at 17:12

marc_s

732,580
175
1,330
1,459

asked Oct 30 '12 at 16:15

GoldBishop

2,820
4
47
82

1

No. Some possible workarounds here: http://stackoverflow.com/questions/1492411/sql-server-select-from-stored-procedure – Aaron Bertrand Oct 30 '12 at 16:48
So its going to be a Temp Table design. Oh Well, guess ill be implementing Resource Management as well ;) – GoldBishop Oct 30 '12 at 16:56

Stored procedure as CTE_query_definition

0 Answers0