20250226lh.sql

update ecw_customer_followup set sale_stage=0 where sale_stage in (1,2)
update ecw_customer_followup set sale_stage=1 where sale_stage in (3,4,8);
update ecw_customer_followup set sale_stage=2 where sale_stage =6;
update ecw_customer_followup set sale_stage=3 where sale_stage =7;
update ecw_customer_followup set sale_stage=4 where sale_stage in (5,9)	;
update ecw_customer_followup set sale_stage=5 where sale_stage =10;
update ecw_customer_followup set sale_stage=6 where sale_stage =11;
update ecw_customer_followup set sale_stage=7 where sale_stage =14;
update ecw_customer_followup set sale_stage=8 where sale_stage =12;
update ecw_customer_followup set sale_stage=9 where sale_stage =13;