Sql Xml Comma Seperator

SELECT SUBSTRING((select ',' +cast(worksetname as varchar) from  table1  ORDER BY worksetname FOR XML PATH('')),2,200000)

Comments