select * from tbl_IMPORT_SkuUpdates prd where prd.eai_batchid = and prd.ownerType = and prd.ownerid = and nullif(prd.sku,'') is null and nullif(prd.gtin,'') is null UPDATE prd SET prd.skuid = p.linkId FROM tbl_IMPORT_SkuUpdates prd inner join tbl_PRD_Packaging p on p.fsl_tableCode = and p.ownerid = and p.linkType = 'SKU' and ltrim(p.scc14) = ltrim(prd.gtin) WHERE prd.eai_batchid = AND prd.ownerType = AND prd.ownerid = AND prd.skuid IS NULL AND nullif(prd.gtin,'') IS NOT NULL UPDATE prd SET prd.skuid = s.skuid FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_SkuUpdates prd ON ( ltrim(s.sku) = ltrim(prd.sku) ) WHERE prd.eai_batchid = AND s.fsl_tableCode = AND s.ownerid = AND prd.skuid IS NULL AND nullif(prd.sku,'') IS NOT NULL select p.skuid, p.sku, p.skuDesc, p.gtin , nullif(p.#_fld#,'') as stage_#_fld# , s.#_fld# as #_fld# FROM tbl_IMPORT_SkuUpdates p with (nolock) inner join tbl_PRD_Skus s with (nolock) on s.skuid = p.skuid and s.ownerid = p.ownerid and s.fsl_TableCode = p.ownerType WHERE p.eai_batchid = AND p.ownerType = AND p.ownerid = ORDER BY p.sku, p.gtin UPDATE s SET s.LastUpdate = getDate(), s.#_fldName# = , FROM tbl_PRD_Skus s WHERE s.fsl_tableCode = AND s.ownerid = AND s.skuid =

SKU	GTIN	Field Updated	New Value
#qry_getSkus.sku#	#qry_getSkus.gtin#			#_fldName#	#qry_getSkus[_stageFldName][currentRow]#

#loadedProductDataHTML#