Home Forums SQL Server 2008 T-SQL (SS2K8) query for continuous period RE: query for continuous period

  • June 26, 2011 at 11:44 pm

    #1344305

    TheSQLGuru (6/22/2011)

    If you want an amazingly efficient way to collapse date intervals, see here: http://www.solidq.com/sqj/Pages/2011-March-Issue/Packing-Intervals.aspx. Incredible TSQL goodness served up by Itzik Ben-Gan.

    Damn, that's clever. It's not so much the T-SQL I impressed with... it's the simple math behind it all.

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