UPDATE mfrP SET mfr_id = FROM tbl_MFR_ProductLines mfrp LEFT OUTER JOIN tbl_IMPORT_ProductData stag ON (stag.mfrprdln_productcode = mfrp.productcode AND stag.eai_batchid = ) WHERE mfrp.mfr_id = AND mfrPrdLn_productCode IS NULL --AND nullif(cat_catnum,'') IS NULL --AND nullif(prod_product,'') IS NULL AND 0 = (SELECT COUNT(categoryid) FROM tbl_PRD_Categories cat WHERE cat.ownerid = AND cat.fsl_tableCode = AND mfrP.ProdLine_ID = cat.prodlineID); UPDATE cat SET Ownerid = FROM tbl_PRD_Categories cat LEFT OUTER JOIN tbl_IMPORT_ProductData stag ON (stag.cat_catnum = cat.catnum AND stag.eai_batchid = ) WHERE cat.ownerid = AND cat.fsl_tableCode = --AND stag.mfrPrdLn_productCode IS NOT NULL AND nullif(stag.cat_catnum,'') IS NULL --AND nullif(stag.prod_product,'') IS NULL AND 0 = (SELECT COUNT(categoryid) FROM tbl_PRD_Products prd WHERE prd.ownerid = AND prd.fsl_tableCode = AND prd.categoryid = cat.categoryid); UPDATE prd SET inactive = 1 FROM tbl_PRD_Products prd LEFT OUTER JOIN tbl_IMPORT_ProductData stag ON (stag.prod_product = prd.product AND stag.eai_batchid = ) WHERE prd.ownerid = AND prd.fsl_tableCode = AND nullif(stag.prod_product,'') IS NULL AND 0 = (SELECT COUNT(skuid) FROM tbl_PRD_skus sku WHERE sku.ownerid = AND sku.fsl_tableCode = AND sku.prodid = prd.prodid);