/* code to illustrate */ CREATE TABLE #stops (stopNumber int , tripNumber int , orderNumber int , estArriveDate datetime , actArriveDate datetime , stopAction char(6)); INSERT INTO #stops (stopNumber, tripNumber, orderNumber, estArriveDate, actArriveDate, stopAction) VALUES (414169, 121214, 3065993, 'Feb 6 2017 6:00AM', 'Feb 6 2017 6:00AM', 'LVL') , ( 414170, 121214, 3065993, 'Feb 8 2017 7:00AM', 'Feb 8 2017 7:00AM', 'LVU') , ( 414171, 121215, 3065994, 'Feb 2 2017 4:00PM', 'Feb 2 2017 4:00PM', 'HKP') , ( 414172, 121215, 3065994, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414173, 121216, 3065995, 'Feb 2 2017 4:00PM', 'Feb 2 2017 4:00PM', 'HKP') , ( 414174, 121216, 3065995, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414175, 121217, 3065996, 'Feb 2 2017 4:00PM', 'Feb 2 2017 4:00PM', 'HKP') , ( 414176, 121217, 3065996, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414177, 121218, 3065997, 'Feb 1 2017 11:00PM', 'Feb 1 2017 11:00PM', 'HKP') , ( 414178, 121218, 3065997, 'Feb 2 2017 7:00AM', 'Feb 2 2017 7:00AM', 'LVU') , ( 414179, 121219, 3065998, 'Feb 1 2017 11:00PM', 'Feb 1 2017 11:00PM', 'HKP') , ( 414180, 121219, 3065998, 'Feb 2 2017 7:00AM', 'Feb 2 2017 7:00AM', 'LVU') , ( 414181, 121220, 3065999, 'Feb 1 2017 8:00AM', 'Feb 1 2017 8:00AM', 'LVL') , ( 414182, 121220, 3065999, 'Feb 9 2017 12:00AM', 'Feb 9 2017 12:00AM', 'LVU') , ( 414184, 121221, 3066000, 'Oct 1 2017 6:00AM', 'Oct 1 2017 6:00AM', 'LVL') , ( 414185, 121221, 3066000, 'Oct 1 2017 6:00AM', 'Oct 1 2017 6:00AM', 'LVU') , ( 414192, 121224, 3066002, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVL') , ( 414193, 121224, 3066002, 'Feb 2 2017 4:00PM', 'Feb 2 2017 4:00PM', 'LVU') , ( 414194, 121225, 3066003, 'Feb 2 2017 12:00PM', 'Feb 2 2017 12:00PM', 'LVL') , ( 414195, 121225, 3066003, 'Feb 3 2017 9:00AM', 'Feb 3 2017 9:00AM', 'LVU') , ( 414196, 121226, 3066004, 'Feb 7 2017 8:00AM', 'Feb 7 2017 8:00AM', 'LVL') , ( 414197, 121226, 3066004, 'Feb 10 2017 12:00AM', 'Feb 10 2017 12:00AM', 'LVU') , ( 414202, 121228, 0, 'Jan 31 2017 4:20PM', 'Feb 1 2017 6:00PM', 'HKT') , ( 409726, 121228, 3065013, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414203, 121229, 0, 'Feb 1 2017 6:27AM', 'Feb 1 2017 6:27AM', 'BBOB') , ( 414204, 121229, 0, 'Feb 1 2017 6:28AM', 'Feb 1 2017 6:28AM', 'HMT') , ( 414211, 121229, 0, 'Feb 1 2017 6:32AM', 'Feb 1 2017 6:32AM', 'EEMP') , ( 414212, 121230, 3066006, 'Feb 3 2017 12:00PM', 'Feb 3 2017 12:00PM', 'HKP') , ( 414213, 121230, 3066006, 'Feb 6 2017 6:30AM', 'Feb 6 2017 6:30AM', 'LVU') , ( 414214, 121230, 3066006, 'Feb 6 2017 8:00AM', 'Feb 6 2017 8:00AM', 'LVU') , ( 414215, 121231, 3066007, 'Oct 1 2017 6:00AM', 'Oct 1 2017 6:00AM', 'LVL') , ( 414216, 121231, 3066007, 'Oct 1 2017 6:00AM', 'Oct 1 2017 6:00AM', 'LVU') , ( 414219, 121232, 3066008, 'Feb 2 2017 10:00AM', 'Feb 2 2017 10:00AM', 'HKP') , ( 414220, 121232, 3066008, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414221, 121233, 3066009, 'Feb 2 2017 10:00AM', 'Feb 2 2017 10:00AM', 'HKP') , ( 414222, 121233, 3066009, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414223, 121234, 3066010, 'Feb 2 2017 10:00AM', 'Feb 2 2017 10:00AM', 'HKP') , ( 414224, 121234, 3066010, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414233, 121235, 3066011, 'Feb 7 2017 11:00PM', 'Feb 7 2017 11:00PM', 'LVL') , ( 414234, 121235, 3066011, 'Feb 8 2017 12:00AM', 'Feb 8 2017 12:00AM', 'LVU') , ( 414235, 121236, 3066012, 'Feb 6 2017 10:00PM', 'Feb 6 2017 10:00PM', 'LVL') , ( 414236, 121236, 3066012, 'Feb 7 2017 6:00AM', 'Feb 7 2017 6:00AM', 'LVU') , ( 414237, 121237, 3066013, 'Feb 7 2017 11:00PM', 'Feb 7 2017 11:00PM', 'LVL') , ( 414238, 121237, 3066013, 'Feb 8 2017 12:00AM', 'Feb 8 2017 12:00AM', 'LVU') , ( 414241, 121238, 3066014, 'Feb 1 2017 6:00AM', 'Feb 1 2017 6:00AM', 'HKP') , ( 414242, 121238, 3066014, 'Feb 2 2017 7:00AM', 'Feb 2 2017 7:00AM', 'LVU') , ( 414724, 121240, 0, 'Feb 1 2017 10:59AM', 'Feb 1 2017 10:03AM', 'BEMP') , ( 414246, 121240, 3066016, 'Feb 1 2017 11:00AM', 'Feb 1 2017 11:00AM', 'LVL') , ( 414247, 121240, 3066016, 'Feb 3 2017 9:00AM', 'Feb 3 2017 9:00AM', 'LVU') , ( 414620, 121241, 0, 'Feb 1 2017 10:31AM', 'Feb 1 2017 12:07PM', 'BEMP') , ( 414253, 121241, 3066017, 'Feb 1 2017 8:00AM', 'Feb 1 2017 3:00PM', 'LVL') , ( 414254, 121241, 3066017, 'Feb 2 2017 11:00PM', 'Feb 2 2017 11:00PM', 'LVU') , ( 414255, 121241, 3066017, 'Feb 3 2017 12:00AM', 'Feb 3 2017 12:00AM', 'LVU') , ( 414257, 121242, 0, 'Feb 1 2017 6:57AM', 'Feb 1 2017 6:57AM', 'BBOB') , ( 414258, 121242, 0, 'Feb 1 2017 6:57AM', 'Feb 1 2017 6:57AM', 'EBOB') , ( 414259, 121243, 0, 'Feb 1 2017 6:59AM', 'Feb 1 2017 6:59AM', 'BBOB') , ( 414260, 121243, 0, 'Feb 1 2017 6:59AM', 'Feb 1 2017 6:59AM', 'EBOB') , ( 414263, 121244, 3066018, 'Feb 3 2017 12:00AM', 'Feb 3 2017 12:00AM', 'LVL') , ( 414264, 121244, 3066018, 'Feb 7 2017 5:15PM', 'Feb 7 2017 5:15PM', 'LVU') , ( 414265, 121245, 3066019, 'Feb 3 2017 12:00AM', 'Feb 3 2017 12:00AM', 'LVL') , ( 414266, 121245, 3066019, 'Feb 6 2017 4:15AM', 'Feb 6 2017 4:15AM', 'LVU') , ( 414268, 121246, 0, 'Feb 1 2017 7:02AM', 'Feb 1 2017 7:02AM', 'BEMP') , ( 414269, 121246, 0, 'Feb 1 2017 7:02AM', 'Feb 1 2017 11:00AM', 'EEMP') , ( 414281, 121248, 0, 'Feb 1 2017 7:05AM', 'Feb 1 2017 7:05AM', 'BEMP') , ( 414282, 121248, 0, 'Feb 1 2017 7:05AM', 'Feb 1 2017 7:05AM', 'EEMP') , ( 414285, 121250, 3066022, 'Feb 11 2017 6:00AM', 'Feb 11 2017 6:00AM', 'LVL') , ( 414286, 121250, 3066022, 'Feb 12 2017 6:00AM', 'Feb 12 2017 6:00AM', 'LVU') , ( 414289, 121252, 3066024, 'Feb 8 2017 6:00AM', 'Feb 8 2017 6:00AM', 'LVL') , ( 414290, 121252, 3066024, 'Feb 10 2017 12:00AM', 'Feb 10 2017 12:00AM', 'LVU') , ( 414291, 121253, 3066025, 'Feb 7 2017 6:00AM', 'Feb 7 2017 6:00AM', 'LVL') , ( 414293, 121253, 3066025, 'Feb 9 2017 12:00AM', 'Feb 9 2017 12:00AM', 'LVU') , ( 414296, 121255, 3066027, 'Feb 11 2017 6:00AM', 'Feb 11 2017 6:00AM', 'LVL') , ( 414297, 121255, 3066027, 'Feb 12 2017 6:00AM', 'Feb 12 2017 6:00AM', 'LVU') , ( 414304, 121256, 0, 'Feb 1 2017 2:00PM', 'Feb 1 2017 2:00PM', 'HKT') , ( 396061, 121256, 3061979, 'Feb 2 2017 7:00AM', 'Feb 2 2017 7:00AM', 'LVU') , ( 414316, 121257, 0, 'Feb 1 2017 2:54PM', 'Feb 1 2017 2:54PM', 'HKT') , ( 410528, 121257, 3065134, 'Feb 3 2017 8:00AM', 'Feb 3 2017 8:00AM', 'LVU') , ( 414320, 121259, 3066029, 'Feb 1 2017 6:00AM', 'Feb 1 2017 6:00AM', 'LVL') , ( 414321, 121259, 3066029, 'Feb 2 2017 3:15AM', 'Feb 2 2017 3:15AM', 'LVU') , ( 414327, 121260, 3066030, 'Feb 1 2017 11:00AM', 'Feb 1 2017 11:00AM', 'LVL') , ( 414328, 121260, 3066030, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414336, 121261, 0, 'Feb 1 2017 2:02PM', 'Feb 1 2017 2:04PM', 'HKT') , ( 406076, 121261, 3064159, 'Feb 1 2017 8:00AM', 'Feb 3 2017 8:00AM', 'LVU') , ( 414337, 121262, 0, 'Feb 1 2017 7:19AM', 'Feb 1 2017 7:19AM', 'BBOB') , ( 414338, 121262, 0, 'Feb 1 2017 7:19AM', 'Feb 1 2017 7:19AM', 'EBOB') , ( 414410, 121263, 0, 'Feb 1 2017 7:59AM', 'Feb 1 2017 7:59AM', 'BEMP') , ( 414339, 121263, 3066031, 'Feb 1 2017 8:00AM', 'Feb 1 2017 8:00AM', 'LVL') , ( 414340, 121263, 3066031, 'Feb 6 2017 12:00AM', 'Feb 6 2017 12:00AM', 'LVU') , ( 414341, 121264, 0, 'Feb 1 2017 7:21AM', 'Feb 1 2017 7:21AM', 'BBOB') , ( 414342, 121264, 0, 'Feb 1 2017 7:21AM', 'Feb 1 2017 7:21AM', 'EBOB') , ( 414975, 121265, 0, 'Feb 1 2017 1:01PM', 'Feb 1 2017 1:01PM', 'BEMP') , ( 414974, 121265, 0, 'Feb 1 2017 1:02PM', 'Feb 1 2017 1:02PM', 'DEMP') , ( 414344, 121265, 0, 'Feb 1 2017 1:02PM', 'Feb 1 2017 1:03PM', 'HKT') , ( 412354, 121265, 3065588, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414345, 121266, 0, 'Feb 1 2017 7:22AM', 'Feb 1 2017 7:22AM', 'BBOB') , ( 414346, 121266, 0, 'Feb 1 2017 7:22AM', 'Feb 1 2017 7:22AM', 'EBOB') , ( 414347, 121267, 0, 'Feb 1 2017 7:23AM', 'Feb 1 2017 7:23AM', 'BBOB') , ( 414348, 121267, 0, 'Feb 1 2017 7:23AM', 'Feb 1 2017 7:23AM', 'EBOB') , ( 414395, 121268, 0, 'Feb 2 2017 8:14AM', 'Feb 2 2017 8:14AM', 'HMT') , ( 414351, 121268, 3066032, 'Feb 2 2017 8:15AM', 'Feb 2 2017 8:15AM', 'LVL') , ( 414352, 121268, 3066032, 'Feb 2 2017 8:16AM', 'Feb 2 2017 8:16AM', 'LVU') , ( 414353, 121268, 3066032, 'Feb 2 2017 8:31AM', 'Feb 2 2017 8:31AM', 'LVU') , ( 414354, 121268, 3066032, 'Feb 2 2017 9:01AM', 'Feb 2 2017 9:01AM', 'LVU') , ( 414355, 121268, 3066032, 'Feb 2 2017 9:31AM', 'Feb 2 2017 9:31AM', 'LVU') , ( 414356, 121268, 3066032, 'Feb 2 2017 10:01AM', 'Feb 2 2017 10:01AM', 'LVU') , ( 414357, 121268, 3066032, 'Feb 2 2017 10:31AM', 'Feb 2 2017 10:31AM', 'LVU') , ( 414358, 121268, 3066032, 'Feb 2 2017 11:01AM', 'Feb 2 2017 11:01AM', 'LVU') , ( 414359, 121268, 3066032, 'Feb 2 2017 11:31AM', 'Feb 2 2017 11:31AM', 'LVU') , ( 414360, 121268, 3066032, 'Feb 2 2017 12:01PM', 'Feb 2 2017 12:01PM', 'LVU') , ( 414428, 121269, 0, 'Feb 1 2017 6:59AM', 'Feb 1 2017 6:59AM', 'BEMP') , ( 414361, 121269, 3066033, 'Feb 1 2017 7:00AM', 'Feb 1 2017 8:12AM', 'LVL') , ( 414362, 121269, 3066033, 'Feb 2 2017 7:30AM', 'Feb 2 2017 7:30AM', 'LVU') , ( 414396, 121270, 0, 'Feb 1 2017 7:59AM', 'Feb 1 2017 9:45AM', 'HMT') , ( 414375, 121270, 3066034, 'Feb 1 2017 8:00AM', 'Feb 1 2017 12:04PM', 'LVL') , ( 414376, 121270, 3066034, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414377, 121270, 3066034, 'Feb 2 2017 8:00AM', 'Feb 2 2017 3:01PM', 'LVU') , ( 414379, 121271, 3066035, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVL') , ( 414380, 121271, 3066035, 'Feb 3 2017 6:00AM', 'Feb 3 2017 6:00AM', 'LVU') , ( 414390, 121272, 0, 'Feb 1 2017 7:35AM', 'Feb 1 2017 7:35AM', 'BEMP') , ( 414391, 121272, 0, 'Feb 1 2017 7:36AM', 'Feb 1 2017 7:36AM', 'EEMP') , ( 414401, 121273, 0, 'Feb 1 2017 7:40AM', 'Feb 1 2017 7:40AM', 'BBOB') , ( 414402, 121273, 0, 'Feb 1 2017 7:40AM', 'Feb 1 2017 7:40AM', 'EBOB') , ( 414403, 121274, 3066036, 'Feb 1 2017 8:00PM', 'Feb 1 2017 8:00PM', 'LVL') , ( 414404, 121274, 3066036, 'Feb 2 2017 6:00AM', 'Feb 2 2017 6:00AM', 'LVU') , ( 414405, 121275, 3066037, 'Feb 1 2017 8:00PM', 'Feb 1 2017 8:00PM', 'LVL') , ( 414406, 121275, 3066037, 'Feb 2 2017 7:00AM', 'Feb 2 2017 7:00AM', 'LVU') , ( 414407, 121276, 3066038, 'Feb 3 2017 8:00AM', 'Feb 3 2017 8:00AM', 'LVL') , ( 414408, 121276, 3066038, 'Feb 6 2017 8:00AM', 'Feb 6 2017 8:00AM', 'LVU') , ( 414413, 121278, 0, 'Feb 1 2017 7:41AM', 'Feb 1 2017 7:41AM', 'BEMP') , ( 414414, 121278, 0, 'Feb 1 2017 7:41AM', 'Feb 1 2017 7:41AM', 'EEMP') , ( 414442, 121279, 0, 'Feb 1 2017 8:59AM', 'Feb 1 2017 8:00AM', 'BEMP') , ( 414415, 121279, 3066040, 'Feb 1 2017 9:00AM', 'Feb 1 2017 8:04AM', 'LVL') , ( 414416, 121279, 3066040, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414443, 121279, 0, 'Feb 2 2017 2:00PM', 'Feb 2 2017 4:00PM', 'EEMP') , ( 414419, 121280, 0, 'Feb 1 2017 7:43AM', 'Feb 1 2017 7:43AM', 'BEMP') , ( 414420, 121280, 0, 'Feb 1 2017 7:43AM', 'Feb 1 2017 7:43AM', 'EEMP') , ( 414422, 121281, 3066041, 'Feb 1 2017 12:00PM', 'Feb 1 2017 12:00PM', 'LVL') , ( 414423, 121281, 3066041, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414916, 121282, 0, 'Feb 1 2017 12:31PM', 'Feb 1 2017 12:31PM', 'BEMP') , ( 414426, 121282, 3066042, 'Feb 1 2017 8:00AM', 'Feb 1 2017 2:00PM', 'LVL') , ( 414427, 121282, 3066042, 'Feb 2 2017 7:00AM', 'Feb 2 2017 7:00AM', 'LVU') , ( 414449, 121283, 3066043, 'Feb 3 2017 10:00AM', 'Feb 3 2017 10:00AM', 'LVL') , ( 414450, 121283, 3066043, 'Feb 6 2017 5:00AM', 'Feb 6 2017 5:00AM', 'LVU') , ( 414452, 121284, 3066044, 'Feb 1 2017 4:00PM', 'Feb 1 2017 4:00PM', 'HKP') , ( 414453, 121284, 3066044, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414454, 121285, 3066045, 'Mar 15 2017 8:00AM', 'Mar 15 2017 8:00AM', 'LVL') , ( 414455, 121285, 3066045, 'Mar 20 2017 8:00AM', 'Mar 20 2017 8:00AM', 'LVU') , ( 414479, 121287, 0, 'Feb 1 2017 6:07PM', 'Feb 1 2017 6:07PM', 'BBOB') , ( 414470, 121287, 0, 'Jan 26 2017 6:07PM', 'Feb 1 2017 6:08PM', 'HKT') , ( 396353, 121287, 3062045, 'Jan 30 2017 8:00AM', 'Feb 2 2017 9:00AM', 'LVU') , ( 414805, 121289, 0, 'Feb 1 2017 10:59AM', 'Feb 1 2017 10:59AM', 'BEMP') , ( 414484, 121289, 3066048, 'Feb 1 2017 11:00AM', 'Feb 1 2017 11:00AM', 'LVL') , ( 414485, 121289, 3066048, 'Feb 2 2017 7:00AM', 'Feb 2 2017 7:00AM', 'LVU') , ( 414486, 121290, 3066049, 'Feb 1 2017 12:00PM', 'Feb 1 2017 12:00PM', 'HKP') , ( 414487, 121290, 3066049, 'Feb 3 2017 12:00AM', 'Feb 3 2017 12:00AM', 'LVU') , ( 414545, 121291, 0, 'Feb 1 2017 6:59AM', 'Feb 1 2017 8:21AM', 'BEMP') , ( 414488, 121291, 3066050, 'Feb 1 2017 7:00AM', 'Feb 1 2017 9:23AM', 'LVL') , ( 414490, 121291, 3066050, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414746, 121292, 0, 'Feb 1 2017 11:59AM', 'Feb 1 2017 11:59AM', 'BEMP') , ( 414495, 121292, 3066051, 'Feb 1 2017 12:00PM', 'Feb 1 2017 12:00PM', 'LVL') , ( 414496, 121292, 3066051, 'Feb 3 2017 10:00AM', 'Feb 3 2017 10:00AM', 'LVU') , ( 414497, 121293, 0, 'Feb 1 2017 8:00AM', 'Feb 1 2017 8:00AM', 'INSERV') , ( 414498, 121293, 0, 'Feb 1 2017 8:00AM', 'Feb 1 2017 8:00AM', 'INSERV') , ( 414500, 121294, 3066052, 'Feb 1 2017 8:00AM', 'Feb 1 2017 8:00AM', 'LVL') , ( 414501, 121294, 3066052, 'Feb 2 2017 6:00AM', 'Feb 2 2017 6:00AM', 'LVU') , ( 414502, 121295, 3066053, 'Feb 2 2017 6:00AM', 'Feb 2 2017 6:00AM', 'HKP') , ( 414503, 121295, 3066053, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414504, 121296, 3066054, 'Feb 9 2017 6:00AM', 'Feb 9 2017 6:00AM', 'LVL') , ( 414505, 121296, 3066054, 'Feb 11 2017 12:00AM', 'Feb 11 2017 12:00AM', 'LVU') , ( 414510, 121299, 3066057, 'Feb 1 2017 9:00PM', 'Feb 1 2017 9:00PM', 'HKP') , ( 414511, 121299, 3066057, 'Feb 2 2017 6:00AM', 'Feb 2 2017 6:00AM', 'LVU') , ( 414517, 121300, 3066058, 'Feb 11 2017 10:00AM', 'Feb 11 2017 10:00AM', 'LVL') , ( 414518, 121300, 3066058, 'Feb 13 2017 11:00AM', 'Feb 13 2017 11:00AM', 'LVU') , ( 414519, 121301, 3066059, 'Feb 2 2017 10:15AM', 'Feb 2 2017 10:15AM', 'LVL') , ( 414520, 121301, 3066059, 'Feb 3 2017 5:30AM', 'Feb 3 2017 5:30AM', 'LVU') , ( 414548, 121302, 0, 'Feb 1 2017 8:31AM', 'Feb 1 2017 9:00AM', 'BEMP') , ( 414547, 121302, 0, 'Feb 1 2017 8:32AM', 'Feb 1 2017 9:05AM', 'DEMP') , ( 414527, 121302, 0, 'Feb 1 2017 8:32AM', 'Feb 1 2017 9:15AM', 'HKT') , ( 406140, 121302, 3064175, 'Feb 1 2017 8:00AM', 'Feb 1 2017 10:30AM', 'LVU') , ( 414531, 121303, 3066060, 'Feb 3 2017 3:00PM', 'Feb 3 2017 3:00PM', 'LVL') , ( 414532, 121303, 3066060, 'Feb 5 2017 7:00AM', 'Feb 5 2017 7:00AM', 'LVU') , ( 414534, 121304, 3066061, 'Feb 3 2017 1:00AM', 'Feb 3 2017 1:00AM', 'LVL') , ( 414535, 121304, 3066061, 'Feb 7 2017 5:00AM', 'Feb 7 2017 5:00AM', 'LVU') , ( 414538, 121305, 3066062, 'Feb 2 2017 10:45AM', 'Feb 2 2017 10:45AM', 'LVL') , ( 414539, 121305, 3066062, 'Feb 3 2017 7:30AM', 'Feb 3 2017 7:30AM', 'LVU') , ( 414540, 121306, 3066063, 'Feb 2 2017 9:45AM', 'Feb 2 2017 9:45AM', 'LVL') , ( 414541, 121306, 3066063, 'Feb 3 2017 4:00AM', 'Feb 3 2017 4:00AM', 'LVU') , ( 414542, 121307, 3066064, 'Feb 2 2017 12:30PM', 'Feb 2 2017 12:30PM', 'LVL') , ( 414543, 121307, 3066064, 'Feb 3 2017 7:30AM', 'Feb 3 2017 7:30AM', 'LVU') , ( 414550, 121308, 3066065, 'Feb 2 2017 11:00AM', 'Feb 2 2017 11:00AM', 'LVL') , ( 414551, 121308, 3066065, 'Feb 3 2017 8:00AM', 'Feb 3 2017 8:00AM', 'LVU') , ( 414554, 121310, 3066067, 'Feb 3 2017 6:00AM', 'Feb 3 2017 6:00AM', 'LVL') , ( 414555, 121310, 3066067, 'Feb 6 2017 5:15AM', 'Feb 6 2017 5:15AM', 'LVU') , ( 414556, 121311, 3066068, 'Feb 2 2017 6:00AM', 'Feb 2 2017 6:00AM', 'LVL') , ( 414557, 121311, 3066068, 'Feb 3 2017 10:15PM', 'Feb 3 2017 10:15PM', 'LVU') , ( 414558, 121312, 3066069, 'Feb 2 2017 6:00AM', 'Feb 2 2017 6:00AM', 'LVL') , ( 414559, 121312, 3066069, 'Feb 3 2017 4:15AM', 'Feb 3 2017 4:15AM', 'LVU') , ( 414742, 121313, 0, 'Feb 1 2017 2:59PM', 'Feb 1 2017 2:59PM', 'BEMP') , ( 414560, 121313, 3066070, 'Feb 1 2017 3:00PM', 'Feb 1 2017 3:00PM', 'LVL') , ( 414561, 121313, 3066070, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414562, 121314, 3066071, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVL') , ( 414563, 121314, 3066071, 'Feb 3 2017 12:00PM', 'Feb 3 2017 12:00PM', 'LVU') , ( 414564, 121315, 3066072, 'Feb 6 2017 6:00AM', 'Feb 6 2017 6:00AM', 'LVL') , ( 414565, 121315, 3066072, 'Feb 9 2017 7:00AM', 'Feb 9 2017 7:00AM', 'LVU') , ( 414566, 121316, 3066073, 'Feb 6 2017 6:00AM', 'Feb 6 2017 6:00AM', 'LVL') , ( 414567, 121316, 3066073, 'Feb 7 2017 3:15AM', 'Feb 7 2017 3:15AM', 'LVU') , ( 414569, 121317, 3066074, 'Feb 2 2017 6:00AM', 'Feb 2 2017 6:00AM', 'LVL') , ( 414570, 121317, 3066074, 'Feb 3 2017 9:15PM', 'Feb 3 2017 9:15PM', 'LVU') , ( 414571, 121318, 3066075, 'Feb 2 2017 6:00AM', 'Feb 2 2017 6:00AM', 'LVL') , ( 414572, 121318, 3066075, 'Feb 3 2017 5:45AM', 'Feb 3 2017 5:45AM', 'LVU') , ( 414573, 121319, 3066076, 'Feb 2 2017 6:00AM', 'Feb 2 2017 6:00AM', 'LVL') , ( 414574, 121319, 3066076, 'Feb 3 2017 7:15AM', 'Feb 3 2017 7:15AM', 'LVU') , ( 414575, 121320, 3066077, 'Feb 3 2017 6:00AM', 'Feb 3 2017 6:00AM', 'LVL') , ( 414576, 121320, 3066077, 'Feb 6 2017 6:15AM', 'Feb 6 2017 6:15AM', 'LVU') , ( 414577, 121321, 3066078, 'Feb 3 2017 6:00AM', 'Feb 3 2017 6:00AM', 'LVL') , ( 414578, 121321, 3066078, 'Feb 7 2017 7:00AM', 'Feb 7 2017 7:00AM', 'LVU') , ( 414579, 121322, 3066079, 'Feb 3 2017 6:00AM', 'Feb 3 2017 6:00AM', 'LVL') , ( 414580, 121322, 3066079, 'Feb 6 2017 6:15AM', 'Feb 6 2017 6:15AM', 'LVU') , ( 414581, 121323, 3066080, 'Feb 6 2017 6:00AM', 'Feb 6 2017 6:00AM', 'LVL') , ( 414582, 121323, 3066080, 'Feb 7 2017 6:00AM', 'Feb 7 2017 6:00AM', 'LVU') , ( 414583, 121324, 3066081, 'Feb 2 2017 11:00PM', 'Feb 2 2017 11:00PM', 'LVL') , ( 414584, 121324, 3066081, 'Feb 3 2017 8:45PM', 'Feb 3 2017 8:45PM', 'LVU') , ( 414585, 121325, 3066082, 'Feb 3 2017 6:00AM', 'Feb 3 2017 6:00AM', 'LVL') , ( 414586, 121325, 3066082, 'Feb 6 2017 9:15AM', 'Feb 6 2017 9:15AM', 'LVU') , ( 414587, 121326, 3066083, 'Feb 3 2017 11:00PM', 'Feb 3 2017 11:00PM', 'LVL') , ( 414588, 121326, 3066083, 'Feb 6 2017 6:15AM', 'Feb 6 2017 6:15AM', 'LVU') , ( 414589, 121327, 3066084, 'Feb 6 2017 6:00AM', 'Feb 6 2017 6:00AM', 'LVL') , ( 414590, 121327, 3066084, 'Feb 7 2017 4:15AM', 'Feb 7 2017 4:15AM', 'LVU') , ( 414591, 121328, 3066085, 'Feb 6 2017 6:00AM', 'Feb 6 2017 6:00AM', 'LVL') , ( 414592, 121328, 3066085, 'Feb 7 2017 4:15AM', 'Feb 7 2017 4:15AM', 'LVU') , ( 414596, 121329, 3066086, 'Feb 6 2017 6:00AM', 'Feb 6 2017 6:00AM', 'LVL') , ( 414597, 121329, 3066086, 'Feb 7 2017 9:15PM', 'Feb 7 2017 9:15PM', 'LVU') , ( 414598, 121330, 3066087, 'Feb 6 2017 6:00AM', 'Feb 6 2017 6:00AM', 'LVL') , ( 414599, 121330, 3066087, 'Feb 7 2017 3:15AM', 'Feb 7 2017 3:15AM', 'LVU') , ( 414600, 121331, 3066088, 'Feb 6 2017 6:00AM', 'Feb 6 2017 6:00AM', 'LVL') , ( 414601, 121331, 3066088, 'Feb 7 2017 9:15PM', 'Feb 7 2017 9:15PM', 'LVU') , ( 414603, 121332, 3066089, 'Feb 3 2017 6:00AM', 'Feb 3 2017 6:00AM', 'LVL') , ( 414604, 121332, 3066089, 'Feb 6 2017 6:45AM', 'Feb 6 2017 6:45AM', 'LVU') , ( 414735, 121333, 0, 'Feb 1 2017 12:59PM', 'Feb 1 2017 12:59PM', 'BEMP') , ( 414605, 121333, 3066090, 'Feb 1 2017 1:00PM', 'Feb 1 2017 1:00PM', 'LVL') , ( 414606, 121333, 3066090, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414607, 121334, 3066091, 'Feb 6 2017 6:00AM', 'Feb 6 2017 6:00AM', 'LVL') , ( 414608, 121334, 3066091, 'Feb 7 2017 3:15AM', 'Feb 7 2017 3:15AM', 'LVU') , ( 414621, 121336, 3066093, 'Feb 2 2017 11:00AM', 'Feb 2 2017 11:00AM', 'LVL') , ( 414622, 121336, 3066093, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414624, 121337, 3066094, 'Feb 6 2017 12:00AM', 'Feb 6 2017 12:00AM', 'HKP') , ( 414625, 121337, 3066094, 'Feb 8 2017 12:00AM', 'Feb 8 2017 12:00AM', 'DRL') , ( 414627, 121338, 3066095, 'Feb 6 2017 12:00AM', 'Feb 6 2017 12:00AM', 'HKP') , ( 414628, 121338, 3066095, 'Feb 8 2017 12:00AM', 'Feb 8 2017 12:00AM', 'DRL') , ( 414697, 121339, 0, 'Feb 1 2017 9:31AM', 'Feb 1 2017 9:31AM', 'BEMP') , ( 414630, 121339, 3066096, 'Feb 1 2017 8:00AM', 'Feb 1 2017 12:00PM', 'LVL') , ( 414631, 121339, 3066096, 'Feb 2 2017 12:00AM', 'Feb 1 2017 11:59PM', 'LVU') , ( 414632, 121339, 3066096, 'Feb 2 2017 12:00AM', 'Feb 2 2017 12:00AM', 'LVU') , ( 414704, 121340, 0, 'Feb 1 2017 8:41AM', 'Feb 1 2017 9:46AM', 'BEMP') , ( 414634, 121340, 3066097, 'Feb 1 2017 7:00AM', 'Feb 1 2017 10:00AM', 'LVL') , ( 414635, 121340, 3066097, 'Feb 3 2017 8:00AM', 'Feb 3 2017 8:00AM', 'LVU') , ( 414636, 121341, 3066098, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVL') , ( 414637, 121341, 3066098, 'Feb 6 2017 7:00AM', 'Feb 6 2017 7:00AM', 'LVU') , ( 414638, 121342, 3066099, 'Feb 6 2017 11:00PM', 'Feb 6 2017 11:00PM', 'HKP') , ( 414639, 121342, 3066099, 'Feb 7 2017 7:00AM', 'Feb 7 2017 7:00AM', 'LVU') , ( 414640, 121343, 3066100, 'Feb 6 2017 11:00PM', 'Feb 6 2017 11:00PM', 'HKP') , ( 414641, 121343, 3066100, 'Feb 7 2017 9:15PM', 'Feb 7 2017 9:15PM', 'LVU') , ( 414643, 121344, 0, 'Feb 1 2017 2:02PM', 'Feb 1 2017 2:03PM', 'HKT') , ( 397163, 121344, 3062206, 'Feb 6 2017 6:00AM', 'Feb 6 2017 6:00AM', 'LVU') , ( 414644, 121345, 3066101, 'Feb 6 2017 8:15PM', 'Feb 6 2017 8:15PM', 'HKP') , ( 414645, 121345, 3066101, 'Feb 7 2017 4:15AM', 'Feb 7 2017 4:15AM', 'LVU') , ( 414646, 121346, 3066102, 'Feb 6 2017 6:15PM', 'Feb 6 2017 6:15PM', 'HKP') , ( 414647, 121346, 3066102, 'Feb 7 2017 2:15AM', 'Feb 7 2017 2:15AM', 'LVU') , ( 414648, 121347, 3066103, 'Feb 6 2017 8:15PM', 'Feb 6 2017 8:15PM', 'HKP') , ( 414649, 121347, 3066103, 'Feb 7 2017 3:15AM', 'Feb 7 2017 3:15AM', 'LVU') , ( 414650, 121348, 3066104, 'Feb 2 2017 11:00PM', 'Feb 2 2017 11:00PM', 'HKP') , ( 414651, 121348, 3066104, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414654, 121349, 0, 'Jan 31 2017 12:00PM', 'Jan 31 2017 12:00PM', 'INSERV') , ( 414655, 121349, 0, 'Jan 31 2017 12:00PM', 'Jan 31 2017 12:00PM', 'INSERV') , ( 414658, 121350, 0, 'Feb 1 2017 8:28AM', 'Feb 1 2017 8:28AM', 'BEMP') , ( 414659, 121350, 0, 'Feb 1 2017 8:30AM', 'Feb 1 2017 8:30AM', 'EEMP') , ( 414680, 121351, 0, 'Feb 1 2017 11:01AM', 'Feb 1 2017 11:01AM', 'BEMP') , ( 414662, 121351, 3066105, 'Feb 1 2017 8:00AM', 'Feb 1 2017 12:00PM', 'LVL') , ( 414663, 121351, 3066105, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414772, 121352, 0, 'Feb 1 2017 10:01AM', 'Feb 1 2017 11:02AM', 'BEMP') , ( 414665, 121352, 3066106, 'Feb 1 2017 8:00AM', 'Feb 1 2017 1:00PM', 'LVL') , ( 414666, 121352, 3066106, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414671, 121354, 0, 'Feb 1 2017 8:30AM', 'Feb 1 2017 8:30AM', 'INSERV') , ( 414672, 121354, 0, 'Feb 1 2017 8:30AM', 'Feb 1 2017 8:30AM', 'INSERV') , ( 414688, 121356, 3066109, 'Feb 1 2017 12:00AM', 'Feb 1 2017 12:00AM', 'LVL') , ( 414689, 121356, 3066109, 'Feb 3 2017 8:00AM', 'Feb 3 2017 8:00AM', 'LVU') , ( 414700, 121356, 3066109, 'Feb 4 2017 8:00AM', 'Feb 4 2017 8:00AM', 'LVL') , ( 414701, 121356, 3066109, 'Feb 6 2017 12:00AM', 'Feb 6 2017 12:00AM', 'LVU') , ( 414690, 121357, 0, 'Feb 1 2017 10:00AM', 'Feb 1 2017 9:55AM', 'BEMP') , ( 414691, 121357, 0, 'Feb 1 2017 11:00AM', 'Feb 1 2017 11:00AM', 'NBCST') , ( 414692, 121357, 3066110, 'Feb 1 2017 2:00PM', 'Feb 1 2017 2:00PM', 'LVL') , ( 414693, 121357, 0, 'Feb 1 2017 6:00PM', 'Feb 1 2017 6:00PM', 'NBCST') , ( 414694, 121357, 3066110, 'Feb 1 2017 8:00PM', 'Feb 1 2017 8:00PM', 'LVU') , ( 414725, 121357, 0, 'Feb 1 2017 9:00PM', 'Feb 1 2017 9:00PM', 'EEMP') , ( 414739, 121358, 0, 'Feb 1 2017 10:00AM', 'Feb 1 2017 10:00AM', 'BEMP') , ( 414698, 121358, 3066111, 'Feb 1 2017 8:00AM', 'Feb 1 2017 12:00PM', 'LVL') , ( 414699, 121358, 3066111, 'Feb 2 2017 8:00AM', 'Feb 2 2017 9:30AM', 'LVU') , ( 414702, 121359, 3066112, 'Feb 8 2017 2:35AM', 'Feb 8 2017 7:00AM', 'LVL') , ( 414703, 121359, 3066112, 'Feb 11 2017 3:35AM', 'Feb 11 2017 2:35AM', 'LVU') , ( 414877, 121360, 0, 'Feb 1 2017 6:59AM', 'Feb 1 2017 6:59AM', 'BEMP') , ( 414707, 121360, 3066113, 'Feb 1 2017 7:00AM', 'Feb 1 2017 7:00AM', 'LVL') , ( 414708, 121360, 3066113, 'Feb 2 2017 7:15AM', 'Feb 2 2017 7:15AM', 'LVU') , ( 414716, 121361, 0, 'Feb 1 2017 2:32PM', 'Feb 1 2017 2:33PM', 'HKT') , ( 404313, 121361, 3063775, 'Feb 2 2017 7:00AM', 'Feb 2 2017 7:00AM', 'LVU') , ( 414721, 121362, 0, 'Feb 1 2017 3:01PM', 'Feb 1 2017 11:14AM', 'BEMP') , ( 414717, 121362, 3066114, 'Feb 1 2017 8:00AM', 'Feb 1 2017 3:02PM', 'LVL') , ( 414718, 121362, 3066114, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414756, 121363, 0, 'Feb 1 2017 7:34AM', 'Feb 1 2017 7:34AM', 'BEMP') , ( 414719, 121363, 3066115, 'Feb 1 2017 7:00AM', 'Feb 1 2017 10:00AM', 'LVL') , ( 414720, 121363, 3066115, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414732, 121364, 3066116, 'Feb 3 2017 7:30AM', 'Feb 3 2017 7:30AM', 'LVL') , ( 414733, 121364, 3066116, 'Feb 3 2017 11:00AM', 'Feb 3 2017 11:00AM', 'LVU') , ( 414752, 121366, 3066118, 'Feb 2 2017 6:00AM', 'Feb 2 2017 6:00AM', 'LVL') , ( 414753, 121366, 3066118, 'Feb 6 2017 8:00AM', 'Feb 6 2017 8:00AM', 'LVU') , ( 414757, 121367, 3066119, 'Feb 2 2017 5:00PM', 'Feb 2 2017 5:00PM', 'LVL') , ( 414758, 121367, 3066119, 'Feb 8 2017 8:00PM', 'Feb 8 2017 8:00PM', 'LVU') , ( 414802, 121368, 0, 'Feb 1 2017 12:01PM', 'Feb 1 2017 12:01PM', 'BEMP') , ( 414760, 121368, 3066120, 'Feb 1 2017 6:00AM', 'Feb 1 2017 12:02PM', 'LVL') , ( 414761, 121368, 3066120, 'Feb 2 2017 7:00AM', 'Feb 2 2017 7:00AM', 'LVU') , ( 414763, 121369, 3066121, 'Feb 3 2017 8:00AM', 'Feb 3 2017 8:00AM', 'LVL') , ( 414764, 121369, 3066121, 'Feb 6 2017 12:00AM', 'Feb 6 2017 12:00AM', 'LVU') , ( 414829, 121373, 0, 'Feb 1 2017 10:10AM', 'Feb 1 2017 10:19AM', 'BEMP') , ( 414780, 121373, 3066125, 'Feb 1 2017 7:00AM', 'Feb 1 2017 10:46AM', 'LVL') , ( 414840, 121373, 0, 'Feb 2 2017 6:59AM', 'Feb 2 2017 6:59AM', 'RTP') , ( 414781, 121373, 3066125, 'Feb 2 2017 7:00AM', 'Feb 3 2017 10:00AM', 'LVU') , ( 414782, 121374, 0, 'Feb 1 2017 8:59AM', 'Feb 1 2017 8:59AM', 'INSERV') , ( 414783, 121374, 0, 'Feb 1 2017 8:59AM', 'Feb 1 2017 8:59AM', 'INSERV') , ( 414823, 121375, 0, 'Feb 1 2017 9:53AM', 'Feb 1 2017 9:53AM', 'BEMP') , ( 414784, 121375, 3066126, 'Feb 1 2017 7:00AM', 'Feb 1 2017 11:00AM', 'LVL') , ( 414785, 121375, 3066126, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414786, 121376, 0, 'Feb 1 2017 9:00AM', 'Feb 1 2017 9:10AM', 'BBOB') , ( 414787, 121376, 0, 'Feb 1 2017 9:00AM', 'Feb 1 2017 9:30AM', 'HMT') , ( 414800, 121376, 0, 'Feb 1 2017 9:01AM', 'Feb 1 2017 9:40AM', 'EEMP') , ( 414798, 121378, 3066128, 'Feb 2 2017 7:00PM', 'Feb 2 2017 7:00PM', 'LVL') , ( 414799, 121378, 3066128, 'Feb 3 2017 11:00AM', 'Feb 3 2017 11:00AM', 'LVU') , ( 414807, 121379, 3066129, 'Feb 1 2017 8:00AM', 'Feb 1 2017 8:00AM', 'LVL') , ( 414808, 121379, 3066129, 'Feb 2 2017 12:00AM', 'Feb 2 2017 12:00AM', 'LVU') , ( 414809, 121379, 3066129, 'Feb 2 2017 12:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414810, 121379, 3066129, 'Feb 3 2017 12:00AM', 'Feb 3 2017 8:00AM', 'LVU') , ( 415008, 121380, 0, 'Feb 2 2017 10:59AM', 'Feb 2 2017 10:59AM', 'BEMP') , ( 414813, 121380, 3066130, 'Feb 2 2017 11:00AM', 'Feb 2 2017 11:00AM', 'LVL') , ( 414814, 121380, 3066130, 'Feb 3 2017 12:00AM', 'Feb 3 2017 12:00AM', 'LVL') , ( 414815, 121380, 3066130, 'Feb 3 2017 12:01AM', 'Feb 3 2017 12:01AM', 'LVU') , ( 414826, 121381, 0, 'Feb 2 2017 7:59AM', 'Feb 2 2017 7:59AM', 'BEMP') , ( 414816, 121381, 3066131, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVL') , ( 414817, 121381, 3066131, 'Feb 6 2017 7:00AM', 'Feb 6 2017 7:00AM', 'LVU') , ( 414818, 121381, 3066131, 'Feb 7 2017 8:30AM', 'Feb 7 2017 10:01PM', 'LVU') , ( 414819, 121382, 3066132, 'Feb 3 2017 12:00PM', 'Feb 3 2017 12:00PM', 'LVL') , ( 414820, 121382, 3066132, 'Feb 6 2017 8:00AM', 'Feb 6 2017 8:00AM', 'LVU') , ( 414934, 121383, 0, 'Feb 1 2017 12:01PM', 'Feb 1 2017 10:10AM', 'BEMP') , ( 414821, 121383, 3066133, 'Feb 1 2017 6:00AM', 'Feb 1 2017 12:02PM', 'LVL') , ( 414822, 121383, 3066133, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414824, 121384, 3066134, 'Feb 3 2017 12:00AM', 'Feb 3 2017 12:00AM', 'LVL') , ( 414825, 121384, 3066134, 'Feb 6 2017 12:00AM', 'Feb 6 2017 12:00AM', 'LVU') , ( 414956, 121385, 0, 'Feb 1 2017 10:24AM', 'Feb 1 2017 10:58AM', 'BEMP') , ( 414827, 121385, 3066135, 'Feb 1 2017 6:00AM', 'Feb 1 2017 10:59AM', 'LVL') , ( 414828, 121385, 3066135, 'Feb 2 2017 8:00AM', 'Feb 2 2017 10:00AM', 'LVU') , ( 414834, 121386, 3066136, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVL') , ( 414835, 121386, 3066136, 'Feb 3 2017 8:00AM', 'Feb 3 2017 8:00AM', 'LVU') , ( 414838, 121387, 3066137, 'Feb 3 2017 10:00AM', 'Feb 3 2017 10:00AM', 'LVL') , ( 414839, 121387, 3066137, 'Feb 7 2017 7:00AM', 'Feb 7 2017 7:00AM', 'LVU') , ( 414873, 121388, 0, 'Feb 2 2017 1:59PM', 'Feb 2 2017 7:59AM', 'BEMP') , ( 414841, 121388, 3066138, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVL') , ( 414842, 121388, 3066138, 'Feb 6 2017 8:00AM', 'Feb 6 2017 8:00AM', 'LVU') , ( 414843, 121388, 3066138, 'Feb 6 2017 9:00AM', 'Feb 6 2017 3:01PM', 'LVU') , ( 414845, 121389, 3066139, 'Feb 2 2017 7:00AM', 'Feb 2 2017 7:00AM', 'LVL') , ( 414846, 121389, 3066139, 'Feb 6 2017 9:00AM', 'Feb 6 2017 9:00AM', 'LVU') , ( 414847, 121390, 3066140, 'Feb 2 2017 7:00AM', 'Feb 2 2017 7:00AM', 'LVL') , ( 414848, 121390, 3066140, 'Feb 8 2017 7:00AM', 'Feb 8 2017 7:00AM', 'LVU') , ( 414849, 121391, 3066141, 'Feb 2 2017 5:00AM', 'Feb 2 2017 5:00AM', 'HKP') , ( 414850, 121391, 3066141, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414851, 121391, 3066141, 'Feb 2 2017 9:01AM', 'Feb 2 2017 9:01AM', 'LVU') , ( 414852, 121391, 3066141, 'Feb 2 2017 10:01AM', 'Feb 2 2017 10:01AM', 'LVU') , ( 414853, 121391, 3066141, 'Feb 2 2017 11:01AM', 'Feb 2 2017 11:01AM', 'LVU') , ( 414854, 121391, 3066141, 'Feb 2 2017 12:01PM', 'Feb 2 2017 12:01PM', 'LVU') , ( 414855, 121391, 3066141, 'Feb 2 2017 1:01PM', 'Feb 2 2017 1:01PM', 'LVU') , ( 414856, 121391, 3066141, 'Feb 2 2017 2:01PM', 'Feb 2 2017 2:01PM', 'LVU') , ( 414857, 121391, 3066141, 'Feb 2 2017 3:01PM', 'Feb 2 2017 3:01PM', 'LVU') , ( 414858, 121391, 3066141, 'Feb 3 2017 8:00AM', 'Feb 3 2017 8:00AM', 'LVU') , ( 414859, 121391, 0, 'Feb 3 2017 1:00PM', 'Feb 3 2017 1:00PM', 'DEMP') , ( 414860, 121392, 3066142, 'Feb 2 2017 7:00AM', 'Feb 2 2017 7:00AM', 'LVL') , ( 414861, 121392, 3066142, 'Feb 8 2017 7:00AM', 'Feb 8 2017 7:00AM', 'LVU') , ( 414863, 121393, 0, 'Feb 1 2017 2:02PM', 'Feb 1 2017 2:03PM', 'HKT') , ( 410201, 121393, 3065074, 'Feb 6 2017 12:00AM', 'Feb 6 2017 12:00AM', 'LVU') , ( 414864, 121394, 3066143, 'Feb 1 2017 7:00AM', 'Feb 1 2017 7:00AM', 'LVL') , ( 414865, 121394, 3066143, 'Feb 2 2017 12:00AM', 'Feb 2 2017 12:00AM', 'LVU') , ( 414971, 121395, 0, 'Feb 1 2017 9:46AM', 'Feb 1 2017 12:07PM', 'BEMP') , ( 414866, 121395, 3066144, 'Feb 1 2017 8:00AM', 'Feb 1 2017 12:08PM', 'LVL') , ( 414867, 121395, 3066144, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414871, 121396, 3066094, 'Feb 1 2017 2:00PM', 'Feb 1 2017 9:41AM', 'IHMT') , ( 414872, 121396, 3066094, 'Feb 2 2017 11:59PM', 'Feb 2 2017 9:00AM', 'IDMT') , ( 414875, 121397, 3066145, 'Feb 2 2017 12:20PM', 'Feb 2 2017 12:20PM', 'LVL') , ( 414876, 121397, 3066145, 'Feb 3 2017 7:30AM', 'Feb 3 2017 7:30AM', 'LVU') , ( 414947, 121398, 0, 'Feb 2 2017 11:57PM', 'Feb 2 2017 11:57PM', 'BBOB') , ( 414882, 121398, 3066095, 'Feb 1 2017 11:58PM', 'Feb 2 2017 11:58PM', 'IHMT') , ( 414883, 121398, 3066095, 'Feb 2 2017 11:59PM', 'Feb 2 2017 11:59PM', 'IDMT') , ( 414884, 121399, 0, 'Feb 1 2017 9:22AM', 'Feb 1 2017 10:25AM', 'BBOB') , ( 414885, 121399, 0, 'Feb 1 2017 10:26AM', 'Feb 1 2017 10:26AM', 'EBOB') , ( 414889, 121400, 0, 'Feb 1 2017 12:02PM', 'Feb 1 2017 12:03PM', 'HKT') , ( 397698, 121400, 3062337, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 404138, 121400, 0, 'Feb 8 2017 5:01PM', 'Feb 8 2017 5:01PM', 'DLT') , ( 414891, 121401, 0, 'Feb 1 2017 10:01AM', 'Feb 1 2017 10:02AM', 'HKT') , ( 402738, 121401, 3063456, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414902, 121403, 0, 'Jan 30 2017 4:54PM', 'Jan 30 2017 4:55PM', 'HKT') , ( 405313, 121403, 3063995, 'Feb 2 2017 6:00AM', 'Feb 2 2017 6:00AM', 'LVU') , ( 414903, 121404, 3066146, 'Feb 2 2017 5:00AM', 'Feb 2 2017 5:00AM', 'HKP') , ( 414904, 121404, 3066146, 'Feb 2 2017 9:00AM', 'Feb 2 2017 9:00AM', 'LVU') , ( 414905, 121404, 3066146, 'Feb 2 2017 12:00PM', 'Feb 2 2017 12:00PM', 'LVU') , ( 414906, 121404, 3066146, 'Feb 2 2017 12:31PM', 'Feb 2 2017 12:31PM', 'LVU') , ( 414907, 121404, 3066146, 'Feb 2 2017 1:01PM', 'Feb 2 2017 1:01PM', 'LVU') , ( 414908, 121404, 3066146, 'Feb 2 2017 2:01PM', 'Feb 2 2017 2:01PM', 'LVU') , ( 414909, 121404, 3066146, 'Feb 3 2017 8:00AM', 'Feb 3 2017 8:00AM', 'LVU') , ( 414910, 121404, 0, 'Feb 3 2017 1:00PM', 'Feb 3 2017 1:00PM', 'DEMP') , ( 414914, 121405, 0, 'Jan 31 2017 9:35AM', 'Jan 31 2017 9:35AM', 'INSERV') , ( 414915, 121405, 0, 'Jan 31 2017 9:35AM', 'Jan 31 2017 9:35AM', 'INSERV') , ( 415025, 121406, 0, 'Feb 1 2017 7:59AM', 'Feb 1 2017 7:59AM', 'BEMP') , ( 414917, 121406, 3066147, 'Feb 1 2017 8:00AM', 'Feb 1 2017 8:00AM', 'LVL') , ( 414918, 121406, 3066147, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 414921, 121407, 3066148, 'Feb 2 2017 5:00AM', 'Feb 2 2017 5:00AM', 'HKP') , ( 414922, 121407, 3066148, 'Feb 2 2017 1:00PM', 'Feb 2 2017 1:00PM', 'LVU') , ( 414923, 121407, 3066148, 'Feb 2 2017 2:01PM', 'Feb 2 2017 2:01PM', 'LVU') , ( 414924, 121407, 3066148, 'Feb 3 2017 8:00AM', 'Feb 3 2017 8:00AM', 'LVU') , ( 414925, 121407, 0, 'Feb 3 2017 1:00PM', 'Feb 3 2017 1:00PM', 'DEMP') , ( 414929, 121408, 3066149, 'Feb 2 2017 6:00AM', 'Feb 2 2017 6:00AM', 'HKP') , ( 414930, 121408, 3066149, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 414932, 121409, 3066150, 'Feb 1 2017 5:59AM', 'Feb 1 2017 5:59AM', 'HKP') , ( 414933, 121409, 3066150, 'Feb 1 2017 12:01PM', 'Feb 1 2017 12:01PM', 'LVU') , ( 414936, 121410, 0, 'Feb 1 2017 7:49AM', 'Feb 1 2017 7:50AM', 'HKT') , ( 411390, 121410, 3065344, 'Feb 1 2017 10:00AM', 'Feb 1 2017 10:00AM', 'LVU') , ( 414938, 121411, 0, 'Feb 1 2017 4:05PM', 'Feb 1 2017 4:07PM', 'HCT') , ( 406185, 121411, 3064185, 'Feb 8 2017 7:00AM', 'Feb 8 2017 7:00AM', 'LVU') , ( 414950, 121413, 0, 'Feb 1 2017 9:46AM', 'Feb 1 2017 9:46AM', 'INSERV') , ( 414951, 121413, 0, 'Feb 1 2017 9:46AM', 'Feb 1 2017 9:46AM', 'INSERV') , ( 414952, 121414, 0, 'Feb 1 2017 9:47AM', 'Feb 1 2017 9:47AM', 'INSERV') , ( 414953, 121414, 0, 'Feb 1 2017 9:47AM', 'Feb 1 2017 9:47AM', 'INSERV') , ( 414958, 121415, 3066152, 'Feb 1 2017 3:00PM', 'Feb 1 2017 3:00PM', 'LVL') , ( 414959, 121415, 3066152, 'Feb 2 2017 9:00AM', 'Feb 2 2017 9:00AM', 'LVU') , ( 414960, 121416, 3066153, 'Feb 1 2017 7:30PM', 'Feb 1 2017 7:30PM', 'HKP') , ( 414961, 121416, 3066153, 'Feb 2 2017 7:30AM', 'Feb 2 2017 7:30AM', 'LVU') , ( 414962, 121417, 0, 'Feb 1 2017 9:50AM', 'Feb 1 2017 9:50AM', 'BBOB') , ( 414963, 121417, 0, 'Feb 1 2017 9:50AM', 'Feb 1 2017 9:50AM', 'EBOB') , ( 414966, 121418, 0, 'Feb 3 2017 12:00AM', 'Feb 3 2017 12:00AM', 'BEMP') , ( 414964, 121418, 3066154, 'Feb 3 2017 12:00AM', 'Feb 3 2017 12:00AM', 'LVL') , ( 414967, 121418, 0, 'Feb 3 2017 12:00AM', 'Feb 3 2017 12:00AM', 'NBCST') , ( 414965, 121418, 3066154, 'Feb 3 2017 12:00AM', 'Feb 3 2017 12:00AM', 'LVU') , ( 414968, 121418, 0, 'Feb 3 2017 9:51AM', 'Feb 3 2017 9:51AM', 'NBCST') , ( 414969, 121418, 0, 'Feb 3 2017 9:52AM', 'Feb 3 2017 9:52AM', 'EEMP') , ( 414993, 121425, 3066161, 'Feb 6 2017 12:00PM', 'Feb 6 2017 12:00PM', 'HKP') , ( 414994, 121425, 3066161, 'Feb 8 2017 8:00AM', 'Feb 8 2017 8:00AM', 'LVU') , ( 414996, 121426, 3066162, 'Feb 2 2017 7:30PM', 'Feb 2 2017 7:30PM', 'HKP') , ( 414997, 121426, 3066162, 'Feb 3 2017 7:30AM', 'Feb 3 2017 7:30AM', 'LVU') , ( 415003, 121427, 0, 'Feb 1 2017 10:00AM', 'Feb 1 2017 10:00AM', 'BBOB') , ( 415004, 121427, 0, 'Feb 1 2017 10:00AM', 'Feb 1 2017 10:01AM', 'EBOB') , ( 415010, 121429, 3066164, 'Feb 2 2017 5:00AM', 'Feb 2 2017 5:00AM', 'HKP') , ( 415011, 121429, 3066164, 'Feb 2 2017 9:00AM', 'Feb 2 2017 9:00AM', 'LVU') , ( 415012, 121429, 3066164, 'Feb 2 2017 10:01AM', 'Feb 2 2017 10:01AM', 'LVU') , ( 415013, 121429, 3066164, 'Feb 2 2017 11:01AM', 'Feb 2 2017 11:01AM', 'LVU') , ( 415014, 121429, 3066164, 'Feb 2 2017 12:01PM', 'Feb 2 2017 12:01PM', 'LVU') , ( 415015, 121429, 3066164, 'Feb 2 2017 2:00PM', 'Feb 2 2017 2:00PM', 'LVU') , ( 415016, 121429, 0, 'Feb 3 2017 1:00PM', 'Feb 3 2017 1:00PM', 'DEMP') , ( 415044, 121431, 0, 'Feb 1 2017 12:59PM', 'Feb 1 2017 12:59PM', 'HMT') , ( 415022, 121431, 3066165, 'Feb 1 2017 1:00PM', 'Feb 1 2017 1:00PM', 'LVL') , ( 415023, 121431, 3066165, 'Feb 2 2017 11:30AM', 'Feb 2 2017 11:30AM', 'LVU') , ( 415031, 121432, 3066166, 'Feb 2 2017 5:00AM', 'Feb 2 2017 5:00AM', 'HKP') , ( 415032, 121432, 3066166, 'Feb 2 2017 8:00AM', 'Feb 2 2017 8:00AM', 'LVU') , ( 415033, 121432, 3066166, 'Feb 2 2017 9:01AM', 'Feb 2 2017 9:01AM', 'LVU') , ( 415034, 121432, 3066166, 'Feb 2 2017 10:01AM', 'Feb 2 2017 10:01AM', 'LVU') , ( 415035, 121432, 3066166, 'Feb 2 2017 11:01AM', 'Feb 2 2017 11:01AM', 'LVU') , ( 415036, 121432, 3066166, 'Feb 2 2017 12:01PM', 'Feb 2 2017 12:01PM', 'LVU') , ( 415037, 121432, 3066166, 'Feb 2 2017 1:01PM', 'Feb 2 2017 1:01PM', 'LVU') , ( 415038, 121432, 3066166, 'Feb 2 2017 2:01PM', 'Feb 2 2017 2:01PM', 'LVU') , ( 415039, 121432, 3066166, 'Feb 3 2017 8:00AM', 'Feb 3 2017 8:00AM', 'LVU') , ( 415040, 121432, 3066166, 'Feb 3 2017 9:01AM', 'Feb 3 2017 9:01AM', 'LVU') , ( 415041, 121432, 0, 'Feb 3 2017 3:00PM', 'Feb 3 2017 3:00PM', 'DEMP') , ( 415046, 121433, 3066167, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVL') , ( 415047, 121433, 3066167, 'Feb 6 2017 9:00AM', 'Feb 6 2017 9:00AM', 'LVU') , ( 415048, 121434, 3066168, 'Feb 2 2017 3:00PM', 'Feb 2 2017 3:00PM', 'HKP') , ( 415049, 121434, 3066168, 'Feb 3 2017 12:00AM', 'Feb 3 2017 12:00AM', 'LVU') , ( 415050, 121435, 3066169, 'Feb 10 2017 12:00AM', 'Feb 10 2017 12:00AM', 'HKP') , ( 415051, 121435, 3066169, 'Feb 13 2017 12:00AM', 'Feb 13 2017 12:00AM', 'LVU') , ( 413742, 121438, 3065876, 'Feb 1 2017 12:00PM', 'Feb 1 2017 12:00PM', 'LVL') , ( 413743, 121438, 3065876, 'Feb 4 2017 9:00AM', 'Feb 4 2017 9:00AM', 'LVU') , ( 415077, 121449, 0, 'Feb 2 2017 8:03AM', 'Feb 2 2017 8:04AM', 'HCT') , ( 414217, 121449, 3065984, 'Feb 2 2017 8:00AM', 'Feb 2 2017 9:00AM', 'LVL') , ( 414218, 121449, 3065984, 'Feb 3 2017 12:00AM', 'Feb 3 2017 12:00AM', 'LVU') , ( 415078, 121450, 3066182, 'Feb 2 2017 6:30AM', 'Feb 2 2017 6:30AM', 'LVL') , ( 415079, 121450, 3066182, 'Feb 6 2017 11:00PM', 'Feb 6 2017 11:00PM', 'LVU') , ( 415095, 121452, 3066184, 'Feb 2 2017 5:00AM', 'Feb 2 2017 5:00AM', 'HKP') , ( 415096, 121452, 3066184, 'Feb 2 2017 12:00PM', 'Feb 2 2017 12:00PM', 'LVU') , ( 415097, 121452, 3066184, 'Feb 2 2017 1:01PM', 'Feb 2 2017 1:01PM', 'LVU') , ( 415098, 121452, 3066184, 'Feb 2 2017 2:01PM', 'Feb 2 2017 2:01PM', 'LVU') , ( 415099, 121452, 3066184, 'Feb 2 2017 3:01PM', 'Feb 2 2017 3:01PM', 'LVU') , ( 415100, 121452, 3066184, 'Feb 3 2017 8:00AM', 'Feb 3 2017 8:00AM', 'LVU') , ( 415101, 121452, 3066184, 'Feb 3 2017 9:01AM', 'Feb 3 2017 9:01AM', 'LVU') , ( 415102, 121452, 0, 'Feb 3 2017 1:00PM', 'Feb 3 2017 1:00PM', 'DEMP') , ( 415104, 121453, 0, 'Feb 1 2017 10:19AM', 'Feb 1 2017 10:19AM', 'BBOB') , ( 415105, 121453, 0, 'Feb 1 2017 10:19AM', 'Feb 1 2017 10:30AM', 'HMT') , ( 415114, 121453, 0, 'Feb 1 2017 10:21AM', 'Feb 1 2017 7:00PM', 'DEMP') , ( 415123, 121454, 3066185, 'Feb 3 2017 12:00AM', 'Feb 3 2017 12:00AM', 'LVL') , ( 415124, 121454, 3066185, 'Feb 6 2017 8:00AM', 'Feb 6 2017 8:00AM', 'LVU') , ( 415125, 121455, 3066186, 'Feb 2 2017 12:01AM', 'Feb 2 2017 12:01AM', 'HKP') , ( 415126, 121455, 3066186, 'Feb 3 2017 12:01AM', 'Feb 3 2017 12:01AM', 'LVU') , ( 415133, 121457, 3066188, 'Feb 2 2017 11:00AM', 'Feb 2 2017 11:00AM', 'LVL') , ( 415134, 121457, 3066188, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVU') , ( 415137, 121458, 3066189, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVL') , ( 415138, 121458, 3066189, 'Feb 6 2017 8:00AM', 'Feb 6 2017 8:00AM', 'LVU') , ( 415145, 121461, 0, 'Feb 1 2017 10:29AM', 'Feb 1 2017 10:29AM', 'BBOB') , ( 415146, 121461, 0, 'Feb 1 2017 10:29AM', 'Feb 1 2017 10:29AM', 'EBOB') , ( 415147, 121462, 3066192, 'Feb 3 2017 7:00AM', 'Feb 3 2017 7:00AM', 'LVL') , ( 415148, 121462, 3066192, 'Feb 6 2017 8:00AM', 'Feb 6 2017 8:00AM', 'LVU'); /* clean up at the end: DROP TABLE #stops; */