0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

CREATE table #yourtable
    ([item] int, [value] varchar(6))
;
    
INSERT INTO #yourtable
    ([item], [value])
VALUES
    (1, 'John'),
    (1, 'jOHN 2'),
    (3, 'John')
;


SELECT  item
       ,STUFF((SELECT ':' + CAST(value AS VARCHAR(10)) [text()]
         FROM #yourtable
         WHERE item = t.item
         FOR XML PATH(''), TYPE)
        .value('.','NVARCHAR(MAX)'),1,2,' ') List_Output
FROM #yourtable t
GROUP BY item

fork query

edited dec 7 21 anonymous

created jun 8 16 bluefeet