UPDATE s SET CRMActive = 'N' FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_ProductData tmp ON (tmp.sku_skuid = s.skuid) WHERE s.Ownerid = AND s.FSL_TableCode = AND tmp.eai_batchid = AND tmp.sku_ProdID <> tmp.sku_origProdID UPDATE s SET s.bgtCatID = p.bgtCatID FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_ProductData tmp ON (tmp.sku_skuid = s.skuid) INNER JOIN tbl_PRD_Products p ON (p.prodid = s.prodid) WHERE s.Ownerid = AND s.FSL_TableCode = AND tmp.eai_batchid = AND tmp.sku_ProdID <> tmp.sku_origProdID SELECT s.skuid, p.prodid FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_ProductData tmp ON (tmp.sku_skuid = s.skuid) INNER JOIN tbl_PRD_Products p ON (p.prodid = s.prodid) WHERE s.Ownerid = AND s.FSL_TableCode = AND (tmp.sku_ProdID <> tmp.sku_origProdID OR tmp.sku_processAction = 'ADDED') AND tmp.eai_batchid = DELETE LINK FROM tbl_ORG_AttributeLinks k INNER JOIN tbl_CMM_Filters c ON (k.mstr_attrID = c.filterid) INNER JOIN tbl_ORG_Attributes fv ON (fv.attrID = k.child_attrID) INNER JOIN tbl_ORG_AttributeLinks link ON (fv.attrid = link.mstr_attrID AND link.mstr_attrTypeID = 29) WHERE k.child_attrTypeID = 29 AND k.mstr_attrTypeID = 28 AND c.filterTypeID = 1 AND link.child_attrID = AND link.child_attrTypeID = 60 INSERT INTO tbl_ORG_AttributeLinks(mstr_attrTypeID, mstr_attrID, child_attrTypeID, child_attrID) SELECT 29, link.mstr_attrid, 60, #qry_GetMarketCats4Remaps.skuid# FROM tbl_ORG_AttributeLinks k INNER JOIN tbl_CMM_Filters c ON (k.mstr_attrID = c.filterid) INNER JOIN tbl_ORG_Attributes fv ON (fv.attrID = k.child_attrID) INNER JOIN tbl_ORG_AttributeLinks link ON (fv.attrid = link.mstr_attrID AND link.mstr_attrTypeID = 29) INNER JOIN tbl_CMM_FilterTypes ft on ft.filterTypeId = c.filterTypeId WHERE k.child_attrTypeID = 29 AND k.mstr_attrTypeID = 28 AND c.filterTypeID = 1 AND link.child_attrID = AND link.child_attrTypeID = 59 AND ft.filterTypeName = 'ProductHierarchy'