Home Forums SQL Server 2008 SQL Server Newbies Get next 2 weeks RE: Get next 2 weeks

  • July 23, 2014 at 10:31 pm

    #1732011

    @sharonsql2013,

    Many folks have correctly identified that the table should be "normalized". While it may not be possible for you to change the table, do you know how you would normalize the table if you had to? I ask because THAT's the key to this problem.

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