Skip to content

Instantly share code, notes, and snippets.

@aramkoukia

aramkoukia/TSQL-COALESCE-comma-separate-rows.sql

Created March 2, 2017 19:57
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save aramkoukia/60e06f1c68582857f474d3cb71fc90b2 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save aramkoukia/60e06f1c68582857f474d3cb71fc90b2 to your computer and use it in GitHub Desktop.
Download ZIP
TSQL COALESCE comma separate rows
Raw
TSQL-COALESCE-comma-separate-rows.sql
DECLARE @List VARCHAR(8000)
SELECT @List = COALESCE(@List + ',', '') + CAST(Color AS VARCHAR)
FROM NameColorTable
SELECT @List
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment