Start Processing : 2025-03-15 01:45:04
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.09 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] 1.56 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