DATEDIFF(MINUTE, @StartTime, @EndTime) - isnull(datediff(minute, break_start, break_end), 0))/ 60.0) LEFT JOIN pmis.dbo.time_reference as b ON b.code = ISNULL(a.TimeReference, 'TIME14')
cross
cmb_tutti_i_log.Items.Add(log.Log) Dim myNewLog As New EventLog("PMIS_A2AmyNewLog.EntryWritten, AddressOf Me.MyOnEntryWritten myNewLog.WriteEntry("PMIS_A2A
(datediff(minute, break_start, break_end), 0))/ 60.0)), '0.00')LEFT JOIN pmis.dbo.employeeas b ON a.eid = b.eid
LEFT JOIN pmis.dbo.time_reference as c ON c.code = ISNULL(b.TimeReference, 'TIME14