UFN_MEMBER_RAISEDBYAPPEAL

            CREATE function dbo.UFN_MEMBER_RAISEDBYAPPEAL
            (@STARTDATE datetime, @ENDDATE datetime)
            returns @REVENUEINFO table
            (
                APPEALID uniqueidentifier NOT NULL,
                TOTALRECEIVED money NOT NULL
            )
            as
            begin

                select @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(@STARTDATE),
                        @ENDDATE = dbo.UFN_DATE_GETLATESTTIME(@ENDDATE);

                insert into @REVENUEINFO
                    select R.APPEALID, coalesce(SUM(RS.AMOUNT),0) TOTALRECEIVED
                    from dbo.REVENUE R
                    inner join dbo.REVENUESPLIT RS on R.ID = RS.REVENUEID
                    inner join dbo.APPEAL A on A.ID = R.APPEALID
                    where (R.APPEALID is not null) and (R.DATE >= @STARTDATE or @STARTDATE is null) and
                        (R.DATE <= @ENDDATE or @ENDDATE is null) and 
                         (R.TRANSACTIONTYPECODE = 0) and
                         (R.CONSTITUENTID in
                            (select M.CONSTITUENTID
                             from dbo.MEMBER M
                             inner join dbo.MEMBERSHIP MS on MS.ID = M.MEMBERSHIPID
                             where A.MEMBERSHIPPROGRAMID = MS.MEMBERSHIPPROGRAMID))
                    group by R.APPEALID;


                    return;


            end