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 27, 2009 at 7:09 am

    #1045496

    Well actually, since you are on SQL server 2000, the solution will not work, it would have implied you can use for xml path(''), and it appeared in sql 2005...

    Really sorry for the mislead.

    Cheers,

    J-F