1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
DECLARE @M TABLE ( ParameterName NVARCHAR(20), ParameterValue NVARCHAR(MAX) ); INSERT INTO @M VALUES ('1', 'Napis1 &<'), ('1', 'Napis2 &'), ('1', 'Napis3'), ('2', 'aaa'), ('2', 'bbb'), ('3', 'a'); SELECT * FROM @M SELECT DISTINCT ParameterName, RemappedValues = STUFF( ( SELECT ';' + ParameterValue FROM @M AS M2 WHERE M2.ParameterName = M1.ParameterName FOR XML PATH(''), ROOT('ParameterString'), TYPE ).value('/ParameterString[1]', 'nvarchar(max)'), 1, 1, '' ) FROM @M AS M1; |
