UPDATE #tmp_ret_yun
SET ret_now= CONVERT(VARCHAR(6),Convert(DECIMAL(18,2),(case when 100*get_now/need_now >=100 then 100 else 100*get_now/need_now end )))
, ret_all= CONVERT(VARCHAR(6),Convert(DECIMAL(18,2),( case when 100*get_now/need_now >=100 then 100 else 100*get_now/need_now end )))
SET ret_now= CONVERT(VARCHAR(6),Convert(DECIMAL(18,2),(case when 100*get_now/need_now >=100 then 100 else 100*get_now/need_now end )))
, ret_all= CONVERT(VARCHAR(6),Convert(DECIMAL(18,2),( case when 100*get_now/need_now >=100 then 100 else 100*get_now/need_now end )))
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货