Need help please with an update command... UPDATE TABLE + SET t1.billing_amt = (t1.da_fee + t2.adjusted_total) + FROM d_b_allocation t1, d_invoice_header t2 + WHERE t1.invoice_id = t2.invoice_id
The statement above works fine but acts upon the whole table. I want to limit the update to: AND t1.da_invoice_dt = 12/20/04 No matter where I put: AND t1.da_invoice_dt = 12/20/04, it says there are no records at all to update. I even tried to put the UPDATE statement inside a cursor while loop and even though it doesn't generate any errors, it doesn't update anything. Thanks for any and all suggestions :)
