/transpose_result.sql
Created Dec 10, 2016
Turn a result from rows into a comma-separated string
| 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