--写一个处理函数
create function f_str(
@id int
)returns varchar(8000)
as
begin
declare @r varchar(8000)
set @r=''
select @r=@r+','+st from 表A where id=@id
return(stuff(@r,1,1,''))
end
go
--调用函数实现处理
insert 表B(id,st)
select id,dbo.f_str(id) from 表A group by id