Skip to content

Instantly share code, notes, and snippets.

@chastain

chastain/concatenated list via stuff and for xml path

Created January 24, 2013 19:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save chastain/4626565 to your computer and use it in GitHub Desktop.
Save chastain/4626565 to your computer and use it in GitHub Desktop.
Download ZIP
Use stuff and for xml path to select rows into a comma separated list.
Raw
concatenated list via stuff and for xml path
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