UFN_SITEID_MAPFROM_DESIGNATIONLEVELRECIPIENTID

        create function dbo.UFN_SITEID_MAPFROM_DESIGNATIONLEVELRECIPIENTID(@DESIGNATIONLEVELRECIPIENTID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @ID uniqueidentifier;

            SELECT @ID=DESIGNATIONLEVEL.SITEID from dbo.DESIGNATIONLEVELRECIPIENT
            inner join dbo.DESIGNATIONLEVEL on DESIGNATIONLEVELRECIPIENT.DESIGNATIONLEVELID = DESIGNATIONLEVEL.ID
            where DESIGNATIONLEVELRECIPIENT.ID=@DESIGNATIONLEVELRECIPIENTID;

            RETURN @ID;

        end