update vs4tinventoryMB set tinmsourceType=0 where tinmsourceType is null
GO
update vs4tinventoryLOT set timcdutyamount=0 where timcdutyamount is null
GO
UPDATE VS4TInventoryLOT Set TIMCQuantityCalc=TIMCUnitRatioC WHERE TIMCQuantityCalc is NULL
GO
update vs4tinventorylot set TIMCQuantityCalc=1 where TIMCQuantityCalc=0 or TIMCQuantityCalc is null
GO