A few days ago i showed how to split string with XML.
Now it's time for concatenation with XML.
DECLARE @t TABLE (col VARCHAR(10))
INSERT into @t
select 'aaaa' UNION ALL
select 'bbbb' UNION ALL
select 'cccc' UNION ALL
select null UNION ALL
SELECT * FROM @t
SELECT col + ', ' as [text()]
ORDER BY col DESC
FOR XML PATH('')
) AS MyCsvList
Both of these (split and concat) methods aren't really anything special. They're just a new way of solving old problem.
But whenever i need them i have to look them up, so where else to keep them handy than here, right? :)