Start Processing : 2024-09-20 02:46:01
0 rows affectedUPDATE db_wk_3_opps s, db_wk_3_campaigns c SET s._campaignID = c._campaignID WHERE s._primaryCampaignSource = c._campaignName;
[10] 6.33 seconds -> 0 rows affected
UPDATE db_wk_3_opps s, db_wk_3_campaigns c SET s._kri = c._kri, s._program = c._program, s._marketingArea = c._marketingArea WHERE s._campaignID = c._campaignID;
[20] 0.02 seconds -> 0 rows affected
UPDATE db_campaign_performance_ytd s, (select _campaignID, _primaryCampaignSource, count(*) as _opps from db_wk_3_opps where _campaignID is not null group by 1, 2) c SET s._opps = c._opps WHERE s._campaignID = c._campaignID;
[30] 0.02 seconds -> 0 rows affected