UFN_CONSTITID_MAPFROM_TRIBUTEID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@TRIBUTEID uniqueidentifier IN

Definition

Copy

create function BBDW.[UFN_CONSTITID_MAPFROM_TRIBUTEID] (@TRIBUTEID uniqueidentifier) 

returns uniqueidentifier

as

begin

    declare @ID uniqueidentifier;

    select @ID = [TRIBUTEECONSTITUENTSYSTEMID] from BBDW.[DIM_TRIBUTE] where [TRIBUTESYSTEMID] = @TRIBUTEID;

    return @ID;

end;