(HOUR.DateWorked BETWEEN CAST('3/30/2005' AS DATETIME) AND CAST('4/5/2007' AS DATETIME)) -------------------------------------vs-------------------------------------- (HOUR.DateWorked BETWEEN CAST('3/30/2007' AS DATETIME) AND CAST('4/5/2007' AS DATETIME))时间区间长一点, 用时自然会长一点
AND CAST('4/5/2007' AS DATETIME))
-------------------------------------vs--------------------------------------
(HOUR.DateWorked BETWEEN CAST('3/30/2007' AS DATETIME)
AND CAST('4/5/2007' AS DATETIME))时间区间长一点, 用时自然会长一点
有一点忘记说了:邮件原文里面两个时间是一样的,由于在我本地没有数据,所以我把第一个时间区间改大了,还是没数据.