Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
SELECT Training_Hours_Exception2.TrainingDate, Training_Hours_Exception2.Trainee, Training_Hours_Exception2.TotalHours, dbo.Training_Employees.SubDept AS EmpDepartment, dbo.Training_Employees.Position, dbo.Calendar.OfficeWorkdays, dbo.Calendar.EmpTaskHours, dbo.Calendar.CalendarDays FROM (SELECT TrainingDate, Trainee, SUM(TotalHours) AS TotalHours FROM dbo.Training_Hours_Exception GROUP BY TrainingDate, Trainee) AS Training_Hours_Exception2 INNER JOIN dbo.Calendar ON Training_Hours_Exception2.TrainingDate = dbo.Calendar.CalendarDays LEFT OUTER JOIN dbo.Training_Employees ON Training_Hours_Exception2.Trainee = dbo.Training_Employees.FullName WHERE (dbo.Training_Employees.Position NOT LIKE 'Manager') AND (dbo.Calendar.OfficeWorkdays LIKE 'Workday') AND (Training_Hours_Exception2.TotalHours <> 7.5)
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.