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

Try:


    UPDATE TableName
        SET Column1 = Column1 + Column2,
            Column2 = 0
    WHERE -- Limit to the correct rows.


John R Lick
[email protected]

Thanks John,
That helped a lot!
I have much to learn and this project has been a fun challenge.
B