I m using sqlserver there is table name of Attendence
Columns of Tables are
1)EmpCode int
2)AttendenceDate datetime
3)AttendenceTime Datetime
4)status tinyint
Data in table would be like this
Code AttendenceDate AttendenceTime status
1001 3/27/2009 3/27/2009 9:05 1
1001 3/27/2009 3/27/2009 7:05 0
1002 3/28/2009 3/27/2009 10:05 1 //user didnot checkout
1003 3/29/2009 3/27/2009 7:05 1
1003 3/29/2009 3/27/2009 7:05 0
1001 3/30/2009 3/27/2009 7:05 1
1001 3/30/2009 3/27/2009 7:05 0
1003 3/29/2009 3/27/2009 7:05 0 //User didnot checkin
when we find "1" in staus it means its checkin and "0" means Check out
i have to make query to show the result like this
Code date Time in Time out
1001 3/27/2009 9:05 7:05
basically i get this data inform of txt file which is generated by machine .where user check in it stores the data and he may go for outdoor work to get late not to come back to check out ...
How to make a perfect and happy query for it
Thanks in advance
waiting
