UFN_SITEID_MAPFROM_MEMBERSHIPID

            create function dbo.UFN_SITEID_MAPFROM_MEMBERSHIPID
            (
                @MEMBERSHIPID uniqueidentifier 
            )
            returns uniqueidentifier 
            as 
            begin
                DECLARE @ID uniqueidentifier;

                SELECT @ID=SITEID from dbo.MEMBERSHIPPROGRAM 
                left join dbo.MEMBERSHIP 
                on MEMBERSHIPPROGRAM.ID=MEMBERSHIP.MEMBERSHIPPROGRAMID
                where MEMBERSHIP.ID=@MEMBERSHIPID;

        RETURN @ID;

       end