I've checked the CTE's in SQL server 2005 beta 2 it is really a very useful feature but I want to use it with the output of a stored procedure. Is this available?
Thanks in advanceHi,
Can you please be more specific about what you want?
I understood you to say that you wanted to use the result set of a stored procedure as the operand to a relational JOIN operator inside a CTE. AFAIK, that is not allowed. AFAIK, the only place where you can use a stored proceure in a relational (table-valued) expression is the INSERT INTO table.. EXEC proc syntax.
However - I believe you should be able to use a table-valued function.
Regards,
Clifford Dibble
No comments:
Post a Comment