Loading

display the name separated with single cell using sql server

narasiman rao

Empid Empname Salary

1 Ram 15000
2 Ramesh 20000
3 Ravi 25000
4 Sam 30000
5 Ganesh 35000

i want to display Empname in single cell separated with space.

i want the output as follows Empname in single cell

Ram Ramesh Ravi Sam Ganesh.

for that how to write the query in sql server.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dharmraj Thakur9y ago
SELECT
STUFF(
(
SELECT ' '+ EmpName from Employee FOR XML PATH('')
),1,1,'') as Employees
-1
Abhinav Abhishek9y ago
SELECT
STUFF(
(
SELECT ','+ [EmpName] FROM Employee FOR XML PATH('')
),1,1,'')
0