SQLServer2000 SUM 的值不确定？

来源：互联网发布：mac铃声导入iphone 编辑：程序博客网时间：2024/05/23 11:57

selectsum(dbo.fu_getHolsDay(emp_id,work_date,holskind_id,workhour,1)) as a13 ,sum(dbo.fu_getHolsDay(emp_id,work_date,holskind_id,workhour,3)) as a12,sum(dbo.fu_getHolsDay(emp_id,work_date,holskind_id,workhour,12)) as a13 ,sum(dbo.fu_getHolsDay(emp_id,work_date,holskind_id,workhour,13)) as a11,sum(dbo.fu_getHolsDay(emp_id,work_date,holskind_id,workhour,12)) as a15,sum(workhour)from vu_overtime_stat where dbo.fu_date2str(work_date,1) >='2008-08-11 'and dbo.fu_date2str(work_date,1) <='2008-08-11' and emp_id=4group by emp_idselect(dbo.fu_getHolsDay(emp_id,work_date,holskind_id,workhour,9)) as a9,(dbo.fu_getHolsDay(emp_id,work_date,holskind_id,workhour,10)) as a10,(dbo.fu_getHolsDay(emp_id,work_date,holskind_id,workhour,11)) as a11,(dbo.fu_getHolsDay(emp_id,work_date,holskind_id,workhour,12)) as a12,(dbo.fu_getHolsDay(emp_id,work_date,holskind_id,workhour,13)) as a13 ,(workhour)from vu_overtime_stat where dbo.fu_date2str(work_date,1) >='2008-08-11 'and dbo.fu_date2str(work_date,1) <='2008-08-11' and emp_id=4

结果：

结果中第一行应该是a12=a15 = 0.5,可是却是0

打sp4补丁后问题不存在了