tab1:
hth cph
S0020020705619 粤FL2389
S0020020705619 粤FL1959
S0021040703643 沪B26433
S0021040703643 沪B26488
S0021040703643 沪B26515
S0021040703643 沪B26506
--合并函数
create function f_tab1(@a varchar)
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str = ’’
select @str = @str ’/’ cast(cph as varchar) from tab1 where hth =@a
set @str = right(@str , len(@str) - 1)
return(@str)
End
GO
--最终语句
select distinct hth ,dbo.f_tab1(hth) from f_tab1