Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Next Business Day RE: Next Business Day

  • February 18, 2015 at 12:28 am

    #1778262

    Joe's suggestion is spot on for this. The only difference that I'd take is that I'd use the underlying date serial numbers for the dates so that you don't have to make two trips to the database to come up with the next business day.

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