Start Processing : 2025-03-15 01:38:49
0 rows affectedUPDATE db_wk_3_opps s, db_wk_3_campaigns c SET s._campaignID = c._campaignID WHERE s._primaryCampaignSource = c._campaignName;
[10] 2.65 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.01 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.01 seconds -> 0 rows affected