相同则写入组合

create table tb(no int,b varchar(10))

insert into tb select 1,'2'
union all select 1,'3'
union all select 1,'4'
union all select 2,'5'
union all select 2,'6'
union all select 2,'7'
go

create function dbo.fc_str(@no varchar(100))
returns varchar(100)
as
begin
 declare @sql varchar(1000)
 set @sql=''
 select @sql=@sql+' '+cast(b as varchar(100)) from tb where no=@no
 return stuff(@sql,1,1,'')
end
go

select no,dbo.fc_str(no) as b from tb group by no