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());