Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
select workdate, empId, L.LastName + ', ' + L.FirstName AS Name, ManagerUID, convert(varchar(5), dateadd(second, Total_WorkDate_Units, '0:00:00'),108) as HrsMin, CASE WHEN @Clients = -1 then L.Class IN (2, 6) END from Employee_Work_Units_Summary s inner join dbo.EmployeeList L on s.empId = L.EmployeeId where Total_WorkDate_Units > 32400 AND (L.Suspend = 0) and (ManagerUID = ISNULL(NULLIF (@Supervisor, 0), ManagerUID)) AND (@Employee =0 or L.EmployeeId =@Employee) Order by workdate, Name]
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.