SELECT dbo.Empl.internal_id AS id, dbo.Empl.last_name + ', ' + dbo.Empl.First_name AS Staff_name, dbo.Empl.team_supervisor, dbo.Empl.supvr_chaps_id, A.total_overtime,
A.total_overtime_used, A.Balance, dbo.Empl.network_id
FROM dbo.Empl INNER JOIN
(SELECT network_id, SUM(DATEDIFF(MINUTE, '0:00:00', overtime_owed)) AS total_overtime, SUM(DATEDIFF(MINUTE, '0:00:00', overtime_taken))
AS total_overtime_used, SUM(DATEDIFF(MINUTE, '0:00:00', overtime_owed)) - SUM(DATEDIFF(MINUTE, '0:00:00', overtime_taken)) AS Balance
FROM dbo.tblOvertime
GROUP BY network_id) AS A ON dbo.Empl.network_id = A.network_id
WHERE (A.Balance <> 0)
I have the following sql statement calculates total minutes, the minutes are whole numbers, i would like to show them in ...
Go to the complete details ...