Illegal CTEs

Question

Illegal CTEs

Steve Jones - SSC Editor

SSC Guru

Points: 737402
More actions
April 21, 2015 at 12:03 am

#317540

Comments posted to this topic are about the item Illegal CTEs
April 21, 2015 at 7:43 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 1

Great question. Not that I use recursive CTEs, but it's good to know

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

djj SSCoach Points: 18831 More actions · Answer 2

I do not use 2014 but my guess was correct. I thought it would be silly to not allow the others.

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 3

Mr. Kapsicum

SSCertifiable

Points: 6128

April 21, 2015 at 5:26 am

#1792353

Nice and easy

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

Good question. Not knowing the answer off the top of my head, it was more a process of elimination than anything. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 5

Ed Wagner (4/21/2015)
Good question. Not knowing the answer off the top of my head, it was more a process of elimination than anything. Thanks.

+1

free_mascot One Orange Chip Points: 27164 More actions · Answer 6

Good One!

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

below86 SSChampion Points: 11562 More actions · Answer 7

pmadhavapeddi22 (4/21/2015)
Ed Wagner (4/21/2015)
Good question. Not knowing the answer off the top of my head, it was more a process of elimination than anything. Thanks.
+1

+1

-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.

sknox SSChampion Points: 12388 More actions · Answer 8

Great. Now I'm trying to conceive of a situation where one would want to use PIVOT within a recursive CTE... :blink:

PHYData DBA SSCertifiable Points: 7541 More actions · Answer 9

Easy process of elimination answer. Although it makes no sense to me for a PIVOT to be in a recursive CTE...

PHYData DBA SSCertifiable Points: 7541 More actions · Answer 10

sknox (4/21/2015)
Great. Now I'm trying to conceive of a situation where one would want to use PIVOT within a recursive CTE... :blink:

Stop that. Just... NO! :hehe:

Ed Wagner SSC Guru Points: 287026 More actions · Answer 11

PHYData DBA (4/21/2015)
sknox (4/21/2015)
Great. Now I'm trying to conceive of a situation where one would want to use PIVOT within a recursive CTE... :blink:
Stop that. Just... NO! :hehe:

What if your code ran too fast and you wanted to slow it down? Between the pivot and the rcte, that should do the trick.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 12

Ed Wagner (4/21/2015)
What if your code ran too fast and you wanted to slow it down? Between the pivot and the rcte, that should do the trick.

XPath is your friend.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

PHYData DBA SSCertifiable Points: 7541 More actions · Answer 13

Hugo Kornelis (4/21/2015)
Ed Wagner (4/21/2015)
What if your code ran too fast and you wanted to slow it down? Between the pivot and the rcte, that should do the trick.
XPath is your friend.

If your code is running to fast perhaps you should tell it to wait.

Just don't ask it to WAITFOR to long... :w00t:

https://technet.microsoft.com/en-us/library/ms188253(v=sql.105).aspx

Illegal CTEs

Cookies on SQLServerCentral