Home Forums SQL Server 2005 SQL Server 2005 Compact Edition Using DateDiff to calculate days before a Birthday RE: Using DateDiff to calculate days before a Birthday

  • September 10, 2010 at 5:42 am

    #1219098

    Sorry, Ken... I was a bit asleep at the switch and forgot this was for the compact edition (heh... "CE" actually stands for "Crippled Edition", doesn't it? :-P)

    There's more than one way to do the same thing so, let's check...

    What do you get in CE when you run each of these individually?

    SELECT YEAR(GETDATE())

    SELECT DATEPART(yy,GETDATE())

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