SELECT DISTINCT tmp.eai_lineNumber, tmp.sku_sku, tmp.sku_skuid, tmp.custom_1, tmp.custom_2, tmp.custom_3, tmp.custom_4, tmp.custom_5, custom_7, CAST(tmp.custom_5 as date) startdate, CAST(tmp.custom_6 as date) enddate, tmp.custom_10, DBAction = CASE WHEN crm.rowID IS NULL THEN 'INSERT' WHEN crm.rowID IS NOT NULL THEN 'UPDATE' ELSE '' END FROM tbl_IMPORT_ProductData tmp LEFT OUTER JOIN tbl_CRM_AffiliationProducts crm ON crm.affiliationOrgID = tmp.custom_10 AND crm.affiliationType = tmp.custom_7 AND crm.skuid = tmp.sku_skuid WHERE tmp.eai_batchid = AND nullif(tmp.custom_12,'') IS NULL AND nullif(tmp.sku_mfrid,'') IS NOT NULL ORDER BY custom_10, tmp.sku_skuid INSERT INTO tbl_CRM_AffiliationProducts(affiliationOrgID,affiliationType,skuid,internalRefNum,status,startdate,enddate,ownerId,ownerType) VALUES(, , , , , , , , ) UPDATE tbl_IMPORT_ProductData SET custom_14 = 'ADDED' WHERE eai_batchid = AND eai_lineNumber = UPDATE tbl_CRM_AffiliationProducts SET internalRefNum = , status = , startdate = , enddate = WHERE affiliationOrgID = AND affiliationType = 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 =