UFN_SITEID_MAPFROM_DESIGNATIONLEVELNOTEID

        create function dbo.UFN_SITEID_MAPFROM_DESIGNATIONLEVELNOTEID(@DESIGNATIONLEVELNOTEID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @ID uniqueidentifier;

            SELECT @ID=DESIGNATIONLEVEL.SITEID from dbo.DESIGNATIONLEVELNOTE
            inner join dbo.DESIGNATIONLEVEL on DESIGNATIONLEVELNOTE.DESIGNATIONLEVELID = DESIGNATIONLEVEL.ID
            where DESIGNATIONLEVELNOTE.ID=@DESIGNATIONLEVELNOTEID;

            RETURN @ID;

        end