Hi Guys, I have one 'DataTable' and I want to Data like in 'ResultTable' using Sql Query so , I want that Query if U have Ans. then Reply me. 'Data Table' MemberID MemberName FruitName 1 A1 Apple 1 A1 Orange 'Result Table' MemberID MemberName FruitName 1 A1 Apple, Orange Thanks........ Pnkl Patel

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