Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Group Islands of Contiguous Dates (SQL Spackle) RE: Group Islands of Contiguous Dates (SQL Spackle)

  • December 7, 2010 at 9:58 am

    #1259658

    autoexcrement (12/6/2010)

    Okay, I think this is starting to make sense now. Contiguous is defined here as "at least one date entry per day during a range". Okay. And now the rest of the article makes sense too. Cool.

    Wow, now that I understand what's going on, this article is freaking awesome. Jeff rocks. (Craig, too.)

    Now there's a huge compliment. Nah... I don't mean the "Jeff rocks" thing. I mean the huge lightbulb that just turned on. Thanks for the awesome feedback.

    Craig... it was your code that clarified it all here. Thanks again for the wonderful "cover" while I was busy.

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