Acc Plan 101 A 101 B 101 C i want result like Acc Plan 101 A,B,C
select Acc, stuff((Select ',' + cast(T1.Plan1 as varchar) FROM #temp T1 WHERE T1.Acc = T.Acc GROUP BY T1.Plan1 for xml path('')) ,1,1,'') FROM #temp T group by Acc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)