CTE

Question

CTE

PRAMANA.DBA

SSCertifiable

Points: 5507
More actions
September 25, 2013 at 4:19 am

#298284

Is it possible to call procedure in CTE?
Redesign your sproc to be able to operate over everything you need it to do.
Build up your sproc usage as a dynamic SQL string, then execute the string once you have all of the iterations ready.
Use a loop (either WHILE or CURSOR).

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

No. Why didn't you just try it? It would've failed far quicker than waiting for a response on a forum.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

PRAMANA.DBA SSCertifiable Points: 5507 More actions · Answer 2

Cadavre (9/25/2013)
No. Why didn't you just try it? It would've failed far quicker than waiting for a response on a forum.

That will fail, but i would like to know, is there any possibles to call procedure in CTE?

so i have edited the question.

Cadavre SSC-Forever Points: 41690 More actions · Answer 3

PRR.DB (9/25/2013)
Cadavre (9/25/2013)
No. Why didn't you just try it? It would've failed far quicker than waiting for a response on a forum.
That will fail, but i would like to know, is there any possibles to call procedure in CTE?
so i have edited the question.

Your question remains the same, so I have to ask, "What are you actually trying to do?". It looks like you're trying to avoid using a WHILE loop or CURSOR, is that correct?

If so, there are three real options: -