UPDATE #ShipLog
		SET Media_Copies = Media_Copies + (SELECT Media_Copies FROM #ShipLog WHERE Region = 'East' AND Job_Type = 'CD')
			WHERE Region = 'West' AND Job_Type = 'CD'

	UPDATE #ShipLog
		SET Media_Copies = 0
			WHERE Region = 'East' AND Job_Type = 'CD'

UPDATE #ShipLog
SET Media_Copies = CASE WHEN SUM(CASE WHEN Region ='East' AND Job_Type = 'CD' THEN 1 ELSE 0 END) OVER () = 6 AND Region = 'East' THEN 0 ELSE Media_Copies + 3 END
WHERE Region in ('East','West','South') AND Job_Type = 'CD'

UPDATE s
SET Media_Copies = CASE WHEN EastTotal >0 AND Region = 'East' THEN 0 ELSE Media_Copies + EastTotal/2 END
FROM (SELECT *,SUM(CASE WHEN Region ='East' AND Job_Type = 'CD' THEN 1 ELSE 0 END) OVER () AS EastTotal FROM #ShipLog)s
WHERE Region in ('East','West','South') AND Job_Type = 'CD'

quote:

---

Originally posted by servmgr2004

It errors on the "s" at the end of the FROM statement.

---