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.