Start Processing : 2024-09-20 02:56:20
0 rows affectedUPDATE db_wk_3_campaigns s, db_campaigns_kri c SET s._kri = c._keyRevenueInitiative, s._program = c._program WHERE s._campaignID = c._campaignID;
[10] 0.06 seconds -> 0 rows affected
UPDATE db_wk_3_campaigns s, db_campaigns_kri c SET s._kri = c._keyRevenueInitiative, s._program = c._program, s._marketingArea = c._marketingArea WHERE s._parentCampaignID = c._parentCampaignID && s._parentCampaignID != '' && c._parentCampaignID != '' && s._kri is null;
[15] 0.88 seconds -> 0 rows affected
insert into db_campaign_performance_ytd (_campaignName, _campaignID, _parentCampaignName, _parentCampaignID, _kri, _program, _marketingArea, _instance) select _campaignName, _campaignID, _parentCampaignName, _parentCampaignID, _kri, _program, _instance from db_wk_3_campaigns;
[20] 0 seconds -> -1 rows affected