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
J-F Bergeron
SSCrazy Eights
Points: 8593
More actions
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