Home Forums SQL Server 2005 T-SQL (SS2K5) Flatten a one to many? RE: Flatten a one to many?

  • March 7, 2013 at 4:39 pm

    #1594750

    kpwimberger (3/7/2013)

    I have been reading the article and am trying to apply that fix now. I thought the additional data I sent would have helped. I may be able to simplify actual structures and post query code, but that will take some time as the example I gace was obviously not what Iam actually working on.

    I will see if I can whip something up if my attempts to apply the article fix fail.

    Thanks.

    Kurt

    It doesn't have to be the actual data. Just post the data you previously posted in a readily consumable format like in the article.

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