JOIN

You simply need to do SUM in your subquery, e.g.

UPDATE ARH SET [OPEN] = 'TRUE', CLOSEDATE = NULL, PAID = ARH.PAID - NEW.AMOUNT FROM

(SELECT INVOICE, SUM(AMOUNT) AS AMOUNT FROM CREDITMEMO WHERE CINVOICE = 113202
GROUP BY Invoice

) AS NEW JOIN ARH ON ARH.INVOICE=
NEW.INVOICE

In SQL 2008 and up I recommend to use MERGE command instead of UPDATE-FROM syntax.

---

For every expert, there is an equal and opposite expert. - Becker's Law





My blog



My TechNet articles