UPDATE VS4TInventoryLOT SET TIMCCostDecimal=(SELECT TsysValue from VS4TSystem WHERE TSysName='DecimalCost') WHERE TIMCCostDecimal is null
GO
UPDATE VS4TInventoryLOT SET TIMCCostDecimal=(SELECT TsysValue from VS4TSystem WHERE TSysName='DecimalPurchasePrice') WHERE TIMCCostDecimal is null
GO
UPDATE VS4TInventoryLOT SET TIMCCostDecimal=9 WHERE TIMCCostDecimal is null
GO
