Closed GoogleCodeExporter closed 8 years ago
Query que en ppio resolveria este listado.
select emp.NroEmpleado,emp.Nombre, emp.Apellido, emp.NumeroDocumento,
emp.Turno,
cast(sec_to_time(sum(time_to_sec(TIMEDIFF(hge.HoraSalida,hge.HoraEntrada)))) as
CHAR) as Horas from Empleados emp, horasgeneradasescalafon hge where
hge.NumeroCliente=NROCLIENTE and hge.NumeroServicio=NROSERVICIO and
MONTH('FECHA')= MONTH(hge.FechaCorrespondiente) and YEAR('FECHA') =
YEAR(hge.FechaCorrespondiente) and emp.NroEmpleado = hge.NroEmpleado group by
emp.NroEmpleado,emp.Nombre, emp.Apellido, emp.NumeroDocumento, emp.Turno
1 Hora.
Original comment by juanga...@gmail.com
on 10 Feb 2011 at 5:03
Original comment by juanga...@gmail.com
on 2 Apr 2011 at 11:20
Original comment by juanga...@gmail.com
on 21 Apr 2011 at 4:28
Original issue reported on code.google.com by
juanga...@gmail.com
on 10 Feb 2011 at 1:25