"Miha Markic" <miha at rthand com> wrote in message
news:eTkAtJXDIHA.4360@TK2MSFTNGP06.phx.gbl...
> Stored procedure is a way to go.
>
> --
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>
> "VB Programmer" <donotemailme@somewhere.com> wrote in message
> news:%23ZpeK5UDIHA.4752@TK2MSFTNGP04.phx.gbl...
>>I am working on an ASP.NET 2.0 banking-type application. No, it's NOT a
>>school question! This is a real-world web application. :)
>>
>> The table "Transactions" contain all types of individual "transactions" -
>> interest_payment, deposits, withdrawals & fees mostly. Each of these
>> entries are related to an "account". (So, of course, summing all of
>> these would give the current account "balance".)
>>
>> On a nightly basis I have to do this...
>> FOR EACH "account" I need to (1) get the current "balance" of the
>> account, (2) increase it by a small set percentage (all accounts get the
>> same % increase) then (3) insert a NEW interest_payment record in the
>> Transactions table for EACH account.
>>
>> Any idea how I should go about this?
>>
>> I'm not sure if I can do this in 1 or 2 steps (like a large SQL
>> statement) or if I have to write some VB.NET code and loop thru every
>> record. I'd appreciate your insight.
>>
>> Thanks in advance!
>>
>

"Cor Ligthert [MVP]" <notmyfirstname@planet.nl> wrote in message
news:%23%23geIwxDIHA.5752@TK2MSFTNGP02.phx.gbl...
> VB Programmer,
>
> You know that any solution given in a newsgroup is as it is.
>
> There is not any guarantee that it is working or will work or be a true
> solution even if the answer is given by Microsoft people.
>
> This message to prevent that you think that you ever can refer by problems
> to answers given in a newsgroup.
>
> This especially because that in a banking application there can be high
> financial risc for the developer.
>
> Cor
>