UFN_INSTALLMENT_GETINSTALLMENTSPLITINFO_BULK

CREATE function dbo.UFN_INSTALLMENT_GETINSTALLMENTSPLITINFO_BULK()
returns table
as
return
(
    select
    ISPLIT.ID,
    ISPLIT.PLEDGEID,
    ISPLIT.DESIGNATIONID,
    ISPLIT.INSTALLMENTID,
    ISPLIT.TRANSACTIONAMOUNT,
    ISPLIT.TRANSACTIONCURRENCYID,
    ISPLIT.REVENUESPLITID,
    isnull(IPSPLIT.AMOUNTPAID,0) AMOUNTPAID,
    isnull(IWOSPLIT.AMOUNTWRITTENOFF,0) AMOUNTWRITTENOFF,
    isnull(IPSPLIT.PAYMENTCOUNT, 0) PAYMENTCOUNT,
    isnull(IWOSPLIT.WRITEOFFCOUNT, 0) WRITEOFFCOUNT
from
    dbo.INSTALLMENTSPLIT ISPLIT
    left join (select
                    INSTALLMENTSPLITID,
                    sum(AMOUNT) AMOUNTPAID,
                    count(ID) PAYMENTCOUNT
                from
                    dbo.INSTALLMENTSPLITPAYMENT
                group by INSTALLMENTSPLITID) IPSPLIT on ISPLIT.ID=IPSPLIT.INSTALLMENTSPLITID
    left join (select
                    INSTALLMENTSPLITID,
                    sum(AMOUNT) AMOUNTWRITTENOFF,
                    count(ID) WRITEOFFCOUNT
                from
                    dbo.INSTALLMENTSPLITWRITEOFF
                group by INSTALLMENTSPLITID) IWOSPLIT on ISPLIT.ID=IWOSPLIT.INSTALLMENTSPLITID
)