Post reply

getting all records between 2 fridays of a given date

  • January 5, 2009 at 10:26 pm

    #921569

    Jeff Moden (1/1/2009)

    Day "0" is 01/01/1900... and it was a Monday... Guess what happens if you add 4 days to any Monday? You get a Friday... every time.

    Sorry Jeff, but I don't think that Microsoft guarantees that the days of the week will always be in the same order.

    😀 :laugh: 😀

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • January 6, 2009 at 5:54 am

    #921701

    RBarryYoung (1/5/2009)

    Jeff Moden (1/1/2009)

    Day "0" is 01/01/1900... and it was a Monday... Guess what happens if you add 4 days to any Monday? You get a Friday... every time.

    Sorry Jeff, but I don't think that Microsoft guarantees that the days of the week will always be in the same order.

    😀 :laugh: 😀

    BWAAA-HAAAA! Yeah... that's right... it's one of those friggin' undocumented features that some folks keep crabbin' about. 😛

    Oh, man... I'm crying I laughing so hard... that was a good one, Barry. Great way to start the day. Thanks.

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

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply