Stuff and 'For Xml Path' work in Sql ServerSan8yAsked Feb 15, 2018, 12:54 AM1.3kSQLHow Stuff and 'For Xml Path' work in Sql Server
Dharmraj Thakur8y agoPosted Feb 15, 2018, 4:07 AMHere is how to do it...SELECT ID, abc = STUFF( (SELECT ',' + name FROM temp1 t1 WHERE t1.id = t2.id FOR XML PATH ('')) , 1, 1, '') from temp1 t2 group by id; https://stackoverflow.com/questions/31211506/how-stuff-and-for-xml-path-work-in-sql-server+1
Sagar Pandurang Kap8y agoPosted Feb 15, 2018, 1:16 AMHi,VIsit below link it will give you desired answer :- https://stackoverflow.com/questions/31211506/how-stuff-and-for-xml-path-work-in-sql-server Hope it helps....+1
Dharmraj ThakurPosted Feb 15, 2018, 4:07 AM
Sagar Pandurang KapPosted Feb 15, 2018, 1:16 AM