Home Forums SQL Server 2014 Development - SQL Server 2014 Comparing string with date RE: Comparing string with date

  • January 31, 2014 at 9:09 am

    #1685099

    Lempster (1/31/2014)

    Jeff Moden (1/31/2014)

    The truth be told, they're both not that great because of the mixed character data in denormalized columns instead of using the correct DATETIME datatype.

    Yep, and I think that's the main thing to take away from this whole thread...as was pointed out multiple times. It's always good fun and educational to get deeper into these topics though. Cheers Jeff!

    Regards

    Lempster

    Absolutely. Thanks for being a part of that.

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