UFN_MEMBER_APPEALSOLICITEDCOUNTS

            create function dbo.UFN_MEMBER_APPEALSOLICITEDCOUNTS
            (@STARTDATE datetime, @ENDDATE datetime)
            returns @REVENUEINFO table
            (
                APPEALID uniqueidentifier NOT NULL PRIMARY KEY CLUSTERED,
                SOLICITEDCOUNT int NOT NULL
            )
            as
            begin

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

                insert into @REVENUEINFO
                select
                    a.ID,
                    coalesce((select sum(msa.QUANTITY)
                            from MKTSEGMENTATIONACTIVE msa
                            where exists( 
                                select ca.ID
                                    from CONSTITUENTAPPEAL ca
                                    inner join dbo.MEMBER m on m.constituentid = ca.constituentid
                                    inner join dbo.MEMBERSHIP ms on ms.id = m.membershipid
                                    where (@STARTDATE is null or ca.DATESENT >= @STARTDATE) and
                                        (@ENDDATE is null or ca.DATESENT <= @ENDDATE) and
                                        (ca.APPEALID=a.ID and ca.MKTSEGMENTATIONID=msa.ID) and
                                        (MS.MEMBERSHIPPROGRAMID = A.MEMBERSHIPPROGRAMID))), 0)
                from APPEAL a
                where A.MEMBERSHIPPROGRAMID is not null;



                return;


            end