1
Vote

Issue with [HumanResources].[vEmployeeDepartment]

description

In the 2008 x64 distro of AWOLTP, theres a view named "[HumanResources].[vEmployeeDepartment]" The where clause is only correct at midnight local time. It should really be as follows:
 
WHERE CAST(GETDATE() AS DATE) BETWEEN edh.[StartDate] AND ISNULL(edh.[EndDate], GETDATE());

comments

SharePointInf wrote Feb 22, 2012 at 12:01 AM

Excellent observation and solution. I was going to troubleshoot it myself but I saw that you had already solved it. Thank you.