select * from tbl_IMPORT_ProPointsStatus where eai_batchId = and ownerId = and ownerType = order by eai_lineNumber select MFR_ID, MFR_Name from tblManufacturers where MFR_Name LIKE select b.Brand, m.MFR_ID MFR_ID, m.MFR_Name from tbl_MFR_Brands b inner join tblManufacturers m on b.MFR_ID = m.MFR_ID where Brand LIKE SELECT mfr_ID, mfr_name FROM tblManufacturers WHERE mfr_ID = and star_awards = 'Y' update tbl_IMPORT_ProPointsStatus set FSEMFRId = where ownerId = and ownerType = and EAI_batchID = and EAI_LineNumber = select distinct fseMfrId, brand from tbl_IMPORT_ProPointsStatus where eai_batchId = and ownerId = and ownerType = order by fseMfrId select * from tbl_IMPORT_ProPointsStatus where eai_batchId = and ownerId = and ownerType = and fseMfrId > order by fseMfrId update tbl_IMPORT_ProPointsStatus set FSESKUId = ,FSESKUIdStatus = where ownerId = and ownerType = and EAI_batchID = and EAI_LineNumber = select #qmd_batch.loadedColumns#, i. EAI_Linenumber Line, i.FSESKUID Matched_SKU, i.fseMFRid mfrImportID, i.FSESKUIDStatus Found_By ,s.skuDesc Matched_Description from tbl_IMPORT_ProPointsStatus i left outer join tbl_PRD_SKUs s on i.fseSkuId = s.skuid where i.eai_batchId = and i.ownerId = and i.ownerType = order by i.eai_lineNumber select MFR_ID, MFR_Name from tblManufacturers where MFR_ID = select MFR_ID, MFR_Name from tblManufacturers where MFR_ID = select MFR_ID, MFR_Name from tblManufacturers where MFR_ID = select MFR_ID, MFR_Name from tblManufacturers where MFR_ID = select skuid, ownerid from tbl_PRD_SKUs where ownerId = and FSL_TableCode = and star_awards = order by ownerId update tbl_PRD_SKUs set star_awards = where skuid = and FSL_TableCode = and skuid NOT IN ( select fseSkuId from tbl_IMPORT_ProPointsStatus where ownerId = and ownerType = and EAI_batchID = and fseMfrid = )

SKUs updated to ProPoints: #ListLen(_skuFound)# of #qmd_data.recordCount#

SKUs force reset off ProPoints: #_forceResetResults#

Other ProPoints SKUs reset: #_cleanResetResults#