How to get Comma Delimited Values in SQL Server by Grouping?

hi,

try following query

CREATE TABLE #Empl
(
EmpId int,
EmpName varchar (50)
)
CREATE TABLE #Items
(
Itemid int,
ItemDesc varchar(50)
)
CREATE TABLE #Orders
(
OrderId int,
EmpId int,
Itemid int
)

Insert into #Empl values (1, 'Ravi'),
(2, 'Kumar'),
(3, 'Sam'),
(4, 'Telpo')

insert into #Items values(1, 'keyBoard'),
(2, 'Mouse'),
(3, 'Harddrive'),
(4, 'CableBus')
insert into #Orders values (1, 1,2),
(2,1,4),
(3,2,1),
(4,2,3)

select e.EmpId,e.EmpName,(SELECT SUBSTRING((select ',' + ItemDesc
from #Orders o
join #Items i on i.Itemid = o.Itemid
where o.EmpId =e.EmpId
for xml path('')),2,2000)) as csv 
from #Orders o
join #Empl e on e.EmpId = o.EmpId
group by e.EmpId,e.EmpName
 

hope this will help you.