Home Forums SQL Server 7,2000 T-SQL Eliminate duplicate ID by concatenating string values from rows, where all columns except first one are dynamic RE: Eliminate duplicate ID by concatenating string values from rows, where all columns except first one are dynamic

  • August 26, 2009 at 11:54 am

    #1045054

    Look up "FOR XML" in BOL, it will help you concatenate those strings together, based on the TranID.

    Hope that helps,

    Cheers,

    J-F