• jfogel (7/15/2013)


    One of the major apps our business uses names columns with spaces and special characters like "Created Date/Time". I'm surprised they don't want the case sensitivity default changed as well. Then they have common app generated queries that search the first three characters of that nvarchar(4000) column. Oh but the column is indexed!

    BWAAA-HAAAAA-HAAAA!!!! Too funny! Real life is stranger than anything you could make up! It was all I could do to keep from blowing the mashed potatoes I was eating out of my nose when I read 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)