UFN_REVENUEBATCH_GETENHANCEDMATCHINGGIFTS

CREATE function dbo.UFN_REVENUEBATCH_GETENHANCEDMATCHINGGIFTS
(
    @BATCHREVENUEID uniqueidentifier
)
returns table
as 
return
(
    select
        ID,
        MATCHINGCONSTITUENTID,
        ORGANIZATIONID,
        RELATIONSHIPID,
        MATCHINGGIFTCONDITIONID,        
        AMOUNT,
        DATE,
        COULDNOTDEFAULTMATCHINGGIFT,
        case 
            when (select count(*) from dbo.BATCHREVENUEENHANCEDMATCHINGGIFTSPLIT where BATCHREVENUEENHANCEDMATCHINGGIFTID = BATCHREVENUEENHANCEDMATCHINGGIFTS.ID) <> 1 
                then null
            else (select DESIGNATIONID from dbo.BATCHREVENUEENHANCEDMATCHINGGIFTSPLIT where BATCHREVENUEENHANCEDMATCHINGGIFTID = BATCHREVENUEENHANCEDMATCHINGGIFTS.ID)
        end as SINGLEDESIGNATIONID,
        (
            select
                ID,
                DESIGNATIONID,
                AMOUNT,
                SEQUENCE,
        REVENUESPLITID
            from dbo.BATCHREVENUEENHANCEDMATCHINGGIFTSPLIT
            where BATCHREVENUEENHANCEDMATCHINGGIFTID = BATCHREVENUEENHANCEDMATCHINGGIFTS.ID
            for xml raw('ITEM'),type,elements,BINARY BASE64
        ) as SPLITS,        
        cast(ORGANIZATIONID as nvarchar(36)) + cast(MATCHINGCONSTITUENTID as nvarchar(36)) + '1' as RELATIONSHIPCONTEXTID,
    REVENUEMATCHINGGIFTID
    from dbo.BATCHREVENUEENHANCEDMATCHINGGIFTS
    where BATCHREVENUEID = @BATCHREVENUEID
)