update tbl_IMPORT_ProductData set sku_sku = ltrim(rtrim(sku_sku)) where eai_batchid = select i.mfr_mfrName, i.sku_packSizeDesc, i.sku_sku, i.sku_skudesc, i.sku_skuId, i.sku_MfrId, custom_1, custom_2, custom_3, custom_4, i.mfr_mfrName as MfrName from tbl_IMPORT_ProductData i with (nolock) where i.eai_batchid = and nullif(i.sku_sku,'') IS NOT NULL order by i.sku_sku, i.mfr_mfrName select distinct s.skuid, s.sku, s.skudesc, s.packsizeDesc, m.mfr_name from tbl_PRD_Skus s with (nolock) inner join tblManufacturers m with (nolock) on s.mfrid = m.mfr_id where fsl_tableCode = 'MFR' and s.sku like and s.mfrid = order by m.mfr_name, s.sku select distinct s.skuid, s.sku, s.skudesc, s.packsizeDesc, m.mfr_name from tbl_PRD_Skus s with (nolock) inner join tblManufacturers m with (nolock) on s.mfrid = m.mfr_id where fsl_tableCode = 'MFR' and #attributes.datasource#.dbo.RemoveChars(s.sku,'32,45') = #attributes.datasource#.dbo.RemoveChars(,'32,45') and s.mfrid = order by m.mfr_name, s.sku QueryAddRow( qmd_query ); _newRow = qmd_query.recordCount; QuerySetCell( qmd_query, "s_mfr_name", trim(qry_getData.MfrName), _newRow ); QuerySetCell( qmd_query, "s_mfr_sku", trim(qry_getData.sku_sku), _newRow ); QuerySetCell( qmd_query, "s_description", trim(qry_getData.sku_skudesc), _newRow ); QuerySetCell( qmd_query, "s_pack_size", trim(qry_getData.sku_packSizeDesc), _newRow ); QuerySetCell( qmd_query, "r_mfr_name", trim(qry_skuLookup.mfr_name), _newRow ); QuerySetCell( qmd_query, "r_mfr_sku", trim(qry_skuLookup.sku), _newRow ); QuerySetCell( qmd_query, "r_description", trim(qry_skuLookup.skudesc), _newRow ); QuerySetCell( qmd_query, "r_pack_size", qry_skuLookup.packsizeDesc, _newRow ); QuerySetCell( qmd_query, "r_skuid", qry_skuLookup.skuid, _newRow ); QuerySetCell( qmd_query, "result", "#_comment#", _newRow ); QuerySetCell( qmd_query, "hyperlink", "#_link#", _newRow ); QueryAddRow( qmd_query ); _newRow = qmd_query.recordCount; QuerySetCell( qmd_query, "s_mfr_name", trim(qry_getData.MfrName), _newRow ); QuerySetCell( qmd_query, "s_mfr_sku", trim(qry_getData.sku_sku), _newRow ); QuerySetCell( qmd_query, "s_description", trim(qry_getData.sku_skudesc), _newRow ); QuerySetCell( qmd_query, "s_pack_size", trim(qry_getData.sku_packSizeDesc), _newRow ); /*QuerySetCell( qmd_query, "r_mfr_name", trim(qry_skuLookup.mfr_name), _newRow );*/ /*QuerySetCell( qmd_query, "r_mfr_sku", trim(qry_skuLookup.sku), _newRow );*/ /*QuerySetCell( qmd_query, "r_description", trim(qry_skuLookup.skudesc), _newRow );*/ /*QuerySetCell( qmd_query, "r_skuid", qry_skuLookup.skuid, _newRow );*/ QuerySetCell( qmd_query, "result", "No partial matches found.", _newRow ); /*QuerySetCell( qmd_query, "hyperlink", "#_link#", _newRow );*/ QueryAddRow( qmd_query ); _newRow = qmd_query.recordCount; QuerySetCell( qmd_query, "s_mfr_name", trim(qry_getData.MfrName), _newRow ); QuerySetCell( qmd_query, "s_mfr_sku", trim(qry_getData.sku_sku), _newRow ); QuerySetCell( qmd_query, "s_description", trim(qry_getData.sku_skudesc), _newRow ); QuerySetCell( qmd_query, "s_pack_size", trim(qry_getData.sku_packSizeDesc), _newRow ); QuerySetCell( qmd_query, "r_mfr_name", trim(qry_getData.custom_1), _newRow ); QuerySetCell( qmd_query, "r_mfr_sku", trim(qry_getData.custom_2), _newRow ); QuerySetCell( qmd_query, "r_description", trim(qry_getData.custom_3), _newRow ); QuerySetCell( qmd_query, "r_pack_size", qry_getData.custom_4, _newRow ); QuerySetCell( qmd_query, "r_skuid", qry_getData.sku_skuId, _newRow ); QuerySetCell( qmd_query, "result", "Exact Match", _newRow ); QuerySetCell( qmd_query, "hyperlink", "#_link#", _newRow ); QueryAddRow( qmd_query ); _newRow = qmd_query.recordCount; QuerySetCell( qmd_query, "s_mfr_name", "", _newRow ); QuerySetCell( qmd_query, "s_mfr_sku", "", _newRow ); QuerySetCell( qmd_query, "s_description", "", _newRow ); QuerySetCell( qmd_query, "s_pack_size", "", _newRow ); QuerySetCell( qmd_query, "r_mfr_name", "", _newRow ); QuerySetCell( qmd_query, "r_mfr_sku", "", _newRow ); QuerySetCell( qmd_query, "r_description", "", _newRow ); QuerySetCell( qmd_query, "r_pack_size", "", _newRow ); QuerySetCell( qmd_query, "r_skuid", "", _newRow ); QuerySetCell( qmd_query, "result", "", _newRow ); QuerySetCell( qmd_query, "hyperlink", "", _newRow );