UFN_SITEID_MAPFROM_DESIGNATIONLEVELSTEWARDSHIPRECIPIENTID

        create function dbo.UFN_SITEID_MAPFROM_DESIGNATIONLEVELSTEWARDSHIPRECIPIENTID(@DESIGNATIONLEVELSTEWARDSHIPRECIPIENTID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @ID uniqueidentifier;

            SELECT @ID=DESIGNATIONLEVEL.SITEID from dbo.DESIGNATIONLEVELSTEWARDSHIPRECIPIENTS
            inner join dbo.DESIGNATIONLEVEL on DESIGNATIONLEVELSTEWARDSHIPRECIPIENTS.DESIGNATIONLEVELID = DESIGNATIONLEVEL.ID
            where DESIGNATIONLEVELSTEWARDSHIPRECIPIENTS.ID=@DESIGNATIONLEVELSTEWARDSHIPRECIPIENTID;

            RETURN @ID;

        end