create function getlist (@name varchar(5)) returns varchar(400)
as
begin
declare @list varchar (400)
select @list=''
select @list =@list + fieldB from tblA where fieldA =@name
return @list
end
go
select fieldA ,dbo.getlist(fieldA) from tblA group by fieldA
create function getstr(@fieldA Nchar(20))
returns Nvarchar(2000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+N','+rtrim(fieldB) from tblA
where fieldA=@fieldA
set @str=right(@str,len(@str)-1)
return @str
end
GO
调用:
select distinct fieldA,dbo.getstr(fieldA) as fieldB from tbl