update t_tccit_qysds_jmsdsyh set fjzfd = fjzfd/100 where fjzfd is not null  and fjzfd > 1 and fsbbid in (select concat(fid,'')  from t_tctb_declare_main ttdm where ftemplateid ='1118745305702206464'); 

update t_tccit_qysds_zb set fzjgftbl = fzjgftbl/100 where fzjgftbl is not null  and fzjgftbl > 1 and fsbbid in (select concat(fid,'')  from t_tctb_declare_main ttdm where ftemplateid ='1118745305702206464');
update t_tccit_qysds_zb set fczjzfpbl = fczjzfpbl/100 where fczjzfpbl is not null  and fczjzfpbl > 1 and fsbbid in (select concat(fid,'')  from t_tctb_declare_main ttdm where ftemplateid ='1118745305702206464');
update t_tccit_qysds_zb set fqbfzjgftbl = fqbfzjgftbl/100 where fqbfzjgftbl is not null  and fqbfzjgftbl > 1 and fsbbid in (select concat(fid,'')  from t_tctb_declare_main ttdm where ftemplateid ='1118745305702206464');
update t_tccit_qysds_zb set fzjgjyztscjyznbmftbl = fzjgjyztscjyznbmftbl/100 where fzjgjyztscjyznbmftbl is not null  and fzjgjyztscjyznbmftbl > 1 and fsbbid in (select concat(fid,'')  from t_tctb_declare_main ttdm where ftemplateid ='1118745305702206464');
update t_tccit_qysds_zb set ffzjgftbl = ffzjgftbl/100 where ffzjgftbl is not null  and ffzjgftbl > 1 and fsbbid in (select concat(fid,'')  from t_tctb_declare_main ttdm where ftemplateid ='1118745305702206464');

update t_tccit_qysds_zb set fsl = fsl/100 where fsl is not null  and fsl > 1 and fsbbid in (select concat(fid,'')  from t_tctb_declare_main ttdm where ftemplateid ='1118745305702206464');