tdittmar/transpose_result.sql
Created Dec 10, 2016

Star 0
Fork 0

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

You can’t perform that action at this time.