ingenioussql.com
Comma Separated Values using the FOR XML PATH clause
In a previous post we looked at how we can build out a delimited list using the ISNULL and COALESCE functions. This functionality is great if you need to return the delimited list through a functio…