有点难度的...

Question

create function f_1(@year int)
returns varchar(8000)
as
begin
declare @s varchar(8000)
set @s=''
select @s=@s+quarter from tb1 where year=@year
return @s
end
go
select year,quarter=dbo.f_1(year) from tb1 group by year

Answer 1

create function f_str(@year int)
returns varchar(8000)
as
begin
      declare @str varchar(8000)
      set @str=''
      select @str=@str+Quarter from 表 where [Year]=@year
      return @str
end
go
-- 查询 
 select [Year],dbo.f_str([Year])
from 表 group by [Year]