SELECT tmp.eai_lineNumber, tmp.sku_sku, tmp.sku_skuid, custom_1, custom_2, custom_3, custom_10, DBAction = CASE WHEN cs.customerKey IS NULL THEN 'INSERT' WHEN cs.customerKey IS NOT NULL THEN 'UPDATE' ELSE '' END FROM tbl_IMPORT_ProductData tmp LEFT OUTER JOIN tbl_PRD_CustomerSkus cs ON tmp.sku_skuid = cs.skuid AND cs.ownerid = AND cs.fsl_TableCode = AND cs.customerID = tmp.custom_10 AND cs.customerType = tmp.custom_2 WHERE tmp.eai_batchid = AND nullif(tmp.custom_12,'') IS NULL INSERT INTO tbl_PRD_CustomerSkus(OwnerID, FSL_TableCode, Sku, LinkType, CustomerID, CustomerType, CustomerSku, mfrId, SkuID) VALUES(, , , 'SKU', , , , , ) UPDATE tbl_IMPORT_ProductData SET custom_14 = 'ADDED' WHERE eai_batchid = AND eai_lineNumber = UPDATE tbl_PRD_CustomerSkus SET CustomerSku = WHERE OwnerID = AND FSL_TableCode = AND CustomerID = AND CustomerType = AND LinkType = 'SKU' AND skuid = UPDATE tbl_IMPORT_ProductData SET custom_14 = 'UPDATED' WHERE eai_batchid = AND eai_lineNumber = UPDATE tbl_IMPORT_ProductData SET custom_14 = 'SKIPPED' WHERE eai_batchid = AND eai_lineNumber =