UFN_BANKACCOUNTTRANSACTION_GETNEXTNUMBER

            CREATE function dbo.UFN_BANKACCOUNTTRANSACTION_GETNEXTNUMBER
            (
                @BANKACCOUNTID uniqueidentifier,
                @TRANSACTIONFLAGCODE int
            )
            returns integer
            with execute as caller
            as begin
                declare @NUMBER integer;

                select @NUMBER = ISNULL(MAX(TRANSACTIONNUMBER),0) + 1
                            from dbo.BANKACCOUNTTRANSACTION
                            where BANKACCOUNTID=@BANKACCOUNTID and TRANSACTIONFLAGCODE=@TRANSACTIONFLAGCODE

                return @NUMBER
            end