How can I get around error (without changing file to allow nulls)?
update bzcontract a set XDPCV =
(select sum(CMPAMT) from pricecmp b, ctltable
where a.ACNTNMB = b.ACNTNMB
and CTLTABLE = 'PRICE COMP' and cmptype = CTLELEMENT
and CTLFLAG1 = 'Y'
group by ACNTNMB)
Null values not allowed in column or variable XDPCV.
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com