select MFR_NAME nameMfr from tblManufacturers where MFR_ID =

#qmd_mfrName.nameMfr# Cool School SKUs Reset: #_updateResults#

select * from tbl_IMPORT_CoolSchoolStatus where eai_batchId = and ownerId = and ownerType = order by eai_lineNumber update tbl_IMPORT_CoolSchoolStatus set FSESKUId = ,FSESKUIdStatus = where ownerId = and ownerType = and EAI_batchID = and EAI_LineNumber =

SKUs Updated to Cool School: #_recordUpdated# of #qmd_data.recordCount#

select #qmd_batch.loadedColumns#, i. EAI_Linenumber, i.FSESKUID Matched_SKU, i.FSESKUIDStatus Found_By ,s.skuDesc Matched_Description from tbl_IMPORT_CoolSchoolStatus 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 skuid from tbl_PRD_SKUs where ownerId = and FSL_TableCode = update tbl_PRD_SKUs set cool_school = where ownerId = and skuid = and FSL_TableCode = and cool_school = 'Y' and skuid NOT IN ()

#_updateResults# other #qmd_mfrName.nameMfr# Cool School SKUs were reset

Due to report errors, other #qmd_mfrName.nameMfr# Cool School SKUs were not reset

select Manufacturer, #qmd_batch.loadedColumns#, Matched_SKU, Matched_Description, Found_By, Record_Updated from qmd_ResultsData order by EAI_Linenumber