how to get multiple cell values in a single cell in sqlserver

Question

i want to get all the employee names in one cell in sqlserver. values should come with comma separated in one cell.

output
arvind
chang
deepak

desired output

Arvind, Chang, Deepak

query

select EmpName from Employee

Tien Nguyen Ngoc · Accepted Answer · 2017-06-19T10:56:46.903

0

 SELECT STUFF((SELECT ', ' + upper(left(EmpName,1)) + substring(EmpName,2,len(EmpName))
            FROM Employee
            FOR XML PATH('')) ,1,1,'') AS EmpName

I hope it will work for you.

edited Jun 19 '17 at 10:56

answered Jun 19 '17 at 10:42

Tien Nguyen Ngoc

1,555
1
8
17

thanks its working but i need first letter of all names should be Capital. – pvkm Jun 19 '17 at 10:45
I've edited with first letter is UPPER – Tien Nguyen Ngoc Jun 19 '17 at 10:57
there is space coming between name and comma.which shouldn't come, after comma there should be some space but not before the comma. – pvkm Jun 19 '17 at 11:00
You can remove space in **SELECT ', '**. There will be not space coming between name and comma. – Tien Nguyen Ngoc Jun 19 '17 at 11:05

how to get multiple cell values in a single cell in sqlserver

1 Answers1