UFN_SITEID_MAPFROM_DESIGNATIONLEVELRELATEDSTAFFID

        CREATE function dbo.UFN_SITEID_MAPFROM_DESIGNATIONLEVELRELATEDSTAFFID(@DESIGNATIONLEVELRELATEDSTAFFID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @ID uniqueidentifier;

            SELECT @ID=DESIGNATIONLEVEL.SITEID from dbo.DESIGNATIONLEVELRELATEDSTAFF
            inner join dbo.DESIGNATIONLEVEL on DESIGNATIONLEVELRELATEDSTAFF.DESIGNATIONLEVELID = DESIGNATIONLEVEL.ID
            where DESIGNATIONLEVELRELATEDSTAFF.ID=@DESIGNATIONLEVELRELATEDSTAFFID;

            RETURN @ID;

        end