UPDATE VS4TInventoryMB SET TInMTACPID=(SELECT MONTH(TInvDATE) FROM VS4TInventory WHERE VS4TInventory.tinvno=VS4TInventorymb.tinmtinvno)
GO
UPDATE VS4TInventoryMB SET TInMTACPTACYID=(SELECT YEAR(TInvDATE) FROM VS4TInventory WHERE VS4TInventory.tinvno=VS4TInventorymb.tinmtinvno)
GO
