Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Hidden RBAR: Counting with Recursive CTE's RE: Hidden RBAR: Counting with Recursive CTE's

  • August 8, 2011 at 12:21 pm

    #1365448

    terrance.steadman (8/8/2011)

    Greetings Jeff,

    That was a wonderful and very insightful article about rCTE's and ways to count out of the box. I will have to put some of the pseudo-counters into practice in my scripts.

    Thank you for sharing.

    P.S.

    Beer popsicles are possible if you know the *secret* ingredient to mix to make it become solid. 🙂

    Heh... yeah... the ol' "hot ice" trick works pretty well but makes the beer taste pretty bad. That's why I use the "Chill'n'Tap" method, instead. 😛

    Thanks for stopping by and for the feedback. Hmmmm. "Pseudo-Counters". You may have just coined your own term for the 3 counting methods in the article that use "Pseudo-Cursors". 🙂

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