Thread: SUM or What
View Single Post
  #2 (permalink)  
Old November 26th, 2003, 12:11 PM
jlick jlick is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Sparks, NV, USA.
Posts: 101
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jlick
Default

Try:


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


John R Lick
JohnRLick@hotmail.com