oralce中decode 改写为sqlserver中的case

你们都是坏人 2017-04-20 08:59:51

oracle中的sql现在要改为在sqlserver中运行，
如下sql该如何修改

oracle中的sql



decode(sign(unitweight),

                      1,

                      decode(sign(unitweight - 1), -1, '0', '') ||

                      to_char(unitweight),

                      decode(trim(unitweight_rpt),

                             null,

                             '0',

                             '',

                             '0',

                             unitweight_rpt)) as unitweight

...全文

63 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

你们都是坏人 2017-04-20

打赏
举报

引用 2 楼 wmxcn2000 的回复:


-- 试试这个 

case sign(unitweight)
     when  1 then case sign(unitweight - 1) when  -1 then  '0' else  '' end + ltrim(unitweight)
     else case when rtrim(ltrim(unitweight_rpt)) is null then '0' 
               when rtrim(ltrim(unitweight_rpt))= '' then '0'
               else unitweight_rpt
end as unitweight

谢谢！！！

卖水果的net 2017-04-20

打赏
举报


-- 楼主少写了一个 end 

case sign(unitweight)
     when  1 then case sign(unitweight - 1) when  -1 then  '0' else  '' end + ltrim(unitweight)
     else case when rtrim(ltrim(unitweight_rpt)) is null then '0' 
               when rtrim(ltrim(unitweight_rpt))= '' then '0'
               else unitweight_rpt
          end 
end as unitweight

卖水果的net 2017-04-20

打赏
举报


-- 试试这个 

case sign(unitweight)
     when  1 then case sign(unitweight - 1) when  -1 then  '0' else  '' end + ltrim(unitweight)
     else case when rtrim(ltrim(unitweight_rpt)) is null then '0' 
               when rtrim(ltrim(unitweight_rpt))= '' then '0'
               else unitweight_rpt
end as unitweight