如何把重复的行合并？
如何把重复的行合并？
有表TAB如下

IDDESC
1A
2B
1C

合并后得到如下结果

IDDESC
1A，C
2B

依此类推，有多个重复的则以‘，’分隔


[解决办法]
create table test(ID int,[DESC] varchar(10))
insert test select 1, 'A '
union all select 2, 'B '
union all select 1, 'C '

create function dbo.fn_Merge(@ID int)
returns varchar(8000)
as
begin
declare @name varchar(8000)
set @name= ' '
select @name=@name+ ', '+[DESC] from test where ID=@ID
return stuff(@name,1,1, ' ')
end
go

select ID, dbo.fn_Merge(ID) as ID from test group by ID

drop table test
drop function fn_Merge

ID ID
----------- ----
1 A,C
2 B