can we make multiple rows as comma seperated in SQL Query?

Question

query should return something like:

1, "john,mike,petra"
2, "bob,carl,sandra,peter,
etc

Please rephrase your question as it is unclear what you are trying to achieve. — Daniel Hilgarth, Apr 07 '11 at 08:55
What does your data look like? What kind of queries have you attempted? — Tommi, Apr 07 '11 at 09:05

score 1 · Answer 1 · answered Apr 07 '11 at 09:00

1

This can easily be acomplished via Management Studio enter image description here

answered Apr 07 '11 at 09:00

Mick Walker

score 1 · Accepted Answer · answered Apr 07 '11 at 11:28

Do you want the all the columns to be comma separated and concatenated as a single string for each row? If yes, you can use this code.

select Name+','+Phone_NO+','+Address from <table_name>

Result will be looked like the following lines:

If your column is not varchar type then you have to cast the columns.

2 Answers2