关于ms sql 函数的问题
我建立了一个名为f_hb
create function f_hb(@nuserid int)
returns varchar(50)
as
begin
declare @str varchar(50)
set @str = ' '
select @str = @str + ', ' + cast(ntrade as varchar) from tb_Person_Job where nuserid = @nuserid
set @str = right(@str , len(@str) - 1)
return(@str)
End
然后建立了一个视图
create view view_ttt as
select nuserid,dbo.f_hb(nuserid) as nTrade from tb_Person_Job
group by nuserid
------------------------------------------------------
现在view_ttt显示的结果是这样的
nuserid ntrade
---------- ----------------
58105 001,001,006
58104 001,001,001
58106 001,002
我想要的结果是这样的，没有重覆的
nuserid ntrade
---------- ----------------
58105 001,006
58104 001
58106 001,002
也就是说，如何在f_hb添加一个判断语句，去掉重覆的数据
[解决办法]
create function f_hb(@nuserid int)
returns varchar(50)
as
begin
declare @str varchar(50)
set @str = ' '
select @str = @str + ', ' + cast(ntrade as varchar) from (select distinct ntrade from tb_Person_Job where nuserid = @nuserid) t
set @str = right(@str , len(@str) - 1)
return(@str)
End
go
