SQL ServerでのGROUP_CONCATの使用方法

FOR XML PATHを使用する方法:SELECT Column1, STUFF((SELECT ', ' + Column2 FROM YourTable WHERE YourTable.Column1 = t.Column1 FOR XML PATH('')), 1, 2, '') AS ConcatenatedValues FROM YourTable t GROUP BY Column1>>More