Start Processing : 2025-03-15 01:43:55<BR>0 rows affectedUPDATE wk_opportunity_hist
SET _lastStageChangeTS = STR_TO_DATE(_lastStageChangeDate, '%c/%e/%Y') 
where _lastStageChangeDate != ''<BR>[10] 3.82 seconds -> 0 rows affected<BR>update wk_opportunity_hist
set _fromCode =
case
	when _fromStage = 'Learn/engage' then '1'
	when _fromStage = 'Opportunity Development' then '2'
	when _fromStage = 'Proposal' then '3'
	when _fromStage = 'Negotiate' then '4'
	when _fromStage = 'Contract/Legal Process' then '5'
	when _fromStage = 'Closed Won' then '6'
	when _fromStage = 'Closed Lost' then '0'
	when _fromStage = 'Duplicate' then '0'
	when _fromStage = 'Dormant' then '0'
    else ''
end;<BR>[20] 1.25 seconds -> 0 rows affected<BR>update wk_opportunity_hist
set _toCode =
case
	when _toStage = 'Learn/engage' then '1'
	when _toStage = 'Opportunity Development' then '2'
	when _toStage = 'Proposal' then '3'
	when _toStage = 'Negotiate' then '4'
	when _toStage = 'Contract/Legal Process' then '5'
	when _toStage = 'Closed Won' then '6'
	when _toStage = 'Closed Lost' then '0'
	when _toStage = 'Duplicate' then '0'
	when _toStage = 'Dormant' then '0'
    else ''
end;<BR>[30] 1.84 seconds -> 0 rows affected<BR>update wk_opportunity_hist
set _mvmt = _toCode - _fromCode<BR>[40] 1.91 seconds -> 0 rows affected<BR>