Start Processing : 2025-04-19 15:54:05
0 rows affectedUPDATE db_summary_sales_tracker
SET _meetingDate1 = STR_TO_DATE(_meetingDate,'%d-%m-%y')
WHERE _meetingDate1 IS NULL AND
_meetingDate LIKE '%-%'
[10] 0 seconds -> -1 rows affected
UPDATE db_summary_sales_tracker
SET _dateScheduled1 = STR_TO_DATE(_dateScheduled,'%d-%m-%y')
WHERE _dateScheduled1 IS NULL AND
_dateScheduled LIKE '%-%'
[20] 0 seconds -> -1 rows affected
UPDATE db_summary_sales_tracker
set _stageDesc = case
when _currentStage = 'A' THEN 'Suspect'
when _currentStage = 'B' then 'Qualified Opportunity'
when _currentStage = 'C' then 'Proposal to Send'
when _currentStage = 'D' then 'Proposal Sent'
when _currentStage = 'E' then 'Verbal Commitment'
when _currentStage = 'F' then 'Signed Deal'
ELSE _currentStage
END
[30] 0 seconds -> -1 rows affected