Home Forums SQL Server 2008 SQL Server Newbies Multiple values in some columns single value in another RE: Multiple values in some columns single value in another

  • September 16, 2012 at 5:54 pm

    #1538367

    eamonn.byrne (9/14/2012)

    Yep that definately works. It took you 5 seconds to fix what had me scratching my head for a couple of hours. :ermm:

    Cheers!

    Before you use it, Joe is right.

    1. What is the key here? Is it just EmgID or is it EmgID and Reference together.

    2. Regardless of what the answer to 1 is, is there anything special you want done for an EmgID with multiple Reference values?

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