select DJRQ,DJBH,DJMC,QDDM, (case when DJMC='渠道退货' then SL else 0 end ) AS SL, (case when DJMC='渠道退货' then sl/100 else 0 end )as THL FROM vw_routePeihuo数据显示 SL THL 1.00 0.010000 2.00 0.020000 3.00 0.030000 我想求的THL是0.01%哪位高手帮下
select DJRQ,DJBH,DJMC,QDDM, SL=(case when DJMC='渠道退货' then SL else 0 end ), THL=CONVERT(VARCHAR,CONVERT(decimal(10,2),(case when DJMC='渠道退货' then sl/100 else 0 end )))+'%' FROM vw_routePeihuo
(case when DJMC='渠道退货' then SL else 0 end ) AS SL,
(case when DJMC='渠道退货' then sl/100 else 0 end )as THL
FROM vw_routePeihuo数据显示 SL THL
1.00 0.010000
2.00 0.020000
3.00 0.030000 我想求的THL是0.01%哪位高手帮下
DJRQ,DJBH,DJMC,QDDM,
SL=(case when DJMC='渠道退货' then SL else 0 end ),
THL=CONVERT(VARCHAR,CONVERT(decimal(10,2),(case when DJMC='渠道退货' then sl/100 else 0 end )))+'%'
FROM vw_routePeihuo