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

 

posted on 2013-05-25 10:29  YuanSong  阅读(3373)  评论(0)  编辑  收藏  举报

导航