连接多行记录,使成为一个字段
如题:
ID productname
--------------------------------
1 'a'
1 'b'
1 'c'
结果:
ID productName
--------------------------------
1 'a,b,c'
CREATE function [dbo].[f_productName](@c varchar(200), @d varchar(200))
returns varchar(100)
as
begin
declare @b varchar(200)
set @b=''
select @b=@b+ProductName+',' from v_OutCustoms where CLPNo=@c and HSCode = @d
if len(@b) > 1
set @b=left(@b,len(@b)-1)
return(@b)
end
ID productname
--------------------------------
1 'a'
1 'b'
1 'c'
结果:
ID productName
--------------------------------
1 'a,b,c'
CREATE function [dbo].[f_productName](@c varchar(200), @d varchar(200))
returns varchar(100)
as
begin
declare @b varchar(200)
set @b=''
select @b=@b+ProductName+',' from v_OutCustoms where CLPNo=@c and HSCode = @d
if len(@b) > 1
set @b=left(@b,len(@b)-1)
return(@b)
end