SELECT DISTINCT COUNT(p.sku_sku) AS SkuCount FROM tbl_IMPORT_ProductData p WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = AND nullif(p.sku_sku,'') IS NOT NULL AND nullif(p.sku_skudesc,'') IS NOT NULL; UPDATE stage SET sku_systemskudesc = sku_skudesc FROM tbl_IMPORT_ProductData stage WHERE ownerType = AND ownerId = AND eai_batchid = UPDATE stage SET stage.sku_skudesc = s.skudesc FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_ProductData stage ON (s.sku = stage.sku_sku AND s.mfrid = stage.sku_mfrid) WHERE stage.ownerType = AND stage.ownerId = AND stage.eai_batchid = AND s.ownerid = AND s.fsl_tableCode = AND nullif(stage.sku_sku,'') IS NOT NULL AND nullif(stage.sku_skudesc,'') IS NOT NULL UPDATE p SET p.sku_processAction = CASE WHEN nullif(s.sku,'') IS NOT NULL THEN 'Updated' WHEN nullif(s.sku,'') IS NULL AND #attributes.processSkuAdds# = '1' THEN 'Added' ELSE 'SKU ADDS DISABLED' END FROM tbl_IMPORT_ProductData p LEFT OUTER JOIN tbl_PRD_Skus s ON s.sku = p.sku_sku AND s.ownerid = AND s.fsl_tableCode = AND s.mfrid = p.sku_mfrid WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = AND nullif(p.sku_sku,'') IS NOT NULL AND nullif(rtrim(p.sku_processAction),'') IS NULL INSERT INTO tbl_PRD_Skus(ownerid, fsl_tableCode, Brandid, Prodid, Sku, SkuDesc, mfrid, publishdate, unpublishdate, packsizedesc, RecordSource, lastUpdate, divestitureDate , schoolProduct, hasChildNutrition, additionalDesc , startAvailabilityDate, mfrsku) SELECT DISTINCT #attributes.ownerid#, '#attributes.ownerType#', p.sku_brandid, p.sku_prodid, p.sku_sku, p.sku_skudesc, p.sku_mfrid -- prevent duplicates by removing time and seconds , COALESCE(CAST((STR( YEAR( p.sku_publishdate ) ) + '/' + STR( MONTH( p.sku_publishdate ) ) + '/' + STR( DAY( p.sku_publishdate ) ))AS DATETIME),#variables.publishdate#) , COALESCE(CAST((STR( YEAR( p.sku_unpublishdate ) ) + '/' + STR( MONTH( p.sku_unpublishdate ) ) + '/' + STR( DAY( p.sku_unpublishdate ) ))AS DATETIME),#variables.unpublishdate#) , p.sku_packsizedesc , 'Batchid:#attributes.batchid#', getDate(), p.sku_divestitureDate, sku_schoolProduct, sku_hasChildNutrition, sku_additionalDesc, sku_startAvailabilityDate, sku_mfrsku FROM tbl_IMPORT_ProductData p WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = AND p.sku_processAction = 'ADDED' AND nullif(p.sku_sku,'') IS NOT NULL AND coalesce(p.sku_mfrid,0) > 0 UPDATE s SET s.SkuDesc = p.sku_skudesc, s.systemSkuDesc = case when p.sku_systemskudesc is not null then p.sku_systemskudesc else s.systemSkuDesc end, s.packsizedesc = p.sku_packsizedesc, s.mfrid = p.sku_mfrid, s.LastUpdate = getDate(), s.schoolProduct = p.sku_schoolProduct, s.hasChildNutrition = p.sku_hasChildNutrition, s.additionalDesc = sku_additionalDesc, s.startAvailabilityDate = case when p.sku_startAvailabilityDate is not null then p.sku_startAvailabilityDate else s.startAvailabilityDate end, s.mfrSku = case when nullif(p.sku_mfrSku,'') is not null then p.sku_mfrSku else s.mfrSku end, s.divestitureDate = case when nullif(p.sku_divestitureDate,'') is not null then p.sku_divestitureDate else s.divestitureDate end FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_ProductData p ON s.skuid = p.sku_skuid AND s.mfrid = p.sku_mfrid WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = AND s.ownerid = AND s.fsl_tableCode = AND nullif(p.sku_sku,'') IS NOT NULL AND nullif(p.sku_skudesc,'') IS NOT NULL AND p.sku_processAction = 'UPDATED' UPDATE p SET p.sku_skuid = s.skuid FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_ProductData p ON s.sku = p.sku_sku AND s.mfrid = p.sku_mfrid WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = AND s.ownerid = AND s.fsl_tableCode = UPDATE p SET p.sku_brandid = b.brand_id FROM tbl_IMPORT_ProductData p INNER JOIN tbl_MFR_Brands b ON (b.brand = p.mfrBRND_Brand) WHERE p.eai_batchid = AND p.OwnerID = AND p.OwnerType = AND b.BrandOwnerId = AND b.brandType = AND b.mfr_Id = p.sku_mfrID AND nullif(p.sku_sku,'') IS NOT NULL AND nullif(p.sku_skudesc,'') IS NOT NULL AND nullif(p.mfrBRND_Brand,'') IS NOT NULL UPDATE p SET p.sku_brandid = b.brand_id FROM tbl_IMPORT_ProductData p INNER JOIN tbl_MFR_Brands b ON (b.brand = p.mfrBRND_Brand) WHERE p.eai_batchid = AND p.OwnerID = 0 AND p.OwnerType NOT IN ('MFR','BRO') AND nullif(p.mfrBRND_Brand,'') IS NOT NULL AND nullif(p.sku_sku,'') IS NOT NULL AND nullif(p.sku_skudesc,'') IS NOT NULL UPDATE s SET s.Brandid = p.sku_brandid FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_ProductData p ON s.skuid = p.sku_skuid WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = AND s.ownerid = AND s.fsl_tableCode = AND nullif(p.sku_sku,'') IS NOT NULL AND nullif(p.sku_skudesc,'') IS NOT NULL AND (nullif(p.sku_brandid,'') IS NOT NULL AND p.sku_brandid <> 0) UPDATE pd SET pd.sku_prodid = p.prodid, pd.prod_prodid = p.prodid FROM tbl_PRD_Products p INNER JOIN tbl_IMPORT_ProductData pd ON (rtrim(p.product) = rtrim(pd.prod_product)) AND p.mfrid = pd.prod_mfrid WHERE pd.ownerType = AND pd.ownerId = AND pd.eai_batchid = AND p.ownerid = AND p.fsl_tableCode = AND nullif(pd.prod_product,'') IS NOT NULL AND nullif(pd.prod_prodid,'') IS NULL UPDATE pd SET pd.sku_prodid = pd.prod_prodid FROM tbl_IMPORT_ProductData pd WHERE pd.ownerType = AND pd.ownerId = AND pd.eai_batchid = AND nullif(pd.prod_prodid,'') IS NOT NULL AND nullif(pd.sku_prodid,'') IS NULL select s.skuId, p.sku_prodid from tbl_PRD_Skus s inner join tbl_IMPORT_ProductData p on s.sku = p.sku_sku and s.mfrid = p.sku_mfrid where p.ownerType = and p.ownerId = and p.eai_batchid = and s.ownerid = and s.fsl_tableCode = and nullif(p.sku_sku,'') IS NOT NULL and nullif(p.sku_skudesc,'') IS NOT NULL and p.sku_processAction = 'UPDATED' and convert( int, p.sku_prodid ) <> coalesce( s.prodId, 0 ) UPDATE s SET s.Prodid = p.sku_prodid FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_ProductData p ON s.sku = p.sku_sku AND s.mfrid = p.sku_mfrid WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = AND s.ownerid = AND s.fsl_tableCode = AND nullif(p.sku_sku,'') IS NOT NULL AND nullif(p.sku_skudesc,'') IS NOT NULL AND (nullif(p.sku_prodid,'') IS NOT NULL AND p.sku_prodid <> 0) select p.sku_skuid, p.sku_sku, p.sku_skudesc from tbl_IMPORT_ProductData p WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = and p.sku_processAction = 'ADDED' UPDATE s SET s.unpublishdate = COALESCE(p.sku_unpublishdate,#variables.unpublishdate#) FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_ProductData p ON s.sku = p.sku_sku AND s.mfrid = p.sku_mfrid WHERE p.eai_batchid = AND s.ownerid = AND s.fsl_tableCode = AND nullif(p.sku_sku,'') IS NOT NULL AND nullif(p.sku_skudesc,'') IS NOT NULL AND (nullif(p.sku_unpublishdate,'') IS NOT NULL) ---> UPDATE s SET s.privateLabelType = p.sku_privateLabelType FROM tbl_PRD_Skus s INNER JOIN tbl_IMPORT_ProductData p ON s.sku = p.sku_sku AND s.mfrid = p.sku_mfrid WHERE p.eai_batchid = AND s.ownerid = AND s.fsl_tableCode = AND nullif(p.sku_privateLabelType,'') IS NOT NULL ---> update s set s.mrktCatId = p.mrktCatId where tbl_PRD_Sku s inner join tbl_PRD_Products p on s.prodid = p.prodid where s.ownerid = and s.fsl_TableCode = and s.mrktCatId <> p.mrktCatId and s.mrktCatOverride = 'N' update s set s.crmactive = p.crmactive where tbl_PRD_Sku s inner join tbl_PRD_Products p on s.prodid = p.prodid where s.ownerid = and s.fsl_TableCode = and s.crmactive <> p.crmactive and s.crmOverride = 'N' --->