利用临时表合并字符

select col1,col2=cast(col2 as varchar(100))
into #t
from tb
order by col1,col2

select * from #T

--@col1保存上一条col1的值,用一个变量col2保存列的累加值
declare @col1 varchar(10),@col2 varchar(100)
update #t set @col2= case when @col1=col1 then @col2+','+col2
                     else col2
                     end,
@col1=col1, -- 将当前列col1的值变量@clo1

col2=@col2 

 

select col1,max(col2) from #t group by col1

-----------------------------------引用邹建文章