Convert multiple rows into one with coma as separator

Question

If I issue SELECT ID FROM TestAhmet I get this result:

but what I really need is one row with all the values separated by comma, like this:

1,2,3,4,5

How do I do this?

ps: I cant do this : Convert multiple rows into one with comma as separator

stuff is the simplest way to do it, why can't use use that? – Zohar Peled Jul 06 '15 at 12:20 — Zohar Peled, Jul 06 '15 at 12:20

Gordon Linoff · Answer 1 · 2015-07-07T02:23:11.517

1

This should work:

select stuff((select ',' + cast(id as varchar(8000))
              from TestAhmet
              for xml path ('')
             ), 1, 1, '') as users

This is a variation on the string aggregation logic often used in SQL Server. But, without a group by, you probably won't find many examples on the web.

edited Jul 07 '15 at 02:23

answered Jul 06 '15 at 12:20

Gordon Linoff

1,198,228
53
572
709

Sorry. It was "ID" not "username. – Ahmet Bulut Jul 06 '15 at 12:25

score 1 · Answer 2 · answered Jul 06 '15 at 12:32

1

If id is numeric column then do like this

select stuff((select ',' +Convert(varchar(50),id)
              from TestAhmet
              for xml path ('')
             ), 1, 1, '') as users

answered Jul 06 '15 at 12:32

Mukesh Kalgude

4,742
2
16
32

It it is help out then given right mark and vote – Mukesh Kalgude Jul 06 '15 at 12:44

Convert multiple rows into one with coma as separator

2 Answers2