SELECT t.id, STUFF( ( SELECT ';'+x.col1 FROM @MyTable x WHERE x.id=t.id ORDER BY x.col1 FOR XML PATH(''),TYPE ).value('.','VARCHAR(1000)'),1,1,'') as con_strFROM @MyTable tGROUP BY t.id;
We walk in the dark places no others will enterWe stand on the bridge and no one may pass