Sql查询结果字符串累加（转）

if object_id('[tb]') is not null drop table [tb]
go 
create table [tb]([Fld1] varchar(1),[Fld2] varchar(4))
insert [tb]
select 'A','STR1' union all
select 'A','STR2' union all
select 'A','STR3' union all
select 'B','STR4' union all
select 'B','STR5'
--------------开始查询--------------------------
select [Fld1], [Fld2]=stuff((select '+'+[Fld2] from tb t where [Fld1]=tb.[Fld1] for xml path('')), 1, 1, '') 
from tb 
group by [Fld1] 
----------------结果----------------------------
/* Fld1 Fld2
---- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
A    STR1+STR2+STR3
B    STR4+STR5

转自CSDN博客http://bbs.csdn.net/topics/320167321