Posted on: 2/28/2013 1:07:15 PM | Views : 281

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 ...