Skip to content

Instantly share code, notes, and snippets.

@tdittmar

tdittmar/transpose_result.sql

Created December 10, 2016 18:09
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 tdittmar/801e686facf66b9e604df981a8fa7b7f to your computer and use it in GitHub Desktop.
Save tdittmar/801e686facf66b9e604df981a8fa7b7f to your computer and use it in GitHub Desktop.
Download ZIP
Turn a result from rows into a comma-separated string
Raw
transpose_result.sql
DECLARE @test NVARCHAR(MAX)
SELECT @test = COALESCE(@test + ', ', '') + Field FROM <Sampletable> WHERE <whereclause> AND Field IS NOT NULL
SELECT @test
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment