Home Forums SQL Server 2014 Development - SQL Server 2014 COALESCE to replace multiple CASE statements RE: COALESCE to replace multiple CASE statements

  • May 28, 2014 at 6:37 pm

    #1717206

    nimalatissa (5/27/2014)

    I'm very confused. These tables are normalized to 3rd normal form. There shouldn't be anything to do with that. the column in this table have comma separated values and I need to return a specif value for those comma separated values. This was working fine, but we are seeing slowness and trying get rid of these CASE statements.

    That's why people are saying the table isn't normalized. You have more than one value in a column.

    Please, do us all a favor... post a couple of rows of that column so we can come up with a known solution for a known problem before two of my friends kick the crap out of each other on this thread. 😛

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