insert into newdb..iv40400 (ITMCLSCD ,ITMCLSDC ,DEFLTCLS ,NOTEINDX ,ITEMTYPE ,ITMTRKOP ,LOTTYPE ,KPERHIST ,KPTRXHST ,KPCALHST ,KPDSTHST ,ALWBKORD ,ITMGEDSC ,TAXOPTNS ,ITMTSHID ,Purchase_Tax_Options ,Purchase_Item_Tax_Schedu ,UOMSCHDL ,VCTNMTHD ,USCATVLS_1 ,USCATVLS_2 ,USCATVLS_3 ,USCATVLS_4 ,USCATVLS_5 ,USCATVLS_6 ,DECPLQTY ,IVIVINDX ,IVIVOFIX ,IVCOGSIX ,IVSLSIDX ,IVSLDSIX ,IVSLRNIX ,IVINUSIX ,IVINSVIX ,IVDMGIDX ,IVVARIDX ,DPSHPIDX ,PURPVIDX ,UPPVIDX ,IVRETIDX ,ASMVRIDX ,PRCLEVEL ,PriceGroup ,PRICMTHD ,TCC ,Revalue_Inventory ,Tolerance_Percentage ,CNTRYORGN ,STTSTCLVLPRCNTG ,INCLUDEINDP ,LOTEXPWARN ,LOTEXPWARNDAYS ,UseQtyOverageTolerance ,UseQtyShortageTolerance ,QtyOverTolerancePercent ,QtyShortTolerancePercent ,IVSCRVIX )
select cc.ITMCLSCD , cc.ITMCLSDC , cc.DEFLTCLS , cc.NOTEINDX , cc.ITEMTYPE , cc.ITMTRKOP , cc.LOTTYPE , cc.KPERHIST , cc.KPTRXHST , cc.KPCALHST , cc.KPDSTHST , cc.ALWBKORD , cc.ITMGEDSC , cc.TAXOPTNS , cc.ITMTSHID , cc.Purchase_Tax_Options , cc.Purchase_Item_Tax_Schedu , cc.UOMSCHDL , cc.VCTNMTHD , cc.USCATVLS_1 , cc.USCATVLS_2 , cc.USCATVLS_3 , cc.USCATVLS_4 , cc.USCATVLS_5 , cc.USCATVLS_6 , cc.DECPLQTY , cc.IVIVINDX , cc.IVIVOFIX , cc.IVCOGSIX , cc.IVSLSIDX , cc.IVSLDSIX , cc.IVSLRNIX , cc.IVINUSIX , cc.IVINSVIX , cc.IVDMGIDX , cc.IVVARIDX , cc.DPSHPIDX , cc.PURPVIDX , cc.UPPVIDX , cc.IVRETIDX , cc.ASMVRIDX , cc.PRCLEVEL , cc.PriceGroup , cc.PRICMTHD , cc.TCC , cc.Revalue_Inventory , cc.Tolerance_Percentage , cc.CNTRYORGN , cc.STTSTCLVLPRCNTG , cc.INCLUDEINDP , cc.LOTEXPWARN , cc.LOTEXPWARNDAYS , cc.UseQtyOverageTolerance , cc.UseQtyShortageTolerance , cc.QtyOverTolerancePercent , cc.QtyShortTolerancePercent , cc.IVSCRVIX
from olddb..iv40400 cc
left join newdb..iv40400 cc2 on cc2.ITMCLSCD = cc.ITMCLSCD
where cc2.ITMCLSCD is null