过程SP_ZY_CYBRCJFYXX中最后总计语句：
----合计-----
  Insert into BM_YYSFTJ(ID0000,BMBH00,
  SFXM01,SFXM02,SFXM03,SFXM04,SFXM05,SFXM06,
  SFXM07,SFXM08,SFXM09,SFXM10,SFXM11,SFXM12,SFXM13,SFXM99)
  select ID0000,999999999,
  sum(SFXM01),sum(SFXM02),sum(SFXM03),
  decode(nvl(sum(SFXM02),0),0,0,round(sum(SFXM03)*100/sum(SFXM02),2)),
  decode(nvl(sum(SFXM01),0),0,0,round(sum(SFXM02)/sum(SFXM01),2)),
  decode(nvl(sum(SFXM01),0),0,0,round(sum(SFXM03)/sum(SFXM01),2)),
  sum(SFXM07),sum(SFXM08),sum(SFXM09),  
  decode(nvl(sum(SFXM07),0),0,0,round(sum(SFXM08)/sum(SFXM07),2)),
  decode(nvl(sum(SFXM07),0),0,0,round(sum(SFXM09)/sum(SFXM07),2)),
  decode(nvl((sum(SFXM02)/sum(SFXM01)),0),0,0,round(((sum(SFXM02)/sum(SFXM01))-decode(nvl(sum(SFXM07),0),0,0,(sum(SFXM08)/sum(SFXM07))))*100/(sum(SFXM02)/sum(SFXM01)),2)),
  decode(nvl((sum(SFXM03)/sum(SFXM01)),0),0,0,round(((sum(SFXM03)/sum(SFXM01))-decode(nvl(sum(SFXM07),0),0,0,(sum(SFXM09)/sum(SFXM07))))*100/(sum(SFXM03)/sum(SFXM01)),2)), 
  99
  from BM_YYSFTJ where ID0000=ad_ID0000 and SFXM99=9
  group by ID0000;


在同安中医院这边 表两个字段SFXM01，SFXM07 在统计某一天时为0，错误提示：除数为 0执行存储过程错误:SP_ZY_CYBRCJFYXX(20110201,20110201,-1ad_ID0000,as_YHMSG0,as_SYSMSG。