Thread: SUM or What
View Single Post
  #1 (permalink)  
Old November 26th, 2003, 04:19 AM
bertlf bertlf is offline
Registered User
 
Join Date: Nov 2003
Location: Ridgeland, MS, USA.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default SUM or What

Hello, I have a table that has several money columns and want to update multiple records based on my query. The records need to SUM or ADD like so column1 = column1 + column2 then set column2 to 0.
After that a math function runs on all the changed records. Any advice for most efficient way would be welcome. I am using VB6 and ADODB. I can make this happen completely through VB6 but thought that SQL Transaction Processing might be faster and more efficient.
Thanks B