首页 > 代码库 > 多行内容放到一行中(内容的合并)

多行内容放到一行中(内容的合并)

ALTER view [dbo].[view_weiswysjl]
as
select distinct m.dbid,m.baogbh,m.chanpmc,m.jianymdyq,m.weitrq,(‘,‘+s.jjy+‘,‘) as jjy from mainexam m inner join
(select baogbh,STUFF( (SELECT ‘,‘+jjy from secexam s2 WHERE s1.baogbh=s2.baogbh FOR XML PATH(‘‘)),1,1,‘‘) jjy from secexam s1 ) s
on m.baogbh=s.baogbh
 where dbstatus>0 and dbstatus!=9
GO

 

多行内容放到一行中(内容的合并)