select
AreaNo,
ItemFZZC,
ItemFZZC/(case when ItemNFMC=0 then 1 else ItemNFMC end) as ItemFZL,
ItemCHZC,
ItemCHZC/(case when ItemFZZC=0 then 1 else ItemFZZC end) AS ItemCHL,
ItemCHZC/(case when ItemNFMC=0 then 1 else ItemNFMC end) AS ItemFZCHL,
ItemCYCSW,
ItemCYCSW/(case when ItemNCSYTS=0 then 1 else ItemNCSYTS end) AS ItemSWL,
ItemCHZC-ItemCYCSW AS ItemZZS,
(ItemCHZC-ItemCYCSW)/(case when ItemNCSYTS=0 then 1 else ItemNCSYTS end) AS ItemZZL,
ItemCM,
ItemCM/(case when ItemNCSYTS=0 then 1 else ItemNCSYTS end) AS ItemCML,
ItemZZZS,
ItemZZZS/(case when ItemNCSYTS=0 then 1 else ItemNCSYTS end) AS ItemZSL,
ItemZZZS+ItemCMRC AS ItemCLS,
(ItemZZZS+ItemCMRC)/(case when ItemNCSYTS=0 then 1 else ItemNCSYTS end) AS ItemCLL
from
DataInfo,AreaInfo,ReportParameter
where
DataInfo.ParameterId=ReportParameter.ParameterId
and
Type=0
and
AreaNo=150000
and
DataInfo.YearInfo=2004
order by
DataInfo.ParameterId
AreaNo,
ItemFZZC,
ItemFZZC/(case when ItemNFMC=0 then 1 else ItemNFMC end) as ItemFZL,
ItemCHZC,
ItemCHZC/(case when ItemFZZC=0 then 1 else ItemFZZC end) AS ItemCHL,
ItemCHZC/(case when ItemNFMC=0 then 1 else ItemNFMC end) AS ItemFZCHL,
ItemCYCSW,
ItemCYCSW/(case when ItemNCSYTS=0 then 1 else ItemNCSYTS end) AS ItemSWL,
ItemCHZC-ItemCYCSW AS ItemZZS,
(ItemCHZC-ItemCYCSW)/(case when ItemNCSYTS=0 then 1 else ItemNCSYTS end) AS ItemZZL,
ItemCM,
ItemCM/(case when ItemNCSYTS=0 then 1 else ItemNCSYTS end) AS ItemCML,
ItemZZZS,
ItemZZZS/(case when ItemNCSYTS=0 then 1 else ItemNCSYTS end) AS ItemZSL,
ItemZZZS+ItemCMRC AS ItemCLS,
(ItemZZZS+ItemCMRC)/(case when ItemNCSYTS=0 then 1 else ItemNCSYTS end) AS ItemCLL
from
DataInfo,AreaInfo,ReportParameter
where
DataInfo.ParameterId=ReportParameter.ParameterId
and
Type=0
and
AreaNo=150000
and
DataInfo.YearInfo=2004
order by
DataInfo.ParameterId
--ItemFZZC/ItemNFMC as ItemFZL,
case when ItemNFMC=0 then 0 else ItemFZZC/ItemNFMC end as ItemFZL,
--以上是修改的一个例子,其他的你自己改吧ItemCHZC,
ItemCHZC/ItemFZZC AS ItemCHL, --这里要改
ItemCHZC/ItemNFMC AS ItemFZCHL, --这里要改
ItemCYCSW,
ItemCYCSW/ItemNCSYTS AS ItemSWL, --这里要改
ItemCHZC-ItemCYCSW AS ItemZZS, --这里要改
(ItemCHZC-ItemCYCSW)/ItemNCSYTS AS ItemZZL, --这里也要改
ItemCM,
ItemCM/ItemNCSYTS AS ItemCML, --这里
ItemZZZS,
ItemZZZS/ItemNCSYTS AS ItemZSL, --这里
ItemZZZS+ItemCMRC AS ItemCLS,
(ItemZZZS+ItemCMRC)/ItemNCSYTS AS ItemCLL --这里也要改
from DataInfo,AreaInfo,ReportParameter where DataInfo.ParameterId=ReportParameter.ParameterId and Type=0 and AreaNo=150000 and DataInfo.YearInfo=2004 order by DataInfo.ParameterId
where时别把0的select出来,而是单独去做处理。
应该可以解决问题了