Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Use stuff and for xml path to select rows into a comma separated list.
SELECT Stuff((SELECT ', ' + Name
FROM StateProvinces
FOR XML PATH ('')),1,1,'')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment