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

    #1259649

    autoexcrement (12/6/2010)

    But how can you tell which dates are "start", "end" or "start and end" without any additional information (like the comments)? I don't see any rhyme or reason here, aside from the dates being in chronological order.

    I know Craig covered this, but you actually got it right there. The dates are simply in chronolgical order and the StartDate and EndDates identify the "islands" of dates where there are no missing dates.

    I think a lot of folks were looking for a much more complicated answer to this simple problem.

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