same group name field value join by , in sql server query

hi,

try following query

select MemberID,MemberName,SUBSTRING(
(SELECT ',' + s.FruitName
FROM #Test s
where s.MemberID = org.MemberID
FOR XML PATH('')),2,200000) AS CSV from #Test org
group by MemberID,MemberName

hope this will help you.

Hello Pnkl Patel,

i think following might help you:

Declare @FruitNames varchar(MAX)
Select @FruitNames = COALESCE(@FruitNames+',' ,'')+FruitName from DataTable where MemberID = 1
Select MemberID, MemberName, @FruitNames as FruitName from DataTable
where MemberID = 1
group by MemberID, MemberName

Thanks and Regards