Query Problem Column to string

Question

Post reply

Query Problem Column to string

Martin D. Cymerman

SSCrazy

Points: 2019
More actions
May 9, 2007 at 6:42 am

#370989

How can a write a query such that the output of a column is like

value1,value2,value3,value4

rather that the normal output of

value1

value2

value3

value4

Thanks

CY

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

Antares686

SSC Guru

Points: 125444

May 9, 2007 at 7:38 am

#705204

Many different was to do this. It is called a pivot table and there have been many responses on this. But for your answer the question is how do you identify the records are related or do you want all rows to be concatinated together?

Ian Yates SSCoach Points: 19738 More actions · Answer 2

It's always "yukky" to return data like that, but if you must, then you can do something like

declare @X varchar(8000)

set @X = ''

select @X = @X + ',' + myCol

from myTable

order by myOrderingColumn

select @X

There are many other ways to do it. Apparently it is not documented either although that's a claim I've never checked (others have made the claim). I can tell you that it appears to work in SQL 2000 and 2005.