Generate Attendance Report from database record
USERID CHECKTIME
5 2019-04-16 17:19:23.000
5 2019-04-17 06:56:33.000
5 2019-04-17 18:52:30.000
5 2019-04-18 07:01:43.000
5 2019-04-18 20:00:22.000
5 2019-04-23 07:35:55.000
kindly assist with an sql query to generate:
Userid Date TimeIN TimeOut Remarks
5 2019-04-16 17:19:23 Didnt Clock Out
5 2019-04-17 06:56:33 18:52:30
5 2019-04-18 07:01:43 20:00:22
5 2019-04-23 07:35:55 17.52:02