November 18, 2016 at 1:00 pm
I am writing a report in SQL 2008 R2 to find the turn around time for an operating room. I have the time patient is out of room and the time the next patient is in room. Can someone tell me how to figure out the time difference between TimeOutRoom and TimeInRoom on the next patient for the same day?
create table #Test
(
UnvUserID varchar(30),
OperDate datetime,
TimeInRoom varchar(10),
TimeOutRoom varchar(10),
SeqNum int
)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-12','12:59','14:13',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-12','14:55','16:58',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-13','09:14','10:22',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-24','10:57','12:20',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-24','12:57','14:38',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-28','11:21','12:28',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-28','17:25','19:15',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-05','07:37','10:49',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-05','11:33','13:38',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-05','14:13','16:59',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-05','18:02','21:15',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-05','22:49','02:40',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-06','13:41','15:08',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-06','17:20','18:25',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-07','10:39','14:38',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-07','16:21','18:36',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-07','19:10','21:07',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-12','07:34','11:28',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-12','12:24','15:51',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-12','16:46','17:30',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-12','18:07','18:41',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-12','20:06','20:56',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-13','20:30','00:25',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-19','07:35','09:44',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-19','10:26','12:18',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-19','12:45','14:21',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-19','14:46','16:28',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-20','13:45','15:40',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-20','16:49','19:28',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-26','07:45','09:12',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-27','13:28','14:52',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-28','18:46','00:07',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('AQSIDDIQ','2016-10-28','22:33','23:05',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('BAROSENB','2016-10-11','12:52','14:19',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('BAROSENB','2016-10-25','12:09','13:37',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DADRINKW','2016-10-31','10:00','10:49',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DAHYATT','2016-10-14','11:52','13:21',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DAHYATT','2016-10-25','16:17','16:55',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DAKASHME','2016-10-04','15:30','17:45',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DAKASHME','2016-10-06','14:33','15:44',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DAKASHME','2016-10-07','14:50','16:24',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DAKASHME','2016-10-19','16:20','17:32',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DAKASHME','2016-10-20','06:15','07:33',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DAKASHME','2016-10-21','06:14','12:00',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DAKASHME','2016-10-21','21:25','22:33',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DASIPALA','2016-10-06','07:35','09:09',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DASIPALA','2016-10-06','09:34','10:40',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DASIPALA','2016-10-06','11:21','12:22',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DASIPALA','2016-10-11','07:34','10:08',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DASIPALA','2016-10-11','10:52','13:38',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-07','08:32','09:05',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-07','09:32','10:21',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-12','13:30','18:54',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-14','07:33','08:47',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-19','12:17','16:14',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-21','08:37','09:31',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-21','09:58','10:41',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-21','11:47','14:21',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-26','11:13','12:16',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-28','08:34','09:44',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-28','10:31','11:13',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-28','12:01','12:25',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-28','12:40','13:10',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DESESHAD','2016-10-28','13:54','19:13',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DOOBRIEN','2016-10-06','07:27','07:42',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DOOBRIEN','2016-10-06','08:01','08:16',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DOOBRIEN','2016-10-06','08:39','09:19',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DOOBRIEN','2016-10-06','09:50','10:38',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('DOOBRIEN','2016-10-17','14:32','14:52',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-01','09:02','09:40',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-04','07:38','09:31',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-04','10:00','10:23',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-04','11:44','13:23',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-04','14:09','14:48',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-04','14:49','15:26',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-04','15:36','16:58',6)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-04','17:11','18:33',7)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-11','08:10','09:58',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-11','10:36','11:48',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-11','11:52','13:34',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-11','14:08','15:07',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-11','15:12','16:35',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-11','16:34','17:19',6)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-18','07:38','08:54',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-18','09:17','10:50',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-18','10:52','12:40',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-18','12:34','13:11',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-18','13:40','14:43',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-18','14:49','15:25',6)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-18','15:44','17:07',7)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-18','17:11','18:07',8)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-25','07:29','09:11',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-25','09:06','10:32',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-25','11:04','12:18',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-25','12:25','14:13',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-25','14:04','14:55',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-25','15:07','16:02',6)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-25','16:05','17:55',7)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-25','17:45','18:15',8)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('GEALMACA','2016-10-25','18:29','18:42',9)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('HDSNYDER','2016-10-04','07:39','09:22',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('HDSNYDER','2016-10-04','10:06','10:22',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('HDSNYDER','2016-10-04','10:50','11:08',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('HDSNYDER','2016-10-04','11:44','12:00',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('HDSNYDER','2016-10-11','07:32','07:45',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('HDSNYDER','2016-10-11','08:25','08:39',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('HDSNYDER','2016-10-11','09:08','09:35',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('HYHUR','2016-10-07','08:49','13:05',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('HYHUR','2016-10-07','13:27','17:23',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('HYHUR','2016-10-21','08:51','13:27',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JADHINGR1','2016-10-21','08:44','10:45',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JAFITZGE','2016-10-05','07:32','08:32',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JAFITZGE','2016-10-05','08:52','09:57',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JAFITZGE','2016-10-05','10:22','11:15',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JAFITZGE','2016-10-13','13:00','14:03',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JAFITZGE','2016-10-14','10:00','10:40',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JAFITZGE','2016-10-14','11:01','11:44',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JAFITZGE','2016-10-14','12:11','12:57',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JAFITZGE','2016-10-14','13:18','14:06',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JAFITZGE','2016-10-14','14:26','15:09',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JAFITZGE','2016-10-17','13:14','14:00',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JAFITZGE','2016-10-20','23:10','00:29',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JAFITZGE','2016-10-27','13:09','13:52',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JAFITZGE','2016-10-27','14:17','15:21',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-05','20:18','21:02',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-05','21:50','22:20',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-05','22:55','23:57',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-06','07:34','09:49',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-06','10:21','11:44',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-06','12:10','13:43',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-06','14:16','14:57',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-13','07:27','08:06',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-13','08:35','09:44',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-13','10:11','11:01',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-13','12:02','14:04',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-14','12:34','13:18',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-20','07:33','10:22',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-20','11:04','13:20',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-20','13:46','14:37',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-20','14:54','15:31',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-27','07:43','08:34',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-27','09:10','10:26',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-27','10:57','11:44',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-27','12:23','13:23',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEGASSMA','2016-10-27','14:02','15:47',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-03','07:53','09:40',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-03','10:04','10:57',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-03','11:28','13:10',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-03','13:40','14:30',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-04','10:58','11:43',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-04','12:05','13:22',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-05','13:14','14:02',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-05','14:43','16:03',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-06','07:16','08:29',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-06','08:54','10:54',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-06','12:47','14:01',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-07','08:28','09:13',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-07','09:44','10:44',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-13','08:58','09:46',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-13','10:05','11:10',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-13','11:52','13:00',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-13','13:25','16:02',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-14','09:07','11:04',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-14','11:31','13:18',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-17','08:03','10:25',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-17','10:37','11:42',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-17','11:59','13:23',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-26','13:11','14:31',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-26','14:48','16:56',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-27','07:28','08:41',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-27','09:05','09:56',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-27','10:27','11:59',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-27','13:27','15:27',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-27','15:50','16:31',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-28','08:13','09:51',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-28','10:14','10:41',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-31','07:15','08:20',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-31','08:39','09:21',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-31','11:32','14:10',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-31','14:42','16:20',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JEMACVIC','2016-10-31','16:52','19:06',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JOCOYNE','2016-10-20','08:10','09:00',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('JOCOYNE','2016-10-20','09:15','09:56',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KALUND','2016-10-04','12:55','13:39',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KALUND','2016-10-04','13:56','14:32',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KALUND','2016-10-04','14:43','15:18',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KALUND','2016-10-11','12:41','13:22',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KALUND','2016-10-11','13:38','14:30',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KALUND','2016-10-11','14:53','15:39',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KALUND','2016-10-18','13:00','13:40',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KALUND','2016-10-25','12:44','13:17',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KALUND','2016-10-25','13:32','14:23',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEMERLIN','2016-10-31','08:33','09:03',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEMERLIN','2016-10-31','09:29','10:02',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEMERLIN','2016-10-31','11:03','11:32',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEMERLIN','2016-10-31','11:57','12:29',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEPAHUJA','2016-10-03','12:05','20:22',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEPAHUJA','2016-10-07','11:44','13:49',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEPAHUJA','2016-10-08','16:56','18:39',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEPAHUJA','2016-10-14','08:27','10:30',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEPAHUJA','2016-10-17','14:37','15:14',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEPAHUJA','2016-10-20','13:22','16:02',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEPAHUJA','2016-10-20','18:08','20:01',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEPAHUJA','2016-10-24','08:42','22:27',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEPAHUJA','2016-10-25','07:57','10:17',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEPAHUJA','2016-10-27','10:25','11:44',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KEPAHUJA','2016-10-31','10:58','13:05',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KRRATLIF','2016-10-13','07:38','09:54',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KRRATLIF','2016-10-13','10:46','13:19',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KRRATLIF','2016-10-13','14:00','14:46',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KRRATLIF','2016-10-13','15:28','16:32',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KRRATLIF','2016-10-27','07:30','10:20',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('KRRATLIF','2016-10-31','07:33','08:11',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('LABROWN1','2016-10-14','14:03','15:14',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('LABROWN1','2016-10-25','07:28','08:14',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('LABROWN1','2016-10-25','08:49','09:48',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('LEGARRET','2016-10-14','07:30','10:09',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('LEGARRET','2016-10-14','11:01','14:01',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('LEGARRET','2016-10-21','08:37','11:20',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('LEGARRET','2016-10-21','12:01','14:42',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('LEGARRET','2016-10-21','15:12','17:34',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-03','07:23','08:17',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-03','08:56','10:52',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-03','11:53','13:07',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-03','14:02','16:05',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-03','16:27','17:40',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-04','18:50','20:10',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-13','07:33','09:23',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-13','09:57','11:29',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-13','11:56','12:23',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-13','12:56','14:28',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-17','07:30','09:18',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-17','09:41','10:15',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-17','10:47','13:47',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-17','14:31','15:13',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-17','15:43','17:51',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-17','19:34','21:55',6)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-20','07:36','09:16',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-20','09:46','10:22',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-20','10:44','11:11',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-20','11:39','12:07',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-20','12:30','13:19',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-27','07:30','07:59',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-27','08:34','10:31',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-27','11:13','12:18',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-27','12:59','14:58',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-27','15:31','16:49',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-31','07:39','09:44',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-31','10:32','12:22',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAARMITA','2016-10-31','13:04','14:45',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MAMOSSAN','2016-10-16','14:25','15:06',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MARAO1','2016-10-03','13:21','13:55',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MARAO1','2016-10-04','08:13','09:11',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MARAO1','2016-10-06','13:10','13:44',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MARAO1','2016-10-14','13:46','15:05',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MARAO1','2016-10-17','17:15','17:54',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MARAO1','2016-10-18','07:30','09:15',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MARAO1','2016-10-18','09:47','10:21',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MARAO1','2016-10-18','10:55','11:58',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MARAO1','2016-10-21','13:28','14:20',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MARAO1','2016-10-24','09:34','10:23',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MARAO1','2016-10-24','11:00','16:48',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MARAO1','2016-10-28','13:07','13:40',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIFINKLE','2016-10-06','07:42','09:32',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIFINKLE','2016-10-11','07:18','07:53',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIFINKLE','2016-10-18','12:32','13:07',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIFINKLE','2016-10-18','13:39','14:24',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIFINKLE','2016-10-18','14:50','15:25',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-03','07:57','08:48',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-03','09:13','10:04',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-03','10:31','12:55',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-03','13:21','14:08',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-03','14:31','15:57',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-04','07:52','08:59',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-04','12:56','13:46',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-04','14:14','14:55',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-05','07:29','09:12',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-05','09:40','10:58',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-05','11:31','12:53',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-06','07:32','08:22',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-06','08:46','09:13',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-06','11:57','13:54',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-07','11:20','12:09',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-11','07:30','08:30',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-11','12:48','14:22',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-11','14:53','15:44',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-12','07:29','08:56',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-12','09:23','10:41',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-12','11:08','12:38',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-13','07:23','08:06',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-17','13:58','14:42',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-17','15:34','16:36',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-18','07:35','08:33',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-18','14:31','15:40',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-19','07:35','08:32',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-19','09:03','09:55',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-19','10:35','11:41',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-20','08:50','10:00',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-20','10:30','11:17',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-20','11:41','12:46',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-20','13:18','13:53',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-24','07:36','08:27',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-25','12:55','14:28',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-26','07:38','09:37',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-26','10:05','11:10',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-26','11:19','12:13',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-27','07:35','08:45',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('MIMCCOOB','2016-10-31','07:32','08:45',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-04','07:27','08:55',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-04','09:28','10:27',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-04','11:08','11:58',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-13','07:32','08:11',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-13','16:52','18:46',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-14','15:30','16:05',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-18','07:29','08:28',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-18','09:12','10:59',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-20','10:50','11:25',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-20','12:07','12:53',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-21','14:25','15:10',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-27','07:26','08:35',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-27','09:13','09:52',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-28','14:08','14:45',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NALOPUSH','2016-10-28','15:01','15:47',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('NIVEGA','2016-10-18','12:53','14:28',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PAMCCAHI','2016-10-04','12:45','14:22',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PAMCCAHI','2016-10-04','18:08','18:45',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PAMCCAHI','2016-10-14','17:10','17:49',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PAMCCAHI','2016-10-14','18:13','19:23',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PAMCCAHI','2016-10-28','12:09','12:51',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PAMCCAHI','2016-10-28','13:12','13:47',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PRPRADHA','2016-10-28','08:40','09:06',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PRPRADHA','2016-10-28','09:28','10:03',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PRPRADHA','2016-10-28','10:36','11:24',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PRPRADHA','2016-10-28','11:50','12:30',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PRPRADHA','2016-10-28','13:02','13:59',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PRPRADHA','2016-10-28','14:29','15:11',6)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PRPRADHA','2016-10-28','15:38','16:12',7)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PRPRADHA','2016-10-28','17:06','18:02',8)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PRPRADHA','2016-10-28','19:53','20:31',9)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PVENKAT','2016-10-03','07:37','08:43',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PVENKAT','2016-10-06','10:24','11:05',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('PVENKAT','2016-10-06','11:46','12:40',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('REWEAVER','2016-10-03','07:50','10:59',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('REWEAVER','2016-10-03','11:04','11:59',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('REWEAVER','2016-10-05','12:56','15:38',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('REWEAVER','2016-10-17','07:51','13:46',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('REWEAVER','2016-10-20','07:54','10:48',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('REWEAVER','2016-10-28','13:09','14:32',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('REWEAVER','2016-10-31','09:24','10:07',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-12','07:42','09:39',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-12','10:25','13:10',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-12','12:50','15:00',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-15','10:06','12:02',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-16','12:09','13:35',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-17','07:43','09:43',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-17','09:41','11:39',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-17','11:24','13:17',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-17','13:09','15:13',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-24','07:37','09:22',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-24','09:14','11:43',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-24','11:33','13:23',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-26','07:30','08:34',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-26','09:10','10:12',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-26','10:47','11:32',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-26','12:06','12:49',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-31','07:43','09:38',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-31','09:47','11:41',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-31','11:36','13:48',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RIMULROY','2016-10-31','13:29','15:07',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ROZUNENS','2016-10-20','07:27','08:01',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ROZUNENS','2016-10-20','08:37','09:17',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RUSHU','2016-10-05','07:48','08:01',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RUSHU','2016-10-05','08:08','08:19',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RUSHU','2016-10-05','08:50','09:29',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RUSHU','2016-10-05','09:56','10:53',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RUSHU','2016-10-05','11:14','11:31',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RUSHU','2016-10-14','13:03','14:01',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RUSHU','2016-10-19','07:30','08:21',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RUSHU','2016-10-19','08:39','09:02',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RUSHU','2016-10-26','07:22','07:58',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RUSHU','2016-10-26','08:17','08:51',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RYFRANKE1','2016-10-19','07:28','09:31',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RYFRANKE1','2016-10-19','10:09','11:14',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RYFRANKE1','2016-10-26','07:26','08:08',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RYFRANKE1','2016-10-26','08:32','09:12',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RYFRANKE1','2016-10-26','09:35','10:04',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RYFRANKE1','2016-10-28','08:41','09:23',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RYFRANKE1','2016-10-28','09:41','10:21',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RYFRANKE1','2016-10-28','10:39','11:14',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RYFRANKE1','2016-10-29','08:28','09:15',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RYFRANKE1','2016-10-31','13:02','13:58',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RYFRANKE1','2016-10-31','14:33','15:17',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('RYFRANKE1','2016-10-31','16:01','16:32',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SACARTER1','2016-10-06','23:57','01:08',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SACARTER1','2016-10-10','11:25','13:00',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SACARTER1','2016-10-10','18:45','20:11',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SACARTER1','2016-10-23','18:07','19:34',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SADONEGA','2016-10-17','07:29','08:08',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SADONEGA','2016-10-27','11:00','11:46',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-04','13:10','15:12',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-05','07:39','09:07',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-05','09:49','10:42',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-05','11:29','13:46',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-10','20:53','21:09',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-12','07:44','09:42',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-12','10:31','11:30',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-14','07:30','08:34',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-14','09:18','10:43',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-14','11:35','12:54',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-14','13:40','15:18',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-19','07:40','09:32',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-21','08:37','10:06',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-23','08:40','10:54',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-26','07:39','08:46',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-26','09:30','12:30',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-26','13:30','14:09',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-26','15:12','17:03',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-28','08:36','09:06',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-28','09:49','11:13',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-28','11:53','13:04',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SCMANDEL','2016-10-28','14:12','16:00',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('SOHANJAN','2016-10-28','14:20','15:13',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STMALONE','2016-10-03','17:55','19:56',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STMALONE','2016-10-04','16:06','18:34',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STMALONE','2016-10-06','14:25','17:19',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STMALONE','2016-10-07','08:48','14:02',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STMALONE','2016-10-08','11:00','14:08',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STMALONE','2016-10-11','11:25','12:18',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STMALONE','2016-10-11','12:53','13:48',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STMALONE','2016-10-13','14:59','19:24',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STMALONE','2016-10-19','10:26','13:06',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STMALONE','2016-10-21','08:45','14:17',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STMALONE','2016-10-27','13:03','15:27',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STMALONE','2016-10-29','13:05','16:29',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STMALONE','2016-10-30','14:22','15:14',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STPIDGEO','2016-10-14','07:29','09:02',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STPIDGEO','2016-10-14','09:31','10:05',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STPIDGEO','2016-10-28','08:24','09:25',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STPIDGEO','2016-10-28','09:50','10:27',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STPIDGEO','2016-10-28','10:59','11:49',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('STPIDGEO','2016-10-28','12:05','12:30',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('TIHRON','2016-10-30','23:40','00:30',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('TUWATERS','2016-10-05','12:16','13:40',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('TUWATERS','2016-10-05','14:12','15:37',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('TUWATERS','2016-10-05','15:57','17:30',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('TUWATERS','2016-10-06','11:32','12:17',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('TUWATERS','2016-10-06','12:55','13:51',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('TUWATERS','2016-10-13','07:37','11:22',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('TUWATERS','2016-10-13','12:27','14:45',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('TUWATERS','2016-10-24','07:27','08:54',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('TUWATERS','2016-10-24','09:30','10:12',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VAATANAS','2016-10-04','09:32','10:29',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VAATANAS','2016-10-04','11:00','12:03',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VAATANAS','2016-10-11','08:54','09:47',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VAATANAS','2016-10-18','08:57','09:28',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VAATANAS','2016-10-18','09:58','10:31',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VAATANAS','2016-10-18','11:01','11:55',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VAATANAS','2016-10-18','12:15','13:47',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VAATANAS','2016-10-18','16:44','18:55',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VAATANAS','2016-10-25','07:27','08:24',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VAATANAS','2016-10-25','09:25','10:35',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VAATANAS','2016-10-25','11:11','12:09',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-04','07:22','07:45',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-04','07:50','08:14',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-04','08:18','08:45',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-04','08:50','09:17',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-04','09:13','09:35',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-04','09:41','10:05',6)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-04','10:09','10:34',7)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-04','10:40','11:00',8)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-04','11:04','11:31',9)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-04','11:35','12:00',10)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-04','12:08','12:21',11)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-04','12:27','12:36',12)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-11','07:22','07:45',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-11','07:51','08:12',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-11','08:18','08:43',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-11','08:50','09:15',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-11','09:20','09:44',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-11','09:50','10:16',6)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-11','10:23','10:54',7)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-11','11:05','11:12',8)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-18','07:23','07:45',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-18','07:50','08:15',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-18','08:20','08:47',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-18','08:52','09:14',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-18','09:20','09:47',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-18','09:55','10:18',6)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-18','10:23','10:49',7)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-18','10:54','11:17',8)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-18','11:21','11:28',9)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-18','11:31','11:40',10)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-25','07:24','07:44',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-25','07:50','08:13',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-25','08:20','08:44',3)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-25','08:51','09:15',4)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-25','09:22','09:44',5)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-25','09:50','10:14',6)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-25','10:19','10:44',7)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-25','10:48','10:57',8)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('VITEWARI','2016-10-25','11:02','11:10',9)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('WAWAKIM','2016-10-26','01:27','12:59',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('WESUNG','2016-10-13','15:37','16:19',1)
November 18, 2016 at 1:23 pm
ok...thanks for the set up script....great help
so can you explain what result you wish
returned for just these rows please....it will clarify your requirement
create table #Test
(
UnvUserID varchar(30),
OperDate datetime,
TimeInRoom varchar(10),
TimeOutRoom varchar(10),
SeqNum int
)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-12','12:59','14:13',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-12','14:55','16:58',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-13','09:14','10:22',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-24','10:57','12:20',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-24','12:57','14:38',2)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-28','11:21','12:28',1)
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum) VALUES('ANTIWARY','2016-10-28','17:25','19:15',2)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 18, 2016 at 1:35 pm
Row 1 would be 0 (this is the first case of the day for this doctor
Row 2 would be time difference between 14:13 (TimeOutRoom in SeqNum 1)
and 14:55 (TimeInRoom in SeqNum 2) result should be 37.
Row 3 is a new date for this doctor so again it would be 0
It is the only one for this doctor on this day so nothing to calculate on this day
Row 4 new date for this doctor so it would be 0
Row 5 (12:20-12:57) would result in 37
Row 6 new date would be 0
Row 7 (12:28-17:25) would result in 4:57
Row 8 is a new doctor, forst for 10/05/16 result 0
Row 9 result would be 44
Please let me know if that makes more sense.
Thank you for your assistance,
Janet
November 19, 2016 at 3:06 am
You need to join the table back to itself to get the previous record, and then do the math
SELECT cur.*
, ISNULL(DATEDIFF(MINUTE, prev.TimeOutRoom, cur.TimeInRoom), 0) AS TurnaroundMinutes
FROM #Test AS cur
LEFT JOIN #Test AS prev
ON cur.UnvUserID = prev.UnvUserID
AND cur.OperDate = prev.OperDate
AND cur.SeqNum = prev.SeqNum +1
ORDER BY cur.OperDate, cur.SeqNum, cur.UnvUserID
November 19, 2016 at 2:27 pm
DesNorton (11/19/2016)
You need to join the table back to itself to get the previous record, and then do the math
SELECT cur.*
, ISNULL(DATEDIFF(MINUTE, prev.TimeOutRoom, cur.TimeInRoom), 0) AS TurnaroundMinutes
FROM #Test AS cur
LEFT JOIN #Test AS prev
ON cur.UnvUserID = prev.UnvUserID
AND cur.OperDate = prev.OperDate
AND cur.SeqNum = prev.SeqNum +1
ORDER BY cur.OperDate, cur.SeqNum, cur.UnvUserID
to get hours and minutes as OP requested
CONVERT( VARCHAR(5), DATEADD(minute, ISNULL(DATEDIFF(MINUTE, prev.TimeOutRoom, cur.TimeInRoom), 0), 0), 114) AS TurnaroundMinutes
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 20, 2016 at 3:27 am
One possible solution with an index added to the temp table which eliminates the hash match join
😎
The data seems a little strange though as there are overlaps which results in negative duration.
USE TEEST;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'tempdb..#Test') IS NOT NULL DROP TABLE #Test;
create table #Test
(
UnvUserID varchar(30),
OperDate datetime,
TimeInRoom varchar(10),
TimeOutRoom varchar(10),
SeqNum int
);
INSERT INTO #Test(UnvUserID,OperDate,TimeInRoom,TimeOutRoom,SeqNum)
VALUES
('ANTIWARY','2016-10-12','12:59','14:13',1)
,('ANTIWARY','2016-10-12','14:55','16:58',2)
,('ANTIWARY','2016-10-13','09:14','10:22',1)
,('ANTIWARY','2016-10-24','10:57','12:20',1)
,('ANTIWARY','2016-10-24','12:57','14:38',2)
,('ANTIWARY','2016-10-28','11:21','12:28',1)
,('ANTIWARY','2016-10-28','17:25','19:15',2)
,('AQSIDDIQ','2016-10-05','07:37','10:49',1)
,('AQSIDDIQ','2016-10-05','11:33','13:38',2)
,('AQSIDDIQ','2016-10-05','14:13','16:59',3)
,('AQSIDDIQ','2016-10-05','18:02','21:15',4)
,('AQSIDDIQ','2016-10-05','22:49','02:40',5)
,('AQSIDDIQ','2016-10-06','13:41','15:08',1)
,('AQSIDDIQ','2016-10-06','17:20','18:25',2)
,('AQSIDDIQ','2016-10-07','10:39','14:38',1)
,('AQSIDDIQ','2016-10-07','16:21','18:36',2)
,('AQSIDDIQ','2016-10-07','19:10','21:07',3)
,('AQSIDDIQ','2016-10-12','07:34','11:28',1)
,('AQSIDDIQ','2016-10-12','12:24','15:51',2)
,('AQSIDDIQ','2016-10-12','16:46','17:30',3)
,('AQSIDDIQ','2016-10-12','18:07','18:41',4)
,('AQSIDDIQ','2016-10-12','20:06','20:56',5)
,('AQSIDDIQ','2016-10-13','20:30','00:25',1)
,('AQSIDDIQ','2016-10-19','07:35','09:44',1)
,('AQSIDDIQ','2016-10-19','10:26','12:18',2)
,('AQSIDDIQ','2016-10-19','12:45','14:21',3)
,('AQSIDDIQ','2016-10-19','14:46','16:28',4)
,('AQSIDDIQ','2016-10-20','13:45','15:40',1)
,('AQSIDDIQ','2016-10-20','16:49','19:28',2)
,('AQSIDDIQ','2016-10-26','07:45','09:12',1)
,('AQSIDDIQ','2016-10-27','13:28','14:52',1)
,('AQSIDDIQ','2016-10-28','18:46','00:07',1)
,('AQSIDDIQ','2016-10-28','22:33','23:05',2)
,('BAROSENB','2016-10-11','12:52','14:19',1)
,('BAROSENB','2016-10-25','12:09','13:37',1)
,('DADRINKW','2016-10-31','10:00','10:49',1)
,( 'DAHYATT','2016-10-14','11:52','13:21',1)
,( 'DAHYATT','2016-10-25','16:17','16:55',1)
,('DAKASHME','2016-10-04','15:30','17:45',1)
,('DAKASHME','2016-10-06','14:33','15:44',1)
,('DAKASHME','2016-10-07','14:50','16:24',1)
,('DAKASHME','2016-10-19','16:20','17:32',1)
,('DAKASHME','2016-10-20','06:15','07:33',1)
,('DAKASHME','2016-10-21','06:14','12:00',1)
,('DAKASHME','2016-10-21','21:25','22:33',2)
,('DASIPALA','2016-10-06','07:35','09:09',1)
,('DASIPALA','2016-10-06','09:34','10:40',2)
,('DASIPALA','2016-10-06','11:21','12:22',3)
,('DASIPALA','2016-10-11','07:34','10:08',1)
,('DASIPALA','2016-10-11','10:52','13:38',2)
,('DESESHAD','2016-10-07','08:32','09:05',1)
,('DESESHAD','2016-10-07','09:32','10:21',2)
,('DESESHAD','2016-10-12','13:30','18:54',1)
,('DESESHAD','2016-10-14','07:33','08:47',1)
,('DESESHAD','2016-10-19','12:17','16:14',1)
,('DESESHAD','2016-10-21','08:37','09:31',1)
,('DESESHAD','2016-10-21','09:58','10:41',2)
,('DESESHAD','2016-10-21','11:47','14:21',3)
,('DESESHAD','2016-10-26','11:13','12:16',1)
,('DESESHAD','2016-10-28','08:34','09:44',1)
,('DESESHAD','2016-10-28','10:31','11:13',2)
,('DESESHAD','2016-10-28','12:01','12:25',3)
,('DESESHAD','2016-10-28','12:40','13:10',4)
,('DESESHAD','2016-10-28','13:54','19:13',5)
,('DOOBRIEN','2016-10-06','07:27','07:42',1)
,('DOOBRIEN','2016-10-06','08:01','08:16',2)
,('DOOBRIEN','2016-10-06','08:39','09:19',3)
,('DOOBRIEN','2016-10-06','09:50','10:38',4)
,('DOOBRIEN','2016-10-17','14:32','14:52',1)
,('GEALMACA','2016-10-01','09:02','09:40',1)
,('GEALMACA','2016-10-04','07:38','09:31',1)
,('GEALMACA','2016-10-04','10:00','10:23',2)
,('GEALMACA','2016-10-04','11:44','13:23',3)
,('GEALMACA','2016-10-04','14:09','14:48',4)
,('GEALMACA','2016-10-04','14:49','15:26',5)
,('GEALMACA','2016-10-04','15:36','16:58',6)
,('GEALMACA','2016-10-04','17:11','18:33',7)
,('GEALMACA','2016-10-11','08:10','09:58',1)
,('GEALMACA','2016-10-11','10:36','11:48',2)
,('GEALMACA','2016-10-11','11:52','13:34',3)
,('GEALMACA','2016-10-11','14:08','15:07',4)
,('GEALMACA','2016-10-11','15:12','16:35',5)
,('GEALMACA','2016-10-11','16:34','17:19',6)
,('GEALMACA','2016-10-18','07:38','08:54',1)
,('GEALMACA','2016-10-18','09:17','10:50',2)
,('GEALMACA','2016-10-18','10:52','12:40',3)
,('GEALMACA','2016-10-18','12:34','13:11',4)
,('GEALMACA','2016-10-18','13:40','14:43',5)
,('GEALMACA','2016-10-18','14:49','15:25',6)
,('GEALMACA','2016-10-18','15:44','17:07',7)
,('GEALMACA','2016-10-18','17:11','18:07',8)
,('GEALMACA','2016-10-25','07:29','09:11',1)
,('GEALMACA','2016-10-25','09:06','10:32',2)
,('GEALMACA','2016-10-25','11:04','12:18',3)
,('GEALMACA','2016-10-25','12:25','14:13',4)
,('GEALMACA','2016-10-25','14:04','14:55',5)
,('GEALMACA','2016-10-25','15:07','16:02',6)
,('GEALMACA','2016-10-25','16:05','17:55',7)
,('GEALMACA','2016-10-25','17:45','18:15',8)
,('GEALMACA','2016-10-25','18:29','18:42',9)
,('HDSNYDER','2016-10-04','07:39','09:22',1)
,('HDSNYDER','2016-10-04','10:06','10:22',2)
,('HDSNYDER','2016-10-04','10:50','11:08',3)
,('HDSNYDER','2016-10-04','11:44','12:00',4)
,('HDSNYDER','2016-10-11','07:32','07:45',1)
,('HDSNYDER','2016-10-11','08:25','08:39',2)
,('HDSNYDER','2016-10-11','09:08','09:35',3)
,( 'HYHUR','2016-10-07','08:49','13:05',1)
,( 'HYHUR','2016-10-07','13:27','17:23',2)
,( 'HYHUR','2016-10-21','08:51','13:27',1)
,('JADHINGR1','2016-10-21','08:44','10:45',1)
,('JAFITZGE','2016-10-05','07:32','08:32',1)
,('JAFITZGE','2016-10-05','08:52','09:57',2)
,('JAFITZGE','2016-10-05','10:22','11:15',3)
,('JAFITZGE','2016-10-13','13:00','14:03',1)
,('JAFITZGE','2016-10-14','10:00','10:40',1)
,('JAFITZGE','2016-10-14','11:01','11:44',2)
,('JAFITZGE','2016-10-14','12:11','12:57',3)
,('JAFITZGE','2016-10-14','13:18','14:06',4)
,('JAFITZGE','2016-10-14','14:26','15:09',5)
,('JAFITZGE','2016-10-17','13:14','14:00',1)
,('JAFITZGE','2016-10-20','23:10','00:29',1)
,('JAFITZGE','2016-10-27','13:09','13:52',1)
,('JAFITZGE','2016-10-27','14:17','15:21',2)
,('JEGASSMA','2016-10-05','20:18','21:02',1)
,('JEGASSMA','2016-10-05','21:50','22:20',2)
,('JEGASSMA','2016-10-05','22:55','23:57',3)
,('JEGASSMA','2016-10-06','07:34','09:49',1)
,('JEGASSMA','2016-10-06','10:21','11:44',2)
,('JEGASSMA','2016-10-06','12:10','13:43',3)
,('JEGASSMA','2016-10-06','14:16','14:57',4)
,('JEGASSMA','2016-10-13','07:27','08:06',1)
,('JEGASSMA','2016-10-13','08:35','09:44',2)
,('JEGASSMA','2016-10-13','10:11','11:01',3)
,('JEGASSMA','2016-10-13','12:02','14:04',4)
,('JEGASSMA','2016-10-14','12:34','13:18',1)
,('JEGASSMA','2016-10-20','07:33','10:22',1)
,('JEGASSMA','2016-10-20','11:04','13:20',2)
,('JEGASSMA','2016-10-20','13:46','14:37',3)
,('JEGASSMA','2016-10-20','14:54','15:31',4)
,('JEGASSMA','2016-10-27','07:43','08:34',1)
,('JEGASSMA','2016-10-27','09:10','10:26',2)
,('JEGASSMA','2016-10-27','10:57','11:44',3)
,('JEGASSMA','2016-10-27','12:23','13:23',4)
,('JEGASSMA','2016-10-27','14:02','15:47',5)
,('JEMACVIC','2016-10-03','07:53','09:40',1)
,('JEMACVIC','2016-10-03','10:04','10:57',2)
,('JEMACVIC','2016-10-03','11:28','13:10',3)
,('JEMACVIC','2016-10-03','13:40','14:30',4)
,('JEMACVIC','2016-10-04','10:58','11:43',1)
,('JEMACVIC','2016-10-04','12:05','13:22',2)
,('JEMACVIC','2016-10-05','13:14','14:02',1)
,('JEMACVIC','2016-10-05','14:43','16:03',2)
,('JEMACVIC','2016-10-06','07:16','08:29',1)
,('JEMACVIC','2016-10-06','08:54','10:54',2)
,('JEMACVIC','2016-10-06','12:47','14:01',3)
,('JEMACVIC','2016-10-07','08:28','09:13',1)
,('JEMACVIC','2016-10-07','09:44','10:44',2)
,('JEMACVIC','2016-10-13','08:58','09:46',1)
,('JEMACVIC','2016-10-13','10:05','11:10',2)
,('JEMACVIC','2016-10-13','11:52','13:00',3)
,('JEMACVIC','2016-10-13','13:25','16:02',4)
,('JEMACVIC','2016-10-14','09:07','11:04',1)
,('JEMACVIC','2016-10-14','11:31','13:18',2)
,('JEMACVIC','2016-10-17','08:03','10:25',1)
,('JEMACVIC','2016-10-17','10:37','11:42',2)
,('JEMACVIC','2016-10-17','11:59','13:23',3)
,('JEMACVIC','2016-10-26','13:11','14:31',1)
,('JEMACVIC','2016-10-26','14:48','16:56',2)
,('JEMACVIC','2016-10-27','07:28','08:41',1)
,('JEMACVIC','2016-10-27','09:05','09:56',2)
,('JEMACVIC','2016-10-27','10:27','11:59',3)
,('JEMACVIC','2016-10-27','13:27','15:27',4)
,('JEMACVIC','2016-10-27','15:50','16:31',5)
,('JEMACVIC','2016-10-28','08:13','09:51',1)
,('JEMACVIC','2016-10-28','10:14','10:41',2)
,('JEMACVIC','2016-10-31','07:15','08:20',1)
,('JEMACVIC','2016-10-31','08:39','09:21',2)
,('JEMACVIC','2016-10-31','11:32','14:10',3)
,('JEMACVIC','2016-10-31','14:42','16:20',4)
,('JEMACVIC','2016-10-31','16:52','19:06',5)
,( 'JOCOYNE','2016-10-20','08:10','09:00',1)
,( 'JOCOYNE','2016-10-20','09:15','09:56',2)
,( 'KALUND','2016-10-04','12:55','13:39',1)
,( 'KALUND','2016-10-04','13:56','14:32',2)
,( 'KALUND','2016-10-04','14:43','15:18',3)
,( 'KALUND','2016-10-11','12:41','13:22',1)
,( 'KALUND','2016-10-11','13:38','14:30',2)
,( 'KALUND','2016-10-11','14:53','15:39',3)
,( 'KALUND','2016-10-18','13:00','13:40',1)
,( 'KALUND','2016-10-25','12:44','13:17',1)
,( 'KALUND','2016-10-25','13:32','14:23',2)
,('KEMERLIN','2016-10-31','08:33','09:03',1)
,('KEMERLIN','2016-10-31','09:29','10:02',2)
,('KEMERLIN','2016-10-31','11:03','11:32',3)
,('KEMERLIN','2016-10-31','11:57','12:29',4)
,('KEPAHUJA','2016-10-03','12:05','20:22',1)
,('KEPAHUJA','2016-10-07','11:44','13:49',1)
,('KEPAHUJA','2016-10-08','16:56','18:39',1)
,('KEPAHUJA','2016-10-14','08:27','10:30',1)
,('KEPAHUJA','2016-10-17','14:37','15:14',1)
,('KEPAHUJA','2016-10-20','13:22','16:02',1)
,('KEPAHUJA','2016-10-20','18:08','20:01',2)
,('KEPAHUJA','2016-10-24','08:42','22:27',1)
,('KEPAHUJA','2016-10-25','07:57','10:17',1)
,('KEPAHUJA','2016-10-27','10:25','11:44',1)
,('KEPAHUJA','2016-10-31','10:58','13:05',1)
,('KRRATLIF','2016-10-13','07:38','09:54',1)
,('KRRATLIF','2016-10-13','10:46','13:19',2)
,('KRRATLIF','2016-10-13','14:00','14:46',3)
,('KRRATLIF','2016-10-13','15:28','16:32',4)
,('KRRATLIF','2016-10-27','07:30','10:20',1)
,('KRRATLIF','2016-10-31','07:33','08:11',1)
,('LABROWN1','2016-10-14','14:03','15:14',1)
,('LABROWN1','2016-10-25','07:28','08:14',1)
,('LABROWN1','2016-10-25','08:49','09:48',2)
,('LEGARRET','2016-10-14','07:30','10:09',1)
,('LEGARRET','2016-10-14','11:01','14:01',2)
,('LEGARRET','2016-10-21','08:37','11:20',1)
,('LEGARRET','2016-10-21','12:01','14:42',2)
,('LEGARRET','2016-10-21','15:12','17:34',3)
,('MAARMITA','2016-10-03','07:23','08:17',1)
,('MAARMITA','2016-10-03','08:56','10:52',2)
,('MAARMITA','2016-10-03','11:53','13:07',3)
,('MAARMITA','2016-10-03','14:02','16:05',4)
,('MAARMITA','2016-10-03','16:27','17:40',5)
,('MAARMITA','2016-10-04','18:50','20:10',1)
,('MAARMITA','2016-10-13','07:33','09:23',1)
,('MAARMITA','2016-10-13','09:57','11:29',2)
,('MAARMITA','2016-10-13','11:56','12:23',3)
,('MAARMITA','2016-10-13','12:56','14:28',4)
,('MAARMITA','2016-10-17','07:30','09:18',1)
,('MAARMITA','2016-10-17','09:41','10:15',2)
,('MAARMITA','2016-10-17','10:47','13:47',3)
,('MAARMITA','2016-10-17','14:31','15:13',4)
,('MAARMITA','2016-10-17','15:43','17:51',5)
,('MAARMITA','2016-10-17','19:34','21:55',6)
,('MAARMITA','2016-10-20','07:36','09:16',1)
,('MAARMITA','2016-10-20','09:46','10:22',2)
,('MAARMITA','2016-10-20','10:44','11:11',3)
,('MAARMITA','2016-10-20','11:39','12:07',4)
,('MAARMITA','2016-10-20','12:30','13:19',5)
,('MAARMITA','2016-10-27','07:30','07:59',1)
,('MAARMITA','2016-10-27','08:34','10:31',2)
,('MAARMITA','2016-10-27','11:13','12:18',3)
,('MAARMITA','2016-10-27','12:59','14:58',4)
,('MAARMITA','2016-10-27','15:31','16:49',5)
,('MAARMITA','2016-10-31','07:39','09:44',1)
,('MAARMITA','2016-10-31','10:32','12:22',2)
,('MAARMITA','2016-10-31','13:04','14:45',3)
,('MAMOSSAN','2016-10-16','14:25','15:06',1)
,( 'MARAO1','2016-10-03','13:21','13:55',1)
,( 'MARAO1','2016-10-04','08:13','09:11',1)
,( 'MARAO1','2016-10-06','13:10','13:44',1)
,( 'MARAO1','2016-10-14','13:46','15:05',1)
,( 'MARAO1','2016-10-17','17:15','17:54',1)
,( 'MARAO1','2016-10-18','07:30','09:15',1)
,( 'MARAO1','2016-10-18','09:47','10:21',2)
,( 'MARAO1','2016-10-18','10:55','11:58',3)
,( 'MARAO1','2016-10-21','13:28','14:20',1)
,( 'MARAO1','2016-10-24','09:34','10:23',1)
,( 'MARAO1','2016-10-24','11:00','16:48',2)
,( 'MARAO1','2016-10-28','13:07','13:40',1)
,('MIFINKLE','2016-10-06','07:42','09:32',1)
,('MIFINKLE','2016-10-11','07:18','07:53',1)
,('MIFINKLE','2016-10-18','12:32','13:07',1)
,('MIFINKLE','2016-10-18','13:39','14:24',2)
,('MIFINKLE','2016-10-18','14:50','15:25',3)
,('MIMCCOOB','2016-10-03','07:57','08:48',1)
,('MIMCCOOB','2016-10-03','09:13','10:04',2)
,('MIMCCOOB','2016-10-03','10:31','12:55',3)
,('MIMCCOOB','2016-10-03','13:21','14:08',4)
,('MIMCCOOB','2016-10-03','14:31','15:57',5)
,('MIMCCOOB','2016-10-04','07:52','08:59',1)
,('MIMCCOOB','2016-10-04','12:56','13:46',2)
,('MIMCCOOB','2016-10-04','14:14','14:55',3)
,('MIMCCOOB','2016-10-05','07:29','09:12',1)
,('MIMCCOOB','2016-10-05','09:40','10:58',2)
,('MIMCCOOB','2016-10-05','11:31','12:53',3)
,('MIMCCOOB','2016-10-06','07:32','08:22',1)
,('MIMCCOOB','2016-10-06','08:46','09:13',2)
,('MIMCCOOB','2016-10-06','11:57','13:54',3)
,('MIMCCOOB','2016-10-07','11:20','12:09',1)
,('MIMCCOOB','2016-10-11','07:30','08:30',1)
,('MIMCCOOB','2016-10-11','12:48','14:22',2)
,('MIMCCOOB','2016-10-11','14:53','15:44',3)
,('MIMCCOOB','2016-10-12','07:29','08:56',1)
,('MIMCCOOB','2016-10-12','09:23','10:41',2)
,('MIMCCOOB','2016-10-12','11:08','12:38',3)
,('MIMCCOOB','2016-10-13','07:23','08:06',1)
,('MIMCCOOB','2016-10-17','13:58','14:42',1)
,('MIMCCOOB','2016-10-17','15:34','16:36',2)
,('MIMCCOOB','2016-10-18','07:35','08:33',1)
,('MIMCCOOB','2016-10-18','14:31','15:40',2)
,('MIMCCOOB','2016-10-19','07:35','08:32',1)
,('MIMCCOOB','2016-10-19','09:03','09:55',2)
,('MIMCCOOB','2016-10-19','10:35','11:41',3)
,('MIMCCOOB','2016-10-20','08:50','10:00',1)
,('MIMCCOOB','2016-10-20','10:30','11:17',2)
,('MIMCCOOB','2016-10-20','11:41','12:46',3)
,('MIMCCOOB','2016-10-20','13:18','13:53',4)
,('MIMCCOOB','2016-10-24','07:36','08:27',1)
,('MIMCCOOB','2016-10-25','12:55','14:28',1)
,('MIMCCOOB','2016-10-26','07:38','09:37',1)
,('MIMCCOOB','2016-10-26','10:05','11:10',2)
,('MIMCCOOB','2016-10-26','11:19','12:13',3)
,('MIMCCOOB','2016-10-27','07:35','08:45',1)
,('MIMCCOOB','2016-10-31','07:32','08:45',1)
,('NALOPUSH','2016-10-04','07:27','08:55',1)
,('NALOPUSH','2016-10-04','09:28','10:27',2)
,('NALOPUSH','2016-10-04','11:08','11:58',3)
,('NALOPUSH','2016-10-13','07:32','08:11',1)
,('NALOPUSH','2016-10-13','16:52','18:46',2)
,('NALOPUSH','2016-10-14','15:30','16:05',1)
,('NALOPUSH','2016-10-18','07:29','08:28',1)
,('NALOPUSH','2016-10-18','09:12','10:59',2)
,('NALOPUSH','2016-10-20','10:50','11:25',1)
,('NALOPUSH','2016-10-20','12:07','12:53',2)
,('NALOPUSH','2016-10-21','14:25','15:10',1)
,('NALOPUSH','2016-10-27','07:26','08:35',1)
,('NALOPUSH','2016-10-27','09:13','09:52',2)
,('NALOPUSH','2016-10-28','14:08','14:45',1)
,('NALOPUSH','2016-10-28','15:01','15:47',2)
,( 'NIVEGA','2016-10-18','12:53','14:28',1)
,('PAMCCAHI','2016-10-04','12:45','14:22',1)
,('PAMCCAHI','2016-10-04','18:08','18:45',2)
,('PAMCCAHI','2016-10-14','17:10','17:49',1)
,('PAMCCAHI','2016-10-14','18:13','19:23',2)
,('PAMCCAHI','2016-10-28','12:09','12:51',1)
,('PAMCCAHI','2016-10-28','13:12','13:47',2)
,('PRPRADHA','2016-10-28','08:40','09:06',1)
,('PRPRADHA','2016-10-28','09:28','10:03',2)
,('PRPRADHA','2016-10-28','10:36','11:24',3)
,('PRPRADHA','2016-10-28','11:50','12:30',4)
,('PRPRADHA','2016-10-28','13:02','13:59',5)
,('PRPRADHA','2016-10-28','14:29','15:11',6)
,('PRPRADHA','2016-10-28','15:38','16:12',7)
,('PRPRADHA','2016-10-28','17:06','18:02',8)
,('PRPRADHA','2016-10-28','19:53','20:31',9)
,( 'PVENKAT','2016-10-03','07:37','08:43',1)
,( 'PVENKAT','2016-10-06','10:24','11:05',1)
,( 'PVENKAT','2016-10-06','11:46','12:40',2)
,('REWEAVER','2016-10-03','07:50','10:59',1)
,('REWEAVER','2016-10-03','11:04','11:59',2)
,('REWEAVER','2016-10-05','12:56','15:38',1)
,('REWEAVER','2016-10-17','07:51','13:46',1)
,('REWEAVER','2016-10-20','07:54','10:48',1)
,('REWEAVER','2016-10-28','13:09','14:32',1)
,('REWEAVER','2016-10-31','09:24','10:07',1)
,('RIMULROY','2016-10-12','07:42','09:39',1)
,('RIMULROY','2016-10-12','10:25','13:10',2)
,('RIMULROY','2016-10-12','12:50','15:00',3)
,('RIMULROY','2016-10-15','10:06','12:02',1)
,('RIMULROY','2016-10-16','12:09','13:35',1)
,('RIMULROY','2016-10-17','07:43','09:43',1)
,('RIMULROY','2016-10-17','09:41','11:39',2)
,('RIMULROY','2016-10-17','11:24','13:17',3)
,('RIMULROY','2016-10-17','13:09','15:13',4)
,('RIMULROY','2016-10-24','07:37','09:22',1)
,('RIMULROY','2016-10-24','09:14','11:43',2)
,('RIMULROY','2016-10-24','11:33','13:23',3)
,('RIMULROY','2016-10-26','07:30','08:34',1)
,('RIMULROY','2016-10-26','09:10','10:12',2)
,('RIMULROY','2016-10-26','10:47','11:32',3)
,('RIMULROY','2016-10-26','12:06','12:49',4)
,('RIMULROY','2016-10-31','07:43','09:38',1)
,('RIMULROY','2016-10-31','09:47','11:41',2)
,('RIMULROY','2016-10-31','11:36','13:48',3)
,('RIMULROY','2016-10-31','13:29','15:07',4)
,('ROZUNENS','2016-10-20','07:27','08:01',1)
,('ROZUNENS','2016-10-20','08:37','09:17',2)
,( 'RUSHU','2016-10-05','07:48','08:01',1)
,( 'RUSHU','2016-10-05','08:08','08:19',2)
,( 'RUSHU','2016-10-05','08:50','09:29',3)
,( 'RUSHU','2016-10-05','09:56','10:53',4)
,( 'RUSHU','2016-10-05','11:14','11:31',5)
,( 'RUSHU','2016-10-14','13:03','14:01',1)
,( 'RUSHU','2016-10-19','07:30','08:21',1)
,( 'RUSHU','2016-10-19','08:39','09:02',2)
,( 'RUSHU','2016-10-26','07:22','07:58',1)
,( 'RUSHU','2016-10-26','08:17','08:51',2)
,('RYFRANKE1','2016-10-19','07:28','09:31',1)
,('RYFRANKE1','2016-10-19','10:09','11:14',2)
,('RYFRANKE1','2016-10-26','07:26','08:08',1)
,('RYFRANKE1','2016-10-26','08:32','09:12',2)
,('RYFRANKE1','2016-10-26','09:35','10:04',3)
,('RYFRANKE1','2016-10-28','08:41','09:23',1)
,('RYFRANKE1','2016-10-28','09:41','10:21',2)
,('RYFRANKE1','2016-10-28','10:39','11:14',3)
,('RYFRANKE1','2016-10-29','08:28','09:15',1)
,('RYFRANKE1','2016-10-31','13:02','13:58',1)
,('RYFRANKE1','2016-10-31','14:33','15:17',2)
,('RYFRANKE1','2016-10-31','16:01','16:32',3)
,('SACARTER1','2016-10-06','23:57','01:08',1)
,('SACARTER1','2016-10-10','11:25','13:00',1)
,('SACARTER1','2016-10-10','18:45','20:11',2)
,('SACARTER1','2016-10-23','18:07','19:34',1)
,('SADONEGA','2016-10-17','07:29','08:08',1)
,('SADONEGA','2016-10-27','11:00','11:46',1)
,('SCMANDEL','2016-10-04','13:10','15:12',1)
,('SCMANDEL','2016-10-05','07:39','09:07',1)
,('SCMANDEL','2016-10-05','09:49','10:42',2)
,('SCMANDEL','2016-10-05','11:29','13:46',3)
,('SCMANDEL','2016-10-10','20:53','21:09',1)
,('SCMANDEL','2016-10-12','07:44','09:42',1)
,('SCMANDEL','2016-10-12','10:31','11:30',2)
,('SCMANDEL','2016-10-14','07:30','08:34',1)
,('SCMANDEL','2016-10-14','09:18','10:43',2)
,('SCMANDEL','2016-10-14','11:35','12:54',3)
,('SCMANDEL','2016-10-14','13:40','15:18',4)
,('SCMANDEL','2016-10-19','07:40','09:32',1)
,('SCMANDEL','2016-10-21','08:37','10:06',1)
,('SCMANDEL','2016-10-23','08:40','10:54',1)
,('SCMANDEL','2016-10-26','07:39','08:46',1)
,('SCMANDEL','2016-10-26','09:30','12:30',2)
,('SCMANDEL','2016-10-26','13:30','14:09',3)
,('SCMANDEL','2016-10-26','15:12','17:03',4)
,('SCMANDEL','2016-10-28','08:36','09:06',1)
,('SCMANDEL','2016-10-28','09:49','11:13',2)
,('SCMANDEL','2016-10-28','11:53','13:04',3)
,('SCMANDEL','2016-10-28','14:12','16:00',4)
,('SOHANJAN','2016-10-28','14:20','15:13',1)
,('STMALONE','2016-10-03','17:55','19:56',1)
,('STMALONE','2016-10-04','16:06','18:34',1)
,('STMALONE','2016-10-06','14:25','17:19',1)
,('STMALONE','2016-10-07','08:48','14:02',1)
,('STMALONE','2016-10-08','11:00','14:08',1)
,('STMALONE','2016-10-11','11:25','12:18',1)
,('STMALONE','2016-10-11','12:53','13:48',2)
,('STMALONE','2016-10-13','14:59','19:24',1)
,('STMALONE','2016-10-19','10:26','13:06',1)
,('STMALONE','2016-10-21','08:45','14:17',1)
,('STMALONE','2016-10-27','13:03','15:27',1)
,('STMALONE','2016-10-29','13:05','16:29',1)
,('STMALONE','2016-10-30','14:22','15:14',1)
,('STPIDGEO','2016-10-14','07:29','09:02',1)
,('STPIDGEO','2016-10-14','09:31','10:05',2)
,('STPIDGEO','2016-10-28','08:24','09:25',1)
,('STPIDGEO','2016-10-28','09:50','10:27',2)
,('STPIDGEO','2016-10-28','10:59','11:49',3)
,('STPIDGEO','2016-10-28','12:05','12:30',4)
,( 'TIHRON','2016-10-30','23:40','00:30',1)
,('TUWATERS','2016-10-05','12:16','13:40',1)
,('TUWATERS','2016-10-05','14:12','15:37',2)
,('TUWATERS','2016-10-05','15:57','17:30',3)
,('TUWATERS','2016-10-06','11:32','12:17',1)
,('TUWATERS','2016-10-06','12:55','13:51',2)
,('TUWATERS','2016-10-13','07:37','11:22',1)
,('TUWATERS','2016-10-13','12:27','14:45',2)
,('TUWATERS','2016-10-24','07:27','08:54',1)
,('TUWATERS','2016-10-24','09:30','10:12',2)
,('VAATANAS','2016-10-04','09:32','10:29',1)
,('VAATANAS','2016-10-04','11:00','12:03',2)
,('VAATANAS','2016-10-11','08:54','09:47',1)
,('VAATANAS','2016-10-18','08:57','09:28',1)
,('VAATANAS','2016-10-18','09:58','10:31',2)
,('VAATANAS','2016-10-18','11:01','11:55',3)
,('VAATANAS','2016-10-18','12:15','13:47',4)
,('VAATANAS','2016-10-18','16:44','18:55',5)
,('VAATANAS','2016-10-25','07:27','08:24',1)
,('VAATANAS','2016-10-25','09:25','10:35',2)
,('VAATANAS','2016-10-25','11:11','12:09',3)
,('VITEWARI','2016-10-04','07:22','07:45',1)
,('VITEWARI','2016-10-04','07:50','08:14',2)
,('VITEWARI','2016-10-04','08:18','08:45',3)
,('VITEWARI','2016-10-04','08:50','09:17',4)
,('VITEWARI','2016-10-04','09:13','09:35',5)
,('VITEWARI','2016-10-04','09:41','10:05',6)
,('VITEWARI','2016-10-04','10:09','10:34',7)
,('VITEWARI','2016-10-04','10:40','11:00',8)
,('VITEWARI','2016-10-04','11:04','11:31',9)
,('VITEWARI','2016-10-04','11:35','12:00',10)
,('VITEWARI','2016-10-04','12:08','12:21',11)
,('VITEWARI','2016-10-04','12:27','12:36',12)
,('VITEWARI','2016-10-11','07:22','07:45',1)
,('VITEWARI','2016-10-11','07:51','08:12',2)
,('VITEWARI','2016-10-11','08:18','08:43',3)
,('VITEWARI','2016-10-11','08:50','09:15',4)
,('VITEWARI','2016-10-11','09:20','09:44',5)
,('VITEWARI','2016-10-11','09:50','10:16',6)
,('VITEWARI','2016-10-11','10:23','10:54',7)
,('VITEWARI','2016-10-11','11:05','11:12',8)
,('VITEWARI','2016-10-18','07:23','07:45',1)
,('VITEWARI','2016-10-18','07:50','08:15',2)
,('VITEWARI','2016-10-18','08:20','08:47',3)
,('VITEWARI','2016-10-18','08:52','09:14',4)
,('VITEWARI','2016-10-18','09:20','09:47',5)
,('VITEWARI','2016-10-18','09:55','10:18',6)
,('VITEWARI','2016-10-18','10:23','10:49',7)
,('VITEWARI','2016-10-18','10:54','11:17',8)
,('VITEWARI','2016-10-18','11:21','11:28',9)
,('VITEWARI','2016-10-18','11:31','11:40',10)
,('VITEWARI','2016-10-25','07:24','07:44',1)
,('VITEWARI','2016-10-25','07:50','08:13',2)
,('VITEWARI','2016-10-25','08:20','08:44',3)
,('VITEWARI','2016-10-25','08:51','09:15',4)
,('VITEWARI','2016-10-25','09:22','09:44',5)
,('VITEWARI','2016-10-25','09:50','10:14',6)
,('VITEWARI','2016-10-25','10:19','10:44',7)
,('VITEWARI','2016-10-25','10:48','10:57',8)
,('VITEWARI','2016-10-25','11:02','11:10',9)
,( 'WAWAKIM','2016-10-26','01:27','12:59',1)
,( 'WESUNG','2016-10-13','15:37','16:19',1);
-- Add an index to support the self joining
CREATE UNIQUE NONCLUSTERED INDEX UNQNCLIDX_#TEST_UNVUSERID_OPENDATE_SEQNUM_INCL_TIMEINROOM_TIMEOUTROOM ON #Test (UnvUserID ASC, OperDate ASC, SeqNum ASC) INCLUDE (TimeInRoom,TimeOutRoom);
;WITH BASE_DATA AS
(
SELECT
TT.UnvUserID
,TT.OperDate
,CONVERT(TIME(0),TT.TimeInRoom,0) AS TimeInRoom
,CONVERT(TIME(0),TT.TimeOutRoom,0) AS TimeOutRoom
,TT.SeqNum
FROM #Test TT
)
SELECT
GDCURR.UnvUserID
,GDCURR.OperDate
,GDCURR.SeqNum
,GDCURR.TimeInRoom
,GDCURR.TimeOutRoom
,ISNULL(DATEDIFF(MINUTE,GDPREV.TimeOutRoom,GDCURR.TimeInRoom),0) AS DURATION
FROM BASE_DATA GDCURR
LEFT OUTER JOIN BASE_DATA GDPREV
ON GDCURR.UnvUserID = GDPREV.UnvUserID
AND GDCURR.OperDate = GDPREV.OperDate
AND GDCURR.SeqNum = GDPREV.SeqNum + 1
;
Output
UnvUserID OperDate SeqNum TimeInRoom TimeOutRoom DURATION
------------------------------ ----------------------- ----------- ---------------- ---------------- -----------
ANTIWARY 2016-10-12 00:00:00.000 1 12:59:00 14:13:00 0
ANTIWARY 2016-10-12 00:00:00.000 2 14:55:00 16:58:00 42
ANTIWARY 2016-10-13 00:00:00.000 1 09:14:00 10:22:00 0
ANTIWARY 2016-10-24 00:00:00.000 1 10:57:00 12:20:00 0
ANTIWARY 2016-10-24 00:00:00.000 2 12:57:00 14:38:00 37
ANTIWARY 2016-10-28 00:00:00.000 1 11:21:00 12:28:00 0
ANTIWARY 2016-10-28 00:00:00.000 2 17:25:00 19:15:00 297
AQSIDDIQ 2016-10-05 00:00:00.000 1 07:37:00 10:49:00 0
AQSIDDIQ 2016-10-05 00:00:00.000 2 11:33:00 13:38:00 44
AQSIDDIQ 2016-10-05 00:00:00.000 3 14:13:00 16:59:00 35
AQSIDDIQ 2016-10-05 00:00:00.000 4 18:02:00 21:15:00 63
AQSIDDIQ 2016-10-05 00:00:00.000 5 22:49:00 02:40:00 94
AQSIDDIQ 2016-10-06 00:00:00.000 1 13:41:00 15:08:00 0
AQSIDDIQ 2016-10-06 00:00:00.000 2 17:20:00 18:25:00 132
AQSIDDIQ 2016-10-07 00:00:00.000 1 10:39:00 14:38:00 0
AQSIDDIQ 2016-10-07 00:00:00.000 2 16:21:00 18:36:00 103
AQSIDDIQ 2016-10-07 00:00:00.000 3 19:10:00 21:07:00 34
AQSIDDIQ 2016-10-12 00:00:00.000 1 07:34:00 11:28:00 0
AQSIDDIQ 2016-10-12 00:00:00.000 2 12:24:00 15:51:00 56
AQSIDDIQ 2016-10-12 00:00:00.000 3 16:46:00 17:30:00 55
AQSIDDIQ 2016-10-12 00:00:00.000 4 18:07:00 18:41:00 37
AQSIDDIQ 2016-10-12 00:00:00.000 5 20:06:00 20:56:00 85
AQSIDDIQ 2016-10-13 00:00:00.000 1 20:30:00 00:25:00 0
AQSIDDIQ 2016-10-19 00:00:00.000 1 07:35:00 09:44:00 0
AQSIDDIQ 2016-10-19 00:00:00.000 2 10:26:00 12:18:00 42
AQSIDDIQ 2016-10-19 00:00:00.000 3 12:45:00 14:21:00 27
AQSIDDIQ 2016-10-19 00:00:00.000 4 14:46:00 16:28:00 25
AQSIDDIQ 2016-10-20 00:00:00.000 1 13:45:00 15:40:00 0
AQSIDDIQ 2016-10-20 00:00:00.000 2 16:49:00 19:28:00 69
AQSIDDIQ 2016-10-26 00:00:00.000 1 07:45:00 09:12:00 0
AQSIDDIQ 2016-10-27 00:00:00.000 1 13:28:00 14:52:00 0
AQSIDDIQ 2016-10-28 00:00:00.000 1 18:46:00 00:07:00 0
AQSIDDIQ 2016-10-28 00:00:00.000 2 22:33:00 23:05:00 1346
BAROSENB 2016-10-11 00:00:00.000 1 12:52:00 14:19:00 0
BAROSENB 2016-10-25 00:00:00.000 1 12:09:00 13:37:00 0
DADRINKW 2016-10-31 00:00:00.000 1 10:00:00 10:49:00 0
DAHYATT 2016-10-14 00:00:00.000 1 11:52:00 13:21:00 0
DAHYATT 2016-10-25 00:00:00.000 1 16:17:00 16:55:00 0
DAKASHME 2016-10-04 00:00:00.000 1 15:30:00 17:45:00 0
DAKASHME 2016-10-06 00:00:00.000 1 14:33:00 15:44:00 0
DAKASHME 2016-10-07 00:00:00.000 1 14:50:00 16:24:00 0
DAKASHME 2016-10-19 00:00:00.000 1 16:20:00 17:32:00 0
DAKASHME 2016-10-20 00:00:00.000 1 06:15:00 07:33:00 0
DAKASHME 2016-10-21 00:00:00.000 1 06:14:00 12:00:00 0
DAKASHME 2016-10-21 00:00:00.000 2 21:25:00 22:33:00 565
DASIPALA 2016-10-06 00:00:00.000 1 07:35:00 09:09:00 0
DASIPALA 2016-10-06 00:00:00.000 2 09:34:00 10:40:00 25
DASIPALA 2016-10-06 00:00:00.000 3 11:21:00 12:22:00 41
DASIPALA 2016-10-11 00:00:00.000 1 07:34:00 10:08:00 0
DASIPALA 2016-10-11 00:00:00.000 2 10:52:00 13:38:00 44
DESESHAD 2016-10-07 00:00:00.000 1 08:32:00 09:05:00 0
DESESHAD 2016-10-07 00:00:00.000 2 09:32:00 10:21:00 27
DESESHAD 2016-10-12 00:00:00.000 1 13:30:00 18:54:00 0
DESESHAD 2016-10-14 00:00:00.000 1 07:33:00 08:47:00 0
DESESHAD 2016-10-19 00:00:00.000 1 12:17:00 16:14:00 0
DESESHAD 2016-10-21 00:00:00.000 1 08:37:00 09:31:00 0
DESESHAD 2016-10-21 00:00:00.000 2 09:58:00 10:41:00 27
DESESHAD 2016-10-21 00:00:00.000 3 11:47:00 14:21:00 66
DESESHAD 2016-10-26 00:00:00.000 1 11:13:00 12:16:00 0
DESESHAD 2016-10-28 00:00:00.000 1 08:34:00 09:44:00 0
DESESHAD 2016-10-28 00:00:00.000 2 10:31:00 11:13:00 47
DESESHAD 2016-10-28 00:00:00.000 3 12:01:00 12:25:00 48
DESESHAD 2016-10-28 00:00:00.000 4 12:40:00 13:10:00 15
DESESHAD 2016-10-28 00:00:00.000 5 13:54:00 19:13:00 44
DOOBRIEN 2016-10-06 00:00:00.000 1 07:27:00 07:42:00 0
DOOBRIEN 2016-10-06 00:00:00.000 2 08:01:00 08:16:00 19
DOOBRIEN 2016-10-06 00:00:00.000 3 08:39:00 09:19:00 23
DOOBRIEN 2016-10-06 00:00:00.000 4 09:50:00 10:38:00 31
DOOBRIEN 2016-10-17 00:00:00.000 1 14:32:00 14:52:00 0
GEALMACA 2016-10-01 00:00:00.000 1 09:02:00 09:40:00 0
GEALMACA 2016-10-04 00:00:00.000 1 07:38:00 09:31:00 0
GEALMACA 2016-10-04 00:00:00.000 2 10:00:00 10:23:00 29
GEALMACA 2016-10-04 00:00:00.000 3 11:44:00 13:23:00 81
GEALMACA 2016-10-04 00:00:00.000 4 14:09:00 14:48:00 46
GEALMACA 2016-10-04 00:00:00.000 5 14:49:00 15:26:00 1
GEALMACA 2016-10-04 00:00:00.000 6 15:36:00 16:58:00 10
GEALMACA 2016-10-04 00:00:00.000 7 17:11:00 18:33:00 13
GEALMACA 2016-10-11 00:00:00.000 1 08:10:00 09:58:00 0
GEALMACA 2016-10-11 00:00:00.000 2 10:36:00 11:48:00 38
GEALMACA 2016-10-11 00:00:00.000 3 11:52:00 13:34:00 4
GEALMACA 2016-10-11 00:00:00.000 4 14:08:00 15:07:00 34
GEALMACA 2016-10-11 00:00:00.000 5 15:12:00 16:35:00 5
GEALMACA 2016-10-11 00:00:00.000 6 16:34:00 17:19:00 -1
GEALMACA 2016-10-18 00:00:00.000 1 07:38:00 08:54:00 0
GEALMACA 2016-10-18 00:00:00.000 2 09:17:00 10:50:00 23
GEALMACA 2016-10-18 00:00:00.000 3 10:52:00 12:40:00 2
GEALMACA 2016-10-18 00:00:00.000 4 12:34:00 13:11:00 -6
GEALMACA 2016-10-18 00:00:00.000 5 13:40:00 14:43:00 29
GEALMACA 2016-10-18 00:00:00.000 6 14:49:00 15:25:00 6
GEALMACA 2016-10-18 00:00:00.000 7 15:44:00 17:07:00 19
GEALMACA 2016-10-18 00:00:00.000 8 17:11:00 18:07:00 4
GEALMACA 2016-10-25 00:00:00.000 1 07:29:00 09:11:00 0
GEALMACA 2016-10-25 00:00:00.000 2 09:06:00 10:32:00 -5
GEALMACA 2016-10-25 00:00:00.000 3 11:04:00 12:18:00 32
GEALMACA 2016-10-25 00:00:00.000 4 12:25:00 14:13:00 7
GEALMACA 2016-10-25 00:00:00.000 5 14:04:00 14:55:00 -9
GEALMACA 2016-10-25 00:00:00.000 6 15:07:00 16:02:00 12
GEALMACA 2016-10-25 00:00:00.000 7 16:05:00 17:55:00 3
GEALMACA 2016-10-25 00:00:00.000 8 17:45:00 18:15:00 -10
GEALMACA 2016-10-25 00:00:00.000 9 18:29:00 18:42:00 14
HDSNYDER 2016-10-04 00:00:00.000 1 07:39:00 09:22:00 0
HDSNYDER 2016-10-04 00:00:00.000 2 10:06:00 10:22:00 44
HDSNYDER 2016-10-04 00:00:00.000 3 10:50:00 11:08:00 28
HDSNYDER 2016-10-04 00:00:00.000 4 11:44:00 12:00:00 36
HDSNYDER 2016-10-11 00:00:00.000 1 07:32:00 07:45:00 0
HDSNYDER 2016-10-11 00:00:00.000 2 08:25:00 08:39:00 40
HDSNYDER 2016-10-11 00:00:00.000 3 09:08:00 09:35:00 29
HYHUR 2016-10-07 00:00:00.000 1 08:49:00 13:05:00 0
HYHUR 2016-10-07 00:00:00.000 2 13:27:00 17:23:00 22
HYHUR 2016-10-21 00:00:00.000 1 08:51:00 13:27:00 0
JADHINGR1 2016-10-21 00:00:00.000 1 08:44:00 10:45:00 0
JAFITZGE 2016-10-05 00:00:00.000 1 07:32:00 08:32:00 0
JAFITZGE 2016-10-05 00:00:00.000 2 08:52:00 09:57:00 20
JAFITZGE 2016-10-05 00:00:00.000 3 10:22:00 11:15:00 25
JAFITZGE 2016-10-13 00:00:00.000 1 13:00:00 14:03:00 0
JAFITZGE 2016-10-14 00:00:00.000 1 10:00:00 10:40:00 0
JAFITZGE 2016-10-14 00:00:00.000 2 11:01:00 11:44:00 21
JAFITZGE 2016-10-14 00:00:00.000 3 12:11:00 12:57:00 27
JAFITZGE 2016-10-14 00:00:00.000 4 13:18:00 14:06:00 21
JAFITZGE 2016-10-14 00:00:00.000 5 14:26:00 15:09:00 20
JAFITZGE 2016-10-17 00:00:00.000 1 13:14:00 14:00:00 0
JAFITZGE 2016-10-20 00:00:00.000 1 23:10:00 00:29:00 0
JAFITZGE 2016-10-27 00:00:00.000 1 13:09:00 13:52:00 0
JAFITZGE 2016-10-27 00:00:00.000 2 14:17:00 15:21:00 25
JEGASSMA 2016-10-05 00:00:00.000 1 20:18:00 21:02:00 0
JEGASSMA 2016-10-05 00:00:00.000 2 21:50:00 22:20:00 48
JEGASSMA 2016-10-05 00:00:00.000 3 22:55:00 23:57:00 35
JEGASSMA 2016-10-06 00:00:00.000 1 07:34:00 09:49:00 0
JEGASSMA 2016-10-06 00:00:00.000 2 10:21:00 11:44:00 32
JEGASSMA 2016-10-06 00:00:00.000 3 12:10:00 13:43:00 26
JEGASSMA 2016-10-06 00:00:00.000 4 14:16:00 14:57:00 33
JEGASSMA 2016-10-13 00:00:00.000 1 07:27:00 08:06:00 0
JEGASSMA 2016-10-13 00:00:00.000 2 08:35:00 09:44:00 29
JEGASSMA 2016-10-13 00:00:00.000 3 10:11:00 11:01:00 27
JEGASSMA 2016-10-13 00:00:00.000 4 12:02:00 14:04:00 61
JEGASSMA 2016-10-14 00:00:00.000 1 12:34:00 13:18:00 0
JEGASSMA 2016-10-20 00:00:00.000 1 07:33:00 10:22:00 0
JEGASSMA 2016-10-20 00:00:00.000 2 11:04:00 13:20:00 42
JEGASSMA 2016-10-20 00:00:00.000 3 13:46:00 14:37:00 26
JEGASSMA 2016-10-20 00:00:00.000 4 14:54:00 15:31:00 17
JEGASSMA 2016-10-27 00:00:00.000 1 07:43:00 08:34:00 0
JEGASSMA 2016-10-27 00:00:00.000 2 09:10:00 10:26:00 36
JEGASSMA 2016-10-27 00:00:00.000 3 10:57:00 11:44:00 31
JEGASSMA 2016-10-27 00:00:00.000 4 12:23:00 13:23:00 39
JEGASSMA 2016-10-27 00:00:00.000 5 14:02:00 15:47:00 39
JEMACVIC 2016-10-03 00:00:00.000 1 07:53:00 09:40:00 0
JEMACVIC 2016-10-03 00:00:00.000 2 10:04:00 10:57:00 24
JEMACVIC 2016-10-03 00:00:00.000 3 11:28:00 13:10:00 31
JEMACVIC 2016-10-03 00:00:00.000 4 13:40:00 14:30:00 30
JEMACVIC 2016-10-04 00:00:00.000 1 10:58:00 11:43:00 0
JEMACVIC 2016-10-04 00:00:00.000 2 12:05:00 13:22:00 22
JEMACVIC 2016-10-05 00:00:00.000 1 13:14:00 14:02:00 0
JEMACVIC 2016-10-05 00:00:00.000 2 14:43:00 16:03:00 41
JEMACVIC 2016-10-06 00:00:00.000 1 07:16:00 08:29:00 0
JEMACVIC 2016-10-06 00:00:00.000 2 08:54:00 10:54:00 25
JEMACVIC 2016-10-06 00:00:00.000 3 12:47:00 14:01:00 113
JEMACVIC 2016-10-07 00:00:00.000 1 08:28:00 09:13:00 0
JEMACVIC 2016-10-07 00:00:00.000 2 09:44:00 10:44:00 31
JEMACVIC 2016-10-13 00:00:00.000 1 08:58:00 09:46:00 0
JEMACVIC 2016-10-13 00:00:00.000 2 10:05:00 11:10:00 19
JEMACVIC 2016-10-13 00:00:00.000 3 11:52:00 13:00:00 42
JEMACVIC 2016-10-13 00:00:00.000 4 13:25:00 16:02:00 25
JEMACVIC 2016-10-14 00:00:00.000 1 09:07:00 11:04:00 0
JEMACVIC 2016-10-14 00:00:00.000 2 11:31:00 13:18:00 27
JEMACVIC 2016-10-17 00:00:00.000 1 08:03:00 10:25:00 0
JEMACVIC 2016-10-17 00:00:00.000 2 10:37:00 11:42:00 12
JEMACVIC 2016-10-17 00:00:00.000 3 11:59:00 13:23:00 17
JEMACVIC 2016-10-26 00:00:00.000 1 13:11:00 14:31:00 0
JEMACVIC 2016-10-26 00:00:00.000 2 14:48:00 16:56:00 17
JEMACVIC 2016-10-27 00:00:00.000 1 07:28:00 08:41:00 0
JEMACVIC 2016-10-27 00:00:00.000 2 09:05:00 09:56:00 24
JEMACVIC 2016-10-27 00:00:00.000 3 10:27:00 11:59:00 31
JEMACVIC 2016-10-27 00:00:00.000 4 13:27:00 15:27:00 88
JEMACVIC 2016-10-27 00:00:00.000 5 15:50:00 16:31:00 23
JEMACVIC 2016-10-28 00:00:00.000 1 08:13:00 09:51:00 0
JEMACVIC 2016-10-28 00:00:00.000 2 10:14:00 10:41:00 23
JEMACVIC 2016-10-31 00:00:00.000 1 07:15:00 08:20:00 0
JEMACVIC 2016-10-31 00:00:00.000 2 08:39:00 09:21:00 19
JEMACVIC 2016-10-31 00:00:00.000 3 11:32:00 14:10:00 131
JEMACVIC 2016-10-31 00:00:00.000 4 14:42:00 16:20:00 32
JEMACVIC 2016-10-31 00:00:00.000 5 16:52:00 19:06:00 32
JOCOYNE 2016-10-20 00:00:00.000 1 08:10:00 09:00:00 0
JOCOYNE 2016-10-20 00:00:00.000 2 09:15:00 09:56:00 15
KALUND 2016-10-04 00:00:00.000 1 12:55:00 13:39:00 0
KALUND 2016-10-04 00:00:00.000 2 13:56:00 14:32:00 17
KALUND 2016-10-04 00:00:00.000 3 14:43:00 15:18:00 11
KALUND 2016-10-11 00:00:00.000 1 12:41:00 13:22:00 0
KALUND 2016-10-11 00:00:00.000 2 13:38:00 14:30:00 16
KALUND 2016-10-11 00:00:00.000 3 14:53:00 15:39:00 23
KALUND 2016-10-18 00:00:00.000 1 13:00:00 13:40:00 0
KALUND 2016-10-25 00:00:00.000 1 12:44:00 13:17:00 0
KALUND 2016-10-25 00:00:00.000 2 13:32:00 14:23:00 15
KEMERLIN 2016-10-31 00:00:00.000 1 08:33:00 09:03:00 0
KEMERLIN 2016-10-31 00:00:00.000 2 09:29:00 10:02:00 26
KEMERLIN 2016-10-31 00:00:00.000 3 11:03:00 11:32:00 61
KEMERLIN 2016-10-31 00:00:00.000 4 11:57:00 12:29:00 25
KEPAHUJA 2016-10-03 00:00:00.000 1 12:05:00 20:22:00 0
KEPAHUJA 2016-10-07 00:00:00.000 1 11:44:00 13:49:00 0
KEPAHUJA 2016-10-08 00:00:00.000 1 16:56:00 18:39:00 0
KEPAHUJA 2016-10-14 00:00:00.000 1 08:27:00 10:30:00 0
KEPAHUJA 2016-10-17 00:00:00.000 1 14:37:00 15:14:00 0
KEPAHUJA 2016-10-20 00:00:00.000 1 13:22:00 16:02:00 0
KEPAHUJA 2016-10-20 00:00:00.000 2 18:08:00 20:01:00 126
KEPAHUJA 2016-10-24 00:00:00.000 1 08:42:00 22:27:00 0
KEPAHUJA 2016-10-25 00:00:00.000 1 07:57:00 10:17:00 0
KEPAHUJA 2016-10-27 00:00:00.000 1 10:25:00 11:44:00 0
KEPAHUJA 2016-10-31 00:00:00.000 1 10:58:00 13:05:00 0
KRRATLIF 2016-10-13 00:00:00.000 1 07:38:00 09:54:00 0
KRRATLIF 2016-10-13 00:00:00.000 2 10:46:00 13:19:00 52
KRRATLIF 2016-10-13 00:00:00.000 3 14:00:00 14:46:00 41
KRRATLIF 2016-10-13 00:00:00.000 4 15:28:00 16:32:00 42
KRRATLIF 2016-10-27 00:00:00.000 1 07:30:00 10:20:00 0
KRRATLIF 2016-10-31 00:00:00.000 1 07:33:00 08:11:00 0
LABROWN1 2016-10-14 00:00:00.000 1 14:03:00 15:14:00 0
LABROWN1 2016-10-25 00:00:00.000 1 07:28:00 08:14:00 0
LABROWN1 2016-10-25 00:00:00.000 2 08:49:00 09:48:00 35
LEGARRET 2016-10-14 00:00:00.000 1 07:30:00 10:09:00 0
LEGARRET 2016-10-14 00:00:00.000 2 11:01:00 14:01:00 52
LEGARRET 2016-10-21 00:00:00.000 1 08:37:00 11:20:00 0
LEGARRET 2016-10-21 00:00:00.000 2 12:01:00 14:42:00 41
LEGARRET 2016-10-21 00:00:00.000 3 15:12:00 17:34:00 30
MAARMITA 2016-10-03 00:00:00.000 1 07:23:00 08:17:00 0
MAARMITA 2016-10-03 00:00:00.000 2 08:56:00 10:52:00 39
MAARMITA 2016-10-03 00:00:00.000 3 11:53:00 13:07:00 61
MAARMITA 2016-10-03 00:00:00.000 4 14:02:00 16:05:00 55
MAARMITA 2016-10-03 00:00:00.000 5 16:27:00 17:40:00 22
MAARMITA 2016-10-04 00:00:00.000 1 18:50:00 20:10:00 0
MAARMITA 2016-10-13 00:00:00.000 1 07:33:00 09:23:00 0
MAARMITA 2016-10-13 00:00:00.000 2 09:57:00 11:29:00 34
MAARMITA 2016-10-13 00:00:00.000 3 11:56:00 12:23:00 27
MAARMITA 2016-10-13 00:00:00.000 4 12:56:00 14:28:00 33
MAARMITA 2016-10-17 00:00:00.000 1 07:30:00 09:18:00 0
MAARMITA 2016-10-17 00:00:00.000 2 09:41:00 10:15:00 23
MAARMITA 2016-10-17 00:00:00.000 3 10:47:00 13:47:00 32
MAARMITA 2016-10-17 00:00:00.000 4 14:31:00 15:13:00 44
MAARMITA 2016-10-17 00:00:00.000 5 15:43:00 17:51:00 30
MAARMITA 2016-10-17 00:00:00.000 6 19:34:00 21:55:00 103
MAARMITA 2016-10-20 00:00:00.000 1 07:36:00 09:16:00 0
MAARMITA 2016-10-20 00:00:00.000 2 09:46:00 10:22:00 30
MAARMITA 2016-10-20 00:00:00.000 3 10:44:00 11:11:00 22
MAARMITA 2016-10-20 00:00:00.000 4 11:39:00 12:07:00 28
MAARMITA 2016-10-20 00:00:00.000 5 12:30:00 13:19:00 23
MAARMITA 2016-10-27 00:00:00.000 1 07:30:00 07:59:00 0
MAARMITA 2016-10-27 00:00:00.000 2 08:34:00 10:31:00 35
MAARMITA 2016-10-27 00:00:00.000 3 11:13:00 12:18:00 42
MAARMITA 2016-10-27 00:00:00.000 4 12:59:00 14:58:00 41
MAARMITA 2016-10-27 00:00:00.000 5 15:31:00 16:49:00 33
MAARMITA 2016-10-31 00:00:00.000 1 07:39:00 09:44:00 0
MAARMITA 2016-10-31 00:00:00.000 2 10:32:00 12:22:00 48
MAARMITA 2016-10-31 00:00:00.000 3 13:04:00 14:45:00 42
MAMOSSAN 2016-10-16 00:00:00.000 1 14:25:00 15:06:00 0
MARAO1 2016-10-03 00:00:00.000 1 13:21:00 13:55:00 0
MARAO1 2016-10-04 00:00:00.000 1 08:13:00 09:11:00 0
MARAO1 2016-10-06 00:00:00.000 1 13:10:00 13:44:00 0
MARAO1 2016-10-14 00:00:00.000 1 13:46:00 15:05:00 0
MARAO1 2016-10-17 00:00:00.000 1 17:15:00 17:54:00 0
MARAO1 2016-10-18 00:00:00.000 1 07:30:00 09:15:00 0
MARAO1 2016-10-18 00:00:00.000 2 09:47:00 10:21:00 32
MARAO1 2016-10-18 00:00:00.000 3 10:55:00 11:58:00 34
MARAO1 2016-10-21 00:00:00.000 1 13:28:00 14:20:00 0
MARAO1 2016-10-24 00:00:00.000 1 09:34:00 10:23:00 0
MARAO1 2016-10-24 00:00:00.000 2 11:00:00 16:48:00 37
MARAO1 2016-10-28 00:00:00.000 1 13:07:00 13:40:00 0
MIFINKLE 2016-10-06 00:00:00.000 1 07:42:00 09:32:00 0
MIFINKLE 2016-10-11 00:00:00.000 1 07:18:00 07:53:00 0
MIFINKLE 2016-10-18 00:00:00.000 1 12:32:00 13:07:00 0
MIFINKLE 2016-10-18 00:00:00.000 2 13:39:00 14:24:00 32
MIFINKLE 2016-10-18 00:00:00.000 3 14:50:00 15:25:00 26
MIMCCOOB 2016-10-03 00:00:00.000 1 07:57:00 08:48:00 0
MIMCCOOB 2016-10-03 00:00:00.000 2 09:13:00 10:04:00 25
MIMCCOOB 2016-10-03 00:00:00.000 3 10:31:00 12:55:00 27
MIMCCOOB 2016-10-03 00:00:00.000 4 13:21:00 14:08:00 26
MIMCCOOB 2016-10-03 00:00:00.000 5 14:31:00 15:57:00 23
MIMCCOOB 2016-10-04 00:00:00.000 1 07:52:00 08:59:00 0
MIMCCOOB 2016-10-04 00:00:00.000 2 12:56:00 13:46:00 237
MIMCCOOB 2016-10-04 00:00:00.000 3 14:14:00 14:55:00 28
MIMCCOOB 2016-10-05 00:00:00.000 1 07:29:00 09:12:00 0
MIMCCOOB 2016-10-05 00:00:00.000 2 09:40:00 10:58:00 28
MIMCCOOB 2016-10-05 00:00:00.000 3 11:31:00 12:53:00 33
MIMCCOOB 2016-10-06 00:00:00.000 1 07:32:00 08:22:00 0
MIMCCOOB 2016-10-06 00:00:00.000 2 08:46:00 09:13:00 24
MIMCCOOB 2016-10-06 00:00:00.000 3 11:57:00 13:54:00 164
MIMCCOOB 2016-10-07 00:00:00.000 1 11:20:00 12:09:00 0
MIMCCOOB 2016-10-11 00:00:00.000 1 07:30:00 08:30:00 0
MIMCCOOB 2016-10-11 00:00:00.000 2 12:48:00 14:22:00 258
MIMCCOOB 2016-10-11 00:00:00.000 3 14:53:00 15:44:00 31
MIMCCOOB 2016-10-12 00:00:00.000 1 07:29:00 08:56:00 0
MIMCCOOB 2016-10-12 00:00:00.000 2 09:23:00 10:41:00 27
MIMCCOOB 2016-10-12 00:00:00.000 3 11:08:00 12:38:00 27
MIMCCOOB 2016-10-13 00:00:00.000 1 07:23:00 08:06:00 0
MIMCCOOB 2016-10-17 00:00:00.000 1 13:58:00 14:42:00 0
MIMCCOOB 2016-10-17 00:00:00.000 2 15:34:00 16:36:00 52
MIMCCOOB 2016-10-18 00:00:00.000 1 07:35:00 08:33:00 0
MIMCCOOB 2016-10-18 00:00:00.000 2 14:31:00 15:40:00 358
MIMCCOOB 2016-10-19 00:00:00.000 1 07:35:00 08:32:00 0
MIMCCOOB 2016-10-19 00:00:00.000 2 09:03:00 09:55:00 31
MIMCCOOB 2016-10-19 00:00:00.000 3 10:35:00 11:41:00 40
MIMCCOOB 2016-10-20 00:00:00.000 1 08:50:00 10:00:00 0
MIMCCOOB 2016-10-20 00:00:00.000 2 10:30:00 11:17:00 30
MIMCCOOB 2016-10-20 00:00:00.000 3 11:41:00 12:46:00 24
MIMCCOOB 2016-10-20 00:00:00.000 4 13:18:00 13:53:00 32
MIMCCOOB 2016-10-24 00:00:00.000 1 07:36:00 08:27:00 0
MIMCCOOB 2016-10-25 00:00:00.000 1 12:55:00 14:28:00 0
MIMCCOOB 2016-10-26 00:00:00.000 1 07:38:00 09:37:00 0
MIMCCOOB 2016-10-26 00:00:00.000 2 10:05:00 11:10:00 28
MIMCCOOB 2016-10-26 00:00:00.000 3 11:19:00 12:13:00 9
MIMCCOOB 2016-10-27 00:00:00.000 1 07:35:00 08:45:00 0
MIMCCOOB 2016-10-31 00:00:00.000 1 07:32:00 08:45:00 0
NALOPUSH 2016-10-04 00:00:00.000 1 07:27:00 08:55:00 0
NALOPUSH 2016-10-04 00:00:00.000 2 09:28:00 10:27:00 33
NALOPUSH 2016-10-04 00:00:00.000 3 11:08:00 11:58:00 41
NALOPUSH 2016-10-13 00:00:00.000 1 07:32:00 08:11:00 0
NALOPUSH 2016-10-13 00:00:00.000 2 16:52:00 18:46:00 521
NALOPUSH 2016-10-14 00:00:00.000 1 15:30:00 16:05:00 0
NALOPUSH 2016-10-18 00:00:00.000 1 07:29:00 08:28:00 0
NALOPUSH 2016-10-18 00:00:00.000 2 09:12:00 10:59:00 44
NALOPUSH 2016-10-20 00:00:00.000 1 10:50:00 11:25:00 0
NALOPUSH 2016-10-20 00:00:00.000 2 12:07:00 12:53:00 42
NALOPUSH 2016-10-21 00:00:00.000 1 14:25:00 15:10:00 0
NALOPUSH 2016-10-27 00:00:00.000 1 07:26:00 08:35:00 0
NALOPUSH 2016-10-27 00:00:00.000 2 09:13:00 09:52:00 38
NALOPUSH 2016-10-28 00:00:00.000 1 14:08:00 14:45:00 0
NALOPUSH 2016-10-28 00:00:00.000 2 15:01:00 15:47:00 16
NIVEGA 2016-10-18 00:00:00.000 1 12:53:00 14:28:00 0
PAMCCAHI 2016-10-04 00:00:00.000 1 12:45:00 14:22:00 0
PAMCCAHI 2016-10-04 00:00:00.000 2 18:08:00 18:45:00 226
PAMCCAHI 2016-10-14 00:00:00.000 1 17:10:00 17:49:00 0
PAMCCAHI 2016-10-14 00:00:00.000 2 18:13:00 19:23:00 24
PAMCCAHI 2016-10-28 00:00:00.000 1 12:09:00 12:51:00 0
PAMCCAHI 2016-10-28 00:00:00.000 2 13:12:00 13:47:00 21
PRPRADHA 2016-10-28 00:00:00.000 1 08:40:00 09:06:00 0
PRPRADHA 2016-10-28 00:00:00.000 2 09:28:00 10:03:00 22
PRPRADHA 2016-10-28 00:00:00.000 3 10:36:00 11:24:00 33
PRPRADHA 2016-10-28 00:00:00.000 4 11:50:00 12:30:00 26
PRPRADHA 2016-10-28 00:00:00.000 5 13:02:00 13:59:00 32
PRPRADHA 2016-10-28 00:00:00.000 6 14:29:00 15:11:00 30
PRPRADHA 2016-10-28 00:00:00.000 7 15:38:00 16:12:00 27
PRPRADHA 2016-10-28 00:00:00.000 8 17:06:00 18:02:00 54
PRPRADHA 2016-10-28 00:00:00.000 9 19:53:00 20:31:00 111
PVENKAT 2016-10-03 00:00:00.000 1 07:37:00 08:43:00 0
PVENKAT 2016-10-06 00:00:00.000 1 10:24:00 11:05:00 0
PVENKAT 2016-10-06 00:00:00.000 2 11:46:00 12:40:00 41
REWEAVER 2016-10-03 00:00:00.000 1 07:50:00 10:59:00 0
REWEAVER 2016-10-03 00:00:00.000 2 11:04:00 11:59:00 5
REWEAVER 2016-10-05 00:00:00.000 1 12:56:00 15:38:00 0
REWEAVER 2016-10-17 00:00:00.000 1 07:51:00 13:46:00 0
REWEAVER 2016-10-20 00:00:00.000 1 07:54:00 10:48:00 0
REWEAVER 2016-10-28 00:00:00.000 1 13:09:00 14:32:00 0
REWEAVER 2016-10-31 00:00:00.000 1 09:24:00 10:07:00 0
RIMULROY 2016-10-12 00:00:00.000 1 07:42:00 09:39:00 0
RIMULROY 2016-10-12 00:00:00.000 2 10:25:00 13:10:00 46
RIMULROY 2016-10-12 00:00:00.000 3 12:50:00 15:00:00 -20
RIMULROY 2016-10-15 00:00:00.000 1 10:06:00 12:02:00 0
RIMULROY 2016-10-16 00:00:00.000 1 12:09:00 13:35:00 0
RIMULROY 2016-10-17 00:00:00.000 1 07:43:00 09:43:00 0
RIMULROY 2016-10-17 00:00:00.000 2 09:41:00 11:39:00 -2
RIMULROY 2016-10-17 00:00:00.000 3 11:24:00 13:17:00 -15
RIMULROY 2016-10-17 00:00:00.000 4 13:09:00 15:13:00 -8
RIMULROY 2016-10-24 00:00:00.000 1 07:37:00 09:22:00 0
RIMULROY 2016-10-24 00:00:00.000 2 09:14:00 11:43:00 -8
RIMULROY 2016-10-24 00:00:00.000 3 11:33:00 13:23:00 -10
RIMULROY 2016-10-26 00:00:00.000 1 07:30:00 08:34:00 0
RIMULROY 2016-10-26 00:00:00.000 2 09:10:00 10:12:00 36
RIMULROY 2016-10-26 00:00:00.000 3 10:47:00 11:32:00 35
RIMULROY 2016-10-26 00:00:00.000 4 12:06:00 12:49:00 34
RIMULROY 2016-10-31 00:00:00.000 1 07:43:00 09:38:00 0
RIMULROY 2016-10-31 00:00:00.000 2 09:47:00 11:41:00 9
RIMULROY 2016-10-31 00:00:00.000 3 11:36:00 13:48:00 -5
RIMULROY 2016-10-31 00:00:00.000 4 13:29:00 15:07:00 -19
ROZUNENS 2016-10-20 00:00:00.000 1 07:27:00 08:01:00 0
ROZUNENS 2016-10-20 00:00:00.000 2 08:37:00 09:17:00 36
RUSHU 2016-10-05 00:00:00.000 1 07:48:00 08:01:00 0
RUSHU 2016-10-05 00:00:00.000 2 08:08:00 08:19:00 7
RUSHU 2016-10-05 00:00:00.000 3 08:50:00 09:29:00 31
RUSHU 2016-10-05 00:00:00.000 4 09:56:00 10:53:00 27
RUSHU 2016-10-05 00:00:00.000 5 11:14:00 11:31:00 21
RUSHU 2016-10-14 00:00:00.000 1 13:03:00 14:01:00 0
RUSHU 2016-10-19 00:00:00.000 1 07:30:00 08:21:00 0
RUSHU 2016-10-19 00:00:00.000 2 08:39:00 09:02:00 18
RUSHU 2016-10-26 00:00:00.000 1 07:22:00 07:58:00 0
RUSHU 2016-10-26 00:00:00.000 2 08:17:00 08:51:00 19
RYFRANKE1 2016-10-19 00:00:00.000 1 07:28:00 09:31:00 0
RYFRANKE1 2016-10-19 00:00:00.000 2 10:09:00 11:14:00 38
RYFRANKE1 2016-10-26 00:00:00.000 1 07:26:00 08:08:00 0
RYFRANKE1 2016-10-26 00:00:00.000 2 08:32:00 09:12:00 24
RYFRANKE1 2016-10-26 00:00:00.000 3 09:35:00 10:04:00 23
RYFRANKE1 2016-10-28 00:00:00.000 1 08:41:00 09:23:00 0
RYFRANKE1 2016-10-28 00:00:00.000 2 09:41:00 10:21:00 18
RYFRANKE1 2016-10-28 00:00:00.000 3 10:39:00 11:14:00 18
RYFRANKE1 2016-10-29 00:00:00.000 1 08:28:00 09:15:00 0
RYFRANKE1 2016-10-31 00:00:00.000 1 13:02:00 13:58:00 0
RYFRANKE1 2016-10-31 00:00:00.000 2 14:33:00 15:17:00 35
RYFRANKE1 2016-10-31 00:00:00.000 3 16:01:00 16:32:00 44
SACARTER1 2016-10-06 00:00:00.000 1 23:57:00 01:08:00 0
SACARTER1 2016-10-10 00:00:00.000 1 11:25:00 13:00:00 0
SACARTER1 2016-10-10 00:00:00.000 2 18:45:00 20:11:00 345
SACARTER1 2016-10-23 00:00:00.000 1 18:07:00 19:34:00 0
SADONEGA 2016-10-17 00:00:00.000 1 07:29:00 08:08:00 0
SADONEGA 2016-10-27 00:00:00.000 1 11:00:00 11:46:00 0
SCMANDEL 2016-10-04 00:00:00.000 1 13:10:00 15:12:00 0
SCMANDEL 2016-10-05 00:00:00.000 1 07:39:00 09:07:00 0
SCMANDEL 2016-10-05 00:00:00.000 2 09:49:00 10:42:00 42
SCMANDEL 2016-10-05 00:00:00.000 3 11:29:00 13:46:00 47
SCMANDEL 2016-10-10 00:00:00.000 1 20:53:00 21:09:00 0
SCMANDEL 2016-10-12 00:00:00.000 1 07:44:00 09:42:00 0
SCMANDEL 2016-10-12 00:00:00.000 2 10:31:00 11:30:00 49
SCMANDEL 2016-10-14 00:00:00.000 1 07:30:00 08:34:00 0
SCMANDEL 2016-10-14 00:00:00.000 2 09:18:00 10:43:00 44
SCMANDEL 2016-10-14 00:00:00.000 3 11:35:00 12:54:00 52
SCMANDEL 2016-10-14 00:00:00.000 4 13:40:00 15:18:00 46
SCMANDEL 2016-10-19 00:00:00.000 1 07:40:00 09:32:00 0
SCMANDEL 2016-10-21 00:00:00.000 1 08:37:00 10:06:00 0
SCMANDEL 2016-10-23 00:00:00.000 1 08:40:00 10:54:00 0
SCMANDEL 2016-10-26 00:00:00.000 1 07:39:00 08:46:00 0
SCMANDEL 2016-10-26 00:00:00.000 2 09:30:00 12:30:00 44
SCMANDEL 2016-10-26 00:00:00.000 3 13:30:00 14:09:00 60
SCMANDEL 2016-10-26 00:00:00.000 4 15:12:00 17:03:00 63
SCMANDEL 2016-10-28 00:00:00.000 1 08:36:00 09:06:00 0
SCMANDEL 2016-10-28 00:00:00.000 2 09:49:00 11:13:00 43
SCMANDEL 2016-10-28 00:00:00.000 3 11:53:00 13:04:00 40
SCMANDEL 2016-10-28 00:00:00.000 4 14:12:00 16:00:00 68
SOHANJAN 2016-10-28 00:00:00.000 1 14:20:00 15:13:00 0
STMALONE 2016-10-03 00:00:00.000 1 17:55:00 19:56:00 0
STMALONE 2016-10-04 00:00:00.000 1 16:06:00 18:34:00 0
STMALONE 2016-10-06 00:00:00.000 1 14:25:00 17:19:00 0
STMALONE 2016-10-07 00:00:00.000 1 08:48:00 14:02:00 0
STMALONE 2016-10-08 00:00:00.000 1 11:00:00 14:08:00 0
STMALONE 2016-10-11 00:00:00.000 1 11:25:00 12:18:00 0
STMALONE 2016-10-11 00:00:00.000 2 12:53:00 13:48:00 35
STMALONE 2016-10-13 00:00:00.000 1 14:59:00 19:24:00 0
STMALONE 2016-10-19 00:00:00.000 1 10:26:00 13:06:00 0
STMALONE 2016-10-21 00:00:00.000 1 08:45:00 14:17:00 0
STMALONE 2016-10-27 00:00:00.000 1 13:03:00 15:27:00 0
STMALONE 2016-10-29 00:00:00.000 1 13:05:00 16:29:00 0
STMALONE 2016-10-30 00:00:00.000 1 14:22:00 15:14:00 0
STPIDGEO 2016-10-14 00:00:00.000 1 07:29:00 09:02:00 0
STPIDGEO 2016-10-14 00:00:00.000 2 09:31:00 10:05:00 29
STPIDGEO 2016-10-28 00:00:00.000 1 08:24:00 09:25:00 0
STPIDGEO 2016-10-28 00:00:00.000 2 09:50:00 10:27:00 25
STPIDGEO 2016-10-28 00:00:00.000 3 10:59:00 11:49:00 32
STPIDGEO 2016-10-28 00:00:00.000 4 12:05:00 12:30:00 16
TIHRON 2016-10-30 00:00:00.000 1 23:40:00 00:30:00 0
TUWATERS 2016-10-05 00:00:00.000 1 12:16:00 13:40:00 0
TUWATERS 2016-10-05 00:00:00.000 2 14:12:00 15:37:00 32
TUWATERS 2016-10-05 00:00:00.000 3 15:57:00 17:30:00 20
TUWATERS 2016-10-06 00:00:00.000 1 11:32:00 12:17:00 0
TUWATERS 2016-10-06 00:00:00.000 2 12:55:00 13:51:00 38
TUWATERS 2016-10-13 00:00:00.000 1 07:37:00 11:22:00 0
TUWATERS 2016-10-13 00:00:00.000 2 12:27:00 14:45:00 65
TUWATERS 2016-10-24 00:00:00.000 1 07:27:00 08:54:00 0
TUWATERS 2016-10-24 00:00:00.000 2 09:30:00 10:12:00 36
VAATANAS 2016-10-04 00:00:00.000 1 09:32:00 10:29:00 0
VAATANAS 2016-10-04 00:00:00.000 2 11:00:00 12:03:00 31
VAATANAS 2016-10-11 00:00:00.000 1 08:54:00 09:47:00 0
VAATANAS 2016-10-18 00:00:00.000 1 08:57:00 09:28:00 0
VAATANAS 2016-10-18 00:00:00.000 2 09:58:00 10:31:00 30
VAATANAS 2016-10-18 00:00:00.000 3 11:01:00 11:55:00 30
VAATANAS 2016-10-18 00:00:00.000 4 12:15:00 13:47:00 20
VAATANAS 2016-10-18 00:00:00.000 5 16:44:00 18:55:00 177
VAATANAS 2016-10-25 00:00:00.000 1 07:27:00 08:24:00 0
VAATANAS 2016-10-25 00:00:00.000 2 09:25:00 10:35:00 61
VAATANAS 2016-10-25 00:00:00.000 3 11:11:00 12:09:00 36
VITEWARI 2016-10-04 00:00:00.000 1 07:22:00 07:45:00 0
VITEWARI 2016-10-04 00:00:00.000 2 07:50:00 08:14:00 5
VITEWARI 2016-10-04 00:00:00.000 3 08:18:00 08:45:00 4
VITEWARI 2016-10-04 00:00:00.000 4 08:50:00 09:17:00 5
VITEWARI 2016-10-04 00:00:00.000 5 09:13:00 09:35:00 -4
VITEWARI 2016-10-04 00:00:00.000 6 09:41:00 10:05:00 6
VITEWARI 2016-10-04 00:00:00.000 7 10:09:00 10:34:00 4
VITEWARI 2016-10-04 00:00:00.000 8 10:40:00 11:00:00 6
VITEWARI 2016-10-04 00:00:00.000 9 11:04:00 11:31:00 4
VITEWARI 2016-10-04 00:00:00.000 10 11:35:00 12:00:00 4
VITEWARI 2016-10-04 00:00:00.000 11 12:08:00 12:21:00 8
VITEWARI 2016-10-04 00:00:00.000 12 12:27:00 12:36:00 6
VITEWARI 2016-10-11 00:00:00.000 1 07:22:00 07:45:00 0
VITEWARI 2016-10-11 00:00:00.000 2 07:51:00 08:12:00 6
VITEWARI 2016-10-11 00:00:00.000 3 08:18:00 08:43:00 6
VITEWARI 2016-10-11 00:00:00.000 4 08:50:00 09:15:00 7
VITEWARI 2016-10-11 00:00:00.000 5 09:20:00 09:44:00 5
VITEWARI 2016-10-11 00:00:00.000 6 09:50:00 10:16:00 6
VITEWARI 2016-10-11 00:00:00.000 7 10:23:00 10:54:00 7
VITEWARI 2016-10-11 00:00:00.000 8 11:05:00 11:12:00 11
VITEWARI 2016-10-18 00:00:00.000 1 07:23:00 07:45:00 0
VITEWARI 2016-10-18 00:00:00.000 2 07:50:00 08:15:00 5
VITEWARI 2016-10-18 00:00:00.000 3 08:20:00 08:47:00 5
VITEWARI 2016-10-18 00:00:00.000 4 08:52:00 09:14:00 5
VITEWARI 2016-10-18 00:00:00.000 5 09:20:00 09:47:00 6
VITEWARI 2016-10-18 00:00:00.000 6 09:55:00 10:18:00 8
VITEWARI 2016-10-18 00:00:00.000 7 10:23:00 10:49:00 5
VITEWARI 2016-10-18 00:00:00.000 8 10:54:00 11:17:00 5
VITEWARI 2016-10-18 00:00:00.000 9 11:21:00 11:28:00 4
VITEWARI 2016-10-18 00:00:00.000 10 11:31:00 11:40:00 3
VITEWARI 2016-10-25 00:00:00.000 1 07:24:00 07:44:00 0
VITEWARI 2016-10-25 00:00:00.000 2 07:50:00 08:13:00 6
VITEWARI 2016-10-25 00:00:00.000 3 08:20:00 08:44:00 7
VITEWARI 2016-10-25 00:00:00.000 4 08:51:00 09:15:00 7
VITEWARI 2016-10-25 00:00:00.000 5 09:22:00 09:44:00 7
VITEWARI 2016-10-25 00:00:00.000 6 09:50:00 10:14:00 6
VITEWARI 2016-10-25 00:00:00.000 7 10:19:00 10:44:00 5
VITEWARI 2016-10-25 00:00:00.000 8 10:48:00 10:57:00 4
VITEWARI 2016-10-25 00:00:00.000 9 11:02:00 11:10:00 5
WAWAKIM 2016-10-26 00:00:00.000 1 01:27:00 12:59:00 0
WESUNG 2016-10-13 00:00:00.000 1 15:37:00 16:19:00 0
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply