• Ryan C. Price (9/29/2009)


    Jeff Moden (9/28/2009)


    Heh... I see 3 recommendations to build a Calendar table and two that claim they've used one, yet no one has offered up any of their own code to show they have ever done so. 😉 Like the tag line from the movie goes... Show Me the Money! 😛

    Jeff - did you count my rambling on about week numbers as one of those recommendations ?

    if so, you're making me feel all guilty and I'll have to go off and try and find a copy of that database in an archive somewhere.....

    /Ryan

    Heh... I guess my comment worked. Good folks are coughing up some good stuff. Thank you one and 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)