UFN_SITEID_MAPFROM_DESIGNATIONLEVELGOALID

        create function dbo.UFN_SITEID_MAPFROM_DESIGNATIONLEVELGOALID(@DESIGNATIONLEVELGOALID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @ID uniqueidentifier;

            SELECT @ID=DESIGNATIONLEVEL.SITEID from dbo.DESIGNATIONLEVELGOAL
            inner join dbo.DESIGNATIONLEVEL on DESIGNATIONLEVELGOAL.DESIGNATIONLEVELID = DESIGNATIONLEVEL.ID
            where DESIGNATIONLEVELGOAL.ID=@DESIGNATIONLEVELGOALID;

            RETURN @ID;

        end