UFN_INSTALLMENT_GETINSTALLMENTSPLITWRITEOFFAMOUNT

            create function dbo.UFN_INSTALLMENT_GETINSTALLMENTSPLITWRITEOFFAMOUNT(
                @INSTALLMENTSPLITID uniqueidentifier
            )
            returns money
            with execute as caller
            as begin
                declare @WRITEOFFAMOUNT money;

                select 
                    @WRITEOFFAMOUNT = sum(coalesce(INSTALLMENTSPLITWRITEOFF.AMOUNT,0))
                from dbo.INSTALLMENTSPLIT 
                left join dbo.INSTALLMENTSPLITWRITEOFF 
                    on INSTALLMENTSPLITWRITEOFF.INSTALLMENTSPLITID = INSTALLMENTSPLIT.ID
                where 
                    INSTALLMENTSPLIT.ID = @INSTALLMENTSPLITID;

                return @WRITEOFFAMOUNT;
            end