Post reply

Illegal CTEs

  • April 21, 2015 at 1:50 pm

    #1792559

    djj (4/21/2015)

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

    +1

    Don Simpson


    I'm not sure about Heisenberg.

  • April 22, 2015 at 6:50 am

    #1792706

    I've yet to use PIVOT for anything.

  • April 22, 2015 at 8:53 am

    #1792766

    Ed Wagner (4/21/2015)

    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. 😛

    BWAAAA-HAAAA-HAAAA!!!!! I was thinking the exact same thing and then I read your post! TOO FUNNY!!! Crud... I think I blew a pork chop bone out my left nostril. 😛

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • April 22, 2015 at 9:14 am

    #1792781

    Thanks for this easy question : the use of PIVOT in a recursive CTE is an error since the release of SQL Server 2012 , something I learnt during a session about the novelties of the version 2012 at the Techdays 2012.

  • April 22, 2015 at 9:41 am

    #1792800

    Jeff Moden (4/22/2015)

    ... Crud... I think I blew a pork chop bone out my left nostril. 😛

    That sounds painful. 😉

  • June 3, 2015 at 6:02 am

    #1802572

    My guess was correct

Viewing 6 posts - 16 through 20 (of 20 total)

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