被零除错误?

[徐徐透之]

(select hh as hh,sum(sl)/convert(int,convert(datetime,[结束日期])-convert(datetime,[起始日期])) as rxhl,sum(sl)/convert(int,convert(datetime,[结束日期])-convert(datetime,[起始日期]))*30 as yxhl

被零除错误?
要求:想要加一个case when!
谢谢!

[-狙击手-]

case when 条件　then true else else end

[xiaoku]

问题和答案你都说了...

[百年树人]

(select 
  hh as hh,
  case when convert(int,convert(datetime,[结束日期])-convert(datetime,[起始日期]))=0 then 0
       else sum(sl)/convert(int,convert(datetime,[结束日期])-convert(datetime,[起始日期])) end as rxhl,
  case when convert(int,convert(datetime,[结束日期])-convert(datetime,[起始日期]))=0 then 0
       else sum(sl)/convert(int,convert(datetime,[结束日期])-convert(datetime,[起始日期]))*30 end as yxhl

[Ny-6000]

[Quote=引用 2 楼 xiaoku 的回复:]
问题和答案你都说了...
[/Quote]


那还问什么呢？？

[百年树人]

或者

(select 
  hh as hh,
  case when datediff(day,[起始日期],[结束日期])=0 then 0
       else sum(sl)/datediff(day,[起始日期],[结束日期]) end as rxhl,
  case when datediff(day,[起始日期],[结束日期])=0 then 0
       else sum(sl)/datediff(day,[起始日期],[结束日期])*30 end as yxhl 

[徐徐透之]

谢谢大家!结贴