sqlserver 2005列转行

isnull(stuff((select ',' + d.comname from projemp a
left outer join emps c on a.empid = c.empid
left outer join coms d on a.comid = d.comid
where a.ProjID = @planprojid for xml path('')), 1, 1, ''), '')

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/wjlstation/p/3290705.html