• wldhrs (9/28/2009)


    thomasrawley, while i detest your naming conventions, how many compilers care if the name is fscl_yr, how many compilers care if the name is [Fiscal Year] ... go on bite me Jeff,

    Heh... bite yourself... I don't care what you call your stuff. 😉 I'd much rather just see FiscalYear instead of the abbreviations or the report formatted column name, but whatever.

    Jeff, are you actually against calendar tables or are you just playing the game?

    Oh heck no... not against calendar tables at all. I just see all those folks talking about them but no code to help others out.

    Editted to fix missing ]'s, Doh.

    Heh... see? 😉

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