UPDATE vs4tproduct2 set TPd2StdDL=0,TPd2StdOH=0
GO
UPDATE VS4TInventoryLOT Set TIMCSOH=(SELECT TPd2StdOH FROM VS4TProduct2 WHERE VS4TProduct2.TPD2TPDTCode=VS4TInventoryLOT.TIMCTPDtCode) WHERE TIMCSOH is null
GO
UPDATE VS4TInventoryLOT Set TIMCSOH=0 WHERE TIMCSOH is null
GO
UPDATE VS4TInventoryLOT Set TIMCOS=0 WHERE TIMCOS is null
GO