Illegal CTEs

Question

Illegal CTEs

Steve Jones - SSC Editor

SSC Guru

Points: 736101
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: 259105 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: 27169 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: 11532 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