create function dbo.uf_getstrs(@flag int) returns varchar(1000) as begin declare @s varchar(1000) set @s = '' select @s = @s+name+',' from 表 where flag=@flag set @s=left(@s,len(@s)-1) return @s end go select flag,dbo.uf_getstrs(flag) as name,sum(price) as price from 表 group by flag
returns varchar(1000)
as
begin
declare @s varchar(1000)
set @s = ''
select @s = @s+name+',' from 表 where flag=@flag
set @s=left(@s,len(@s)-1)
return @s
end
go
select flag,dbo.uf_getstrs(flag) as name,sum(price) as price
from 表
group by flag