Select *,actionname= Stuff ((select ', ' + actionname from sys_action_table where ModuleID = Sys_module_table.moduleid for X ML path (")), 1, 1, ') from sys_module_table
Query results
With Awardt as (select A.personname,d.awardname, c.activityname,d.typename from T_person a join T_per Sonawardr b on A.id=b.personid join t_activity C on b.activityid=c.id join T_award D on D.id=b.awardid where c.activityname= ' million race ' and D.typename= ' excellent Moderator Award ') Select B.awardname,left (AWA Rds,len (awards)-1) as awards from (Select Awardname, (select Personname+ ', ' from Awardt WHERE awardname=a.awardname for X ML path (")) as Awardsfrom Awardt A Group by Awardname) B
SELECT A.awardnaame,
STUFF ((SELECT ', ' + table1.personname
From table1
WHERE Table1.awardnaame = A.awardnaame
For
XML PATH (")
), 1, 1, ') as PersonName
From (SELECT awardnaame
From table1
GROUP by Awardnaame
) A
A very useful MSSQL statement.