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:43 am

    #1259631

    dadam (12/7/2010)

    When Jeff said, "even though the DateGroup looks like a date, it really doesn't mean anything," he was fibbing a bit, probably to keep unnecessary detail out of the article.

    Agh... Thanks for the correction... I should have said,

    "...even though the DateGroup looks like a date, it [font="Arial Black"]simply being a date [/font]doesn't really mean anything,"

    You are correct about the significance of the date and, for important a concept as contiguous dates all have the same date in the column, I did gloss over it a bit to keep the "spackle" short and mostly left that realization up to the reader by reading the results and the comments from that one query.

    And the addition of DaysSkipped is a clever bit of code. Thanks for posting it. 🙂

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