UFN_SITEID_MAPFROM_DESIGNATIONLEVELID

Maps a DESIGNATIONLEVELID to a SITEID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@DESIGNATIONLEVELID uniqueidentifier IN

Definition

Copy


        create function dbo.UFN_SITEID_MAPFROM_DESIGNATIONLEVELID(@DESIGNATIONLEVELID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @ID uniqueidentifier;

            SELECT @ID=SITEID from dbo.DESIGNATIONLEVEL where ID=@DESIGNATIONLEVELID;

            RETURN @ID;

        end