update i set i.fseSkuId = s.skuId from tbl_IMPORT_EUConversion i inner join tbl_PRD_Skus s with (nolock) on s.sku = i.sku and s.ownerId = i.ownerId and s.fsl_tablecode = i.ownerType and s.inactive = '0' where i.ownerId = and i.ownerType = and i.eai_batchId = select i.fseSkuId, i.equiv_units_per_case from tbl_IMPORT_EUConversion i with (nolock) where i.ownerId = and i.ownerType = and i.eai_batchId = and i.fseSKUId is not null update tbl_PRD_SKUs set equivUnitsPerCase = , lastUpdate = where skuId = and ownerId = and fsl_tablecode =

#lsnumberformat( qmd_matches.recordCount )# SKUs updated with Equivalent Units Per Case Conversion

select sku from tbl_IMPORT_EUConversion i with (nolock) where i.ownerId = and i.ownerType = and i.eai_batchId = and i.fseSKUId is null order by eai_lineNumber

Unknown SKUs (#lsnumberformat( qmd_nonMatches.recordCount )#)

#htmleditformat( sku )#