UFN_BANKACCOUNTDEPOSIT_GETTOTALAMOUNT

            create function dbo.UFN_BANKACCOUNTDEPOSIT_GETTOTALAMOUNT
            (
                @ID uniqueidentifier
            )
            returns numeric(19,4)
            with execute as caller
            as begin
                declare @TOTAL integer;
                select @TOTAL = sum(amount) 
                    from dbo.BANKACCOUNTPAYMENT 
                    where BANKACCOUNTDEPOSITID=@ID
                return @TOTAL
            end