UPDATE VS4TARInvoiceMB Set TIoMPOSName2=(SELECT TPdtName2 From VS4TProduct WHERE VS4TARInvoiceMB.TIoMTPOSCode=VS4TProduct.TPdtCode) WHERE TIoMPOSName2='' or TIoMPOSName2 is NULL
GO
UPDATE VS4TARInvoiceMB Set TIoMQuantityBase=TIoMQuantity*TIoMUnitFactor WHERE TIoMQuantityBase=0 or TIoMQuantityBase is NULL
GO
UPDATE VS4TARInvoiceMB Set TIoMQuantityCalc=TIoMQuantity WHERE TIoMQuantityCalc=0 or TIoMQuantityCalc is NULL
GO