UFN_BANKACCOUNT_GETDEPOSITNAME

                CREATE function dbo.UFN_BANKACCOUNT_GETDEPOSITNAME(@ID uniqueidentifier) returns nvarchar(100) 
                as
                begin
                    declare @DEPOSITDESC nvarchar(100)

                    select @DEPOSITDESC = Cast(TRANSACTIONNUMBER as nvarchar(10)) + ' - ' + 
                    dbo.UFN_BANKACCOUNT_GETACCOUNTNAME(BANKACCOUNTID) from dbo.BANKACCOUNTTRANSACTION where ID = @ID

                    return @DEPOSITDESC
                end