34,575
社区成员
发帖
与我相关
我的任务
分享
Create function fn_merge(@deptid int)
returns varchar(1000)
as
begin
declare @str varchar(1000)
set @str=''
select @str=@str+','+bblistid from 表 where deptid=@deptid
set @str=stuff(@str,1,1,'')
return @str
end
go
select deptid,dbo.fn_merge(deptid) as bblistid from 表 group by deptid