UFN_REVENUEUPDATEBATCH_GETSPLITS

    CREATE function dbo.UFN_REVENUEUPDATEBATCH_GETSPLITS(@REVENUEID uniqueidentifier)
            returns table
            as
            return
            (
                select
                  '00000000-0000-0000-0000-000000000000' as ID, 
                  REVENUESPLIT.DESIGNATIONID, 
                  TRANSACTIONAMOUNT as AMOUNT,    
                  ROW_NUMBER() OVER(order by REVENUESPLIT.dateadded) as SEQUENCE,
                  REVENUESPLIT.APPLICATIONCODE, 
                  REVENUESPLIT.TYPECODE,
                  1 as DIDCAMPAIGNSDEFAULT,
                    (select
                        '00000000-0000-0000-0000-000000000000' as ID,
                        CAMPAIGNID,
                        CAMPAIGNSUBPRIORITYID,
                        REVENUESPLITCAMPAIGN.ID as REVENUESPLITCAMPAIGNID                        
                        from dbo.REVENUESPLITCAMPAIGN
                        where REVENUESPLITCAMPAIGN.REVENUESPLITID = REVENUESPLIT.ID
                        for xml raw('ITEM'),type,elements,BINARY BASE64) as CAMPAIGNS,
                    coalesce(REVENUESPLITGIFTAID.DECLINESGIFTAID, cast(0 as bit)) as DECLINESGIFTAID,
                    coalesce(REVENUESPLITGIFTAID.ISSPONSORSHIP, cast(0 as bit)) as ISGIFTAIDSPONSORSHIP,
                    REVENUESPLIT.ID as REVENUESPLITID,
                    REVENUESPLIT.TRANSACTIONCURRENCYID
                from dbo.REVENUESPLIT 
                left outer join dbo.REVENUESPLITGIFTAID on REVENUESPLITGIFTAID.ID = REVENUESPLIT.ID
                where REVENUEID = @REVENUEID

            )