UPDATE tbl_IMPORT_ProductData SET sku_unitPrice = REPLACE(sku_unitPrice,'$',''), custom_2 = REPLACE(custom_2,'$',''), sku_origUnitPrice = REPLACE(sku_origUnitPrice,'$','') WHERE eai_batchid = UPDATE p SET p.sku_prodid = s.prodid FROM tbl_IMPORT_ProductData p INNER JOIN tbl_PRD_Skus s ON (s.sku = p.sku_sku AND s.mfrid = p.sku_mfrid) WHERE p.eai_batchid = AND s.ownerid = AND s.fsl_tableCode = UPDATE p SET p.sku_origUnitPrice = s.unitPrice, p.custom_20 = pk.master_net_weight FROM tbl_IMPORT_ProductData p INNER JOIN tbl_PRD_Skus s ON (s.sku = p.sku_sku AND s.mfrid = p.sku_mfrid) INNER JOIN tbl_PRD_Packaging pk ON (s.skuid = pk.linkID and pk.linkType = 'SKU') WHERE p.eai_batchid = AND s.ownerid = AND s.fsl_tableCode = UPDATE s set s.unitPrice_CAD = (case when coalesce(p.custom_2,'') <> '' then CAST(p.custom_2 as float) else s.unitPrice_CAD end) , s.unitPrice = (case when coalesce(p.sku_unitPrice,'') <> '' then CAST(p.sku_unitPrice as float) else s.unitPrice end) FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_ProductData p ON (s.skuid = p.sku_skuid) WHERE p.eai_batchid = AND s.ownerid = AND s.fsl_tableCode = UPDATE pk SET pk.master_net_weight = p.custom_1 FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_ProductData p ON (s.skuId = p.sku_skuId) INNER JOIN tbl_PRD_Packaging pk ON (s.skuid = pk.linkID and pk.linkType = 'SKU') WHERE p.eai_batchid = AND s.ownerid = AND s.fsl_tableCode = AND nullif(p.custom_1,'') IS NOT NULL select s.skuId, p.custom_1 MASTER_NET_WEIGHT FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_ProductData p ON (s.skuId = p.sku_skuId) WHERE p.eai_batchid = AND s.ownerid = AND s.fsl_tableCode = AND nullif(p.custom_1,'') IS NOT NULL UPDATE tbl_PRD_Packaging SET MASTER_NET_WEIGHT = , MASTER_NET_WEIGHT_UNIT = 'LB', MASTER_NET_WEIGHT_TYPE = 'NET' WHERE ownerid = AND fsl_tableCode = and linkId = and linkType = 'SKU' insert into tbl_PRD_Packaging ( ownerId, fsl_tablecode, linkId, linkType, date_stamp, master_net_weight, master_net_weight_unit, master_net_weight_type ) values ( , , , 'SKU', {fn now() }, , 'LB', 'NET' ) SELECT AVG(s.unitPrice) avg_unitPrice, prd.prodid FROM tbl_PRD_Skus s INNER JOIN tbl_PRD_Products prd ON (s.prodid = prd.prodid) WHERE s.ownerid = AND s.fsl_tableCode = AND (nullif(prd.averageUnitPrice,'') IS NULL OR prd.averageUnitPrice = 0) AND nullif(s.unitPrice,'') IS NOT NULL GROUP BY prd.prodid UPDATE prd SET prd.averageUnitPrice = FROM tbl_PRD_Products prd WHERE prd.ownerid = AND prd.fsl_tableCode = AND prd.prodid = SELECT AVG(s.unitPrice_CAD) avg_unitPrice_CAD, prd.prodid FROM tbl_PRD_Skus s INNER JOIN tbl_PRD_Products prd ON (s.prodid = prd.prodid) WHERE s.ownerid = AND s.fsl_tableCode = AND (nullif(prd.averageUnitPrice_CAD,'') IS NULL OR prd.averageUnitPrice_CAD = 0) AND nullif(s.unitPrice_CAD,'') IS NOT NULL GROUP BY prd.prodid UPDATE prd SET prd.averageUnitPrice_CAD = FROM tbl_PRD_Products prd WHERE prd.ownerid = AND prd.fsl_tableCode = AND prd.prodid = SELECT DISTINCT stage.sku_prodid FROM tbl_IMPORT_ProductData stage WHERE stage.eai_batchid = AND ( coalesce(CAST(stage.sku_unitPrice AS float),0) <> coalesce(CAST(stage.sku_origUnitPrice AS float),0) OR coalesce(CAST(stage.custom_20 AS float),0) <> coalesce(CAST(stage.custom_1 AS float),0) ) and stage.sku_prodId > 0