將同組數據用分隔符合併(2)

drop table #temp
create table  #temp(po char(10), rmk varchar(2000))

insert into #temp select 'po1', 'rmk1'
insert into #temp select 'po1', 'rmk2'
insert into #temp select 'po1', 'rmk3'
insert into #temp select 'po2', 'rmk11'
insert into #temp select 'po2', 'rmk222'
insert into #temp select 'po3', 'rmk3'

--select * from #temp

declare @rmk varchar(2000)
declare @grp char(10)
update  #temp
set @rmk= (case when po=@grp
  then rtrim(@rmk) +rtrim(rmk)+';'
  else rtrim(rmk)+';' end),
 @grp=po,
 rmk=@rmk
from  #temp

 

select * from  #temp a
where len(rmk)=(select max(len(rmk)) from #temp b where a.po=b.po)