UFN_BBNC_KPI_ALLREVENUENOTFORCHANNEL

        CREATE function dbo.UFN_BBNC_KPI_ALLREVENUENOTFORCHANNEL(@STARTDATE datetime, @ENDDATE datetime)
        returns @NONBBNCREVENUE table
        (
            REVENUEID uniqueidentifier,
            REVENUESPLITID uniqueidentifier, 
            REVENUETYPECODE tinyint,
            REVENUEAMOUNT money,
            REVENUEDATE datetime
        )
        as
        begin
            insert into @NONBBNCREVENUE(REVENUEID, REVENUESPLITID, REVENUETYPECODE, REVENUEAMOUNT, REVENUEDATE)
                select
                    REVENUE.ID,
                    REVENUESPLIT.ID,
                    0,
                    REVENUESPLIT.AMOUNT,
                    REVENUE.DATE
                from dbo.REVENUESPLIT
                inner join dbo.REVENUE on REVENUE.ID = REVENUESPLIT.REVENUEID
                left join dbo.UFN_BBNC_KPI_ALLREVENUEFORCHANNEL(@STARTDATE, @ENDDATE) as [BBNCREVENUE] on [BBNCREVENUE].REVENUEID = REVENUE.ID and [BBNCREVENUE].REVENUESPLITID = REVENUESPLIT.ID
                where [BBNCREVENUE].REVENUEID is null 
              and [BBNCREVENUE].REVENUESPLITID is null
              and REVENUE.DATE between @STARTDATE and @ENDDATE;

            return;
        end