SQL 合并多条记录成一条记录
update QGJVector..ProjectVector set Tag=c.subennmcd from QGJVector ..ProjectVector Left join (select distinct pennmcd , STUFF ( (select replace('$'+branchennmcd,' ','') from gq_ok ..[0510_swinfo] where pennmcd =a.pennmcd for XML path('') ) ,1,1,'') as subennmcd from gq_ok ..[0510_swinfo] a )c on c.pennmcd=QGJVector ..ProjectVector.Code