EmpID DateTime StatusINOUT 1 2018-05-26 08:44 1 1 2018-05-26 08:44 2 2 2018-05-28 08:44 1 2 2018-05-28 12:44 2 1 2018-05-21 08:44 1 1 2018-05-21 10:44 2 2 2018-05-23 08:44 1 2 2018-05-23 08:44 2
Empid INTIME(1) OUTIME(2) 1 2018-05-26 08:44 2018-05-26 08:44 2 2018-05-28 08:44 2018-05-28 12:44 1 2018-05-21 08:44 2018-05-21 10:44 2 2018-05-23 08:44 2018-05-23 08:44
select Empcode, s1 as 'INOUT (1)INTime', s2 as 'INOUT(2)OutTime' from ( select Empcode,Time,INOUT,Date from HR2 ) d pivot ( max(Date) for INOUT in (s1,s2) ) piv;
Select EmpID, MIN([DateTime]) as InTime, MAX([DateTime]) as OutTime FROM (SELECT EmpID, [DateTime], CAST([DateTime] AS DATE) AS DT FROM HR2) a GROUP BY a.EmpID, a.DT
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)