通过表c
想实现如下表的效果,
,如题:
利用sqlserver内部自定义函数,并调用函数实现,实现如下:
if object_id('f_hb') is not null
drop function dbo.f_hbgo
create function dbo.f_hb(@id char(10))
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+';'+b from c where a=@id
set @str=right(@str,LEN(@str)-1)
return(@str)
end
go
select distinct a,dbo.f_hb(a) as b from c