Home Forums SQL Server 2008 SQL Server 2008 - General Hierarchy Structure SQL Query RE: Hierarchy Structure SQL Query

  • May 25, 2012 at 5:46 pm

    #1493425

    dwain.c (5/24/2012)

    Jeff Moden (5/24/2012)

    dwain.c (5/24/2012)

    ...so what makes you think I could do so here?

    Not sure. You DO have a love for rCTEs and I'm thinking that you'll pull a rabbit out of your hat just because you do love working with them.

    Actually I think you're confusing my exploration with love.

    I have kind of a fondness/hate relationship with them.

    I'm fond of them because they're cool and interesting. I hate them because mostly they don't perform so well and because I am recursively challenged. And also because I haven't found that killer app yet (but will keep on looking).

    I'm recursively challenged, as well. I've been married more than once. 😛

    --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)