alter function Fn_GetUserGroupRelation
(
@DHsItemID int
)
returns nvarchar(1024)
begin
declare @Col_HsItemID int
declare @Result nvarchar(1024)
set @Result=''
select @Col_HsItemID = Col_HsItemID from Hs_Relation where Col_DHsItemID=@DHsItemID
if @Col_HsItemID <> 1
begin
set @Result = dbo.Fn_GetUserGroupRelation(@Col_HsItemID) + '#' + convert(nvarchar(1024),@Col_HsItemID)
end
return @Result
end
---select dbo.Fn_GetUserGroupRelation(7)