select sum(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=4 group by emp_id select (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补丁后问题不存在了