SQLServer2000 SUM 的值不确定？

发布时间：2020-12-12 15:40:08 所属栏目：MsSql教程来源：网络整理

导读：selectsum(dbo.fu_getHolsDay(emp_id,work_date,holskind_id,workhour,1)) as a13,sum(dbo.fu_getHolsDay(emp_id,3)) as a12,12)) as a13,13)) as a11,12)) as a15,sum(workhour)from vu_overtime_stat where dbo.fu_date2str(work_date,1) ='2008-08-11 'an

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

结果：

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

打sp4补丁后问题不存在了

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!