--1.创建一个合并的函数
create function fmerg(@id int)
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+','+cast(pid as varchar) from 表A where id=@id
set @str=right(@str,len(@str)-1)
return(@str)
End
go
--调用自定义函数得到结果
select distinct id,dbo.fmerg(id) from 表A
建立函数
create function getstr(@gId int)
returns Nvarchar(2000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+N','+value from b
where id=@gid
set @str=right(@str,len(@str)-1)
return @str
end
GO
调用:
select id,dbo.getstr(gid) as value
from (SELECT distinct ID FROM b ) A