Home Forums SQL Server 2008 SQL Server 2008 - General Shift week to Wed - Tues RE: Shift week to Wed - Tues

  • September 25, 2013 at 11:22 am

    #1653285

    paul.j.kemna (9/24/2013)

    I do have a Date table at my disposal that has Date, WeekStartSunday, DayOfWeek, etc.

    I believe the best thing to do would be to add WeekStartWednesday and DayOfWeekWednesday to your calendar table. It also sounds like you may have to change a wad of code whether you can make this Calendar table change or not.

    I'd also be interested in the rules behind determining what the first and last week of any given year would be.

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