Multiple Rows to single column using SQL Server

Question

I want to convert my found data to a single column

My data is

Id ------ 3 4 5

that record I want to this format

id ======= 3,4,5

Google "SQL Server string aggregation"

Gordon Linoff
– Gordon Linoff

2015-10-09 11:00:44 +00:00
Commented Oct 9, 2015 at 11:00 — Gordon Linoff
– Gordon Linoff, Commented Oct 9, 2015 at 11:00

Community · Accepted Answer · 2017-05-23 11:44:34Z

1

Try,

 SELECT STUFF( (SELECT ',' + Id FROM My_Table ORDER BY Id FOR XML PATH('')), 1, 1, '')

Original_Post_Here

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Oct 9, 2015 at 11:05

A_Sk

4,6505 gold badges31 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shiju Shaji · Accepted Answer · 2015-10-09 11:42:13Z

Another way

DECLARE @str VARCHAR(1000) SELECT @str = coalesce(@str + ',', '') + a.[Your Column] FROM ( SELECT DISTINCT [Your Column] FROM [your Table] ) a SELECT @str

Collectives™ on Stack Overflow

Multiple Rows to single column using SQL Server

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related