There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Issue with [HumanResources].[vEmployeeDepartment]
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());