After export the excel in the first tab "Staff Check-in Record", excel cannot be opened "the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."
select 'dbr.tab', 'Staff Check-in Records';
select 'dbr.tab', 'Student Check-in Logs';
select 'DBR.text' as 'DBR.text', 'Eye Level Belcher\'s' as 'centername';
select 'dbr.text', 'Staff Check-in records from 2024-04-22 to 2024-05-22';
select 'dbr.hdr', 'Date', 'Username';
select 'dbr.search', 1;
select 'dbr.subtitle', 'Staff Check-in Report ';
select 'dbr.css', '.nowrap {white-space:nowrap}';
select 'dbr.resultclass', 'nowrap';
select 'dbr.column.filter', 'Date', 'select';
select 'dbr.column.filter', 'Staff', 'text';
select cast('2024-05-22' as date) as 'Date', 'Chesman Ngan' as 'Staff', 'eyelevel.chesman@gmail.com' as 'Username', '08:48:58 AM' as 'Time (IN)', '09:01:46 AM' as 'Time (OUT)', '' as 'Late (HH:mm:ss)', '' as 'Over Time (HH:mm:ss)'
union all
select cast('2024-05-22' as date), 'Dave Tong', 'eyelevel.dave@gmail.com', '10:55:31 AM', '', '01:55:31', ''
union all
select cast('2024-05-22' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:19:33 AM', '', '00:19:33', ''
union all
select cast('2024-05-22' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '10:00:04 AM', '', '01:00:04', ''
union all
select cast('2024-05-22' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:23:28 AM', '', '00:23:28', ''
union all
select cast('2024-05-22' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '09:58:54 AM', '', '00:58:54', ''
union all
select cast('2024-05-21' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:33:41 AM', '06:47:22 PM', '00:33:41', ''
union all
select cast('2024-05-21' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '09:29:03 AM', '06:35:25 PM', '00:29:03', ''
union all
select cast('2024-05-21' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:17:36 AM', '06:47:54 PM', '00:17:36', ''
union all
select cast('2024-05-21' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:36:59 AM', '06:34:02 PM', '00:36:59', ''
union all
select cast('2024-05-21' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '10:03:44 AM', '06:47:53 PM', '01:03:44', ''
union all
select cast('2024-05-20' as date), 'Dave Tong', 'eyelevel.dave@gmail.com', '10:03:59 AM', '07:27:01 PM', '01:03:59', '00:27:01'
union all
select cast('2024-05-20' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '10:08:34 AM', '06:37:27 PM', '01:08:34', ''
union all
select cast('2024-05-20' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:19:52 AM', '06:39:32 PM', '00:19:52', ''
union all
select cast('2024-05-20' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '09:56:23 AM', '06:41:27 PM', '00:56:23', ''
union all
select cast('2024-05-18' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:23:45 AM', '06:31:59 PM', '00:23:45', ''
union all
select cast('2024-05-18' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '09:19:51 AM', '06:32:03 PM', '00:19:51', ''
union all
select cast('2024-05-18' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:22:18 AM', '06:34:15 PM', '00:22:18', ''
union all
select cast('2024-05-18' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:23:17 AM', '06:30:08 PM', '00:23:17', ''
union all
select cast('2024-05-18' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:21:02 AM', '06:30:54 PM', '00:21:02', ''
union all
select cast('2024-05-18' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '09:31:55 AM', '06:33:41 PM', '00:31:55', ''
union all
select cast('2024-05-17' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:31:54 AM', '06:40:12 PM', '00:31:54', ''
union all
select cast('2024-05-17' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '09:28:20 AM', '06:29:48 PM', '00:28:20', ''
union all
select cast('2024-05-17' as date), 'Dave Tong', 'eyelevel.dave@gmail.com', '09:52:17 AM', '08:39:04 PM', '00:52:17', '01:39:04'
union all
select cast('2024-05-17' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:27:36 AM', '06:35:50 PM', '00:27:36', ''
union all
select cast('2024-05-17' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:22:09 AM', '06:30:11 PM', '00:22:09', ''
union all
select cast('2024-05-17' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:28:05 AM', '06:30:40 PM', '00:28:05', ''
union all
select cast('2024-05-17' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '09:59:56 AM', '06:36:48 PM', '00:59:56', ''
union all
select cast('2024-05-16' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:31:52 AM', '06:40:28 PM', '00:31:52', ''
union all
select cast('2024-05-16' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '01:46:09 PM', '06:39:13 PM', '04:46:09', ''
union all
select cast('2024-05-16' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:01:51 AM', '06:37:41 PM', '00:01:51', ''
union all
select cast('2024-05-16' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:19:41 AM', '06:33:33 PM', '00:19:41', ''
union all
select cast('2024-05-14' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:29:36 AM', '06:38:26 PM', '00:29:36', ''
union all
select cast('2024-05-14' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '08:54:15 AM', '06:36:54 PM', '', ''
union all
select cast('2024-05-14' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:38:20 AM', '06:31:06 PM', '00:38:20', ''
union all
select cast('2024-05-14' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '10:00:28 AM', '06:34:08 PM', '01:00:28', ''
union all
select cast('2024-05-13' as date), 'Dave Tong', 'eyelevel.dave@gmail.com', '09:54:17 AM', '06:45:15 PM', '00:54:17', ''
union all
select cast('2024-05-13' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:56:06 AM', '06:43:36 PM', '00:56:06', ''
union all
select cast('2024-05-13' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:30:15 AM', '06:32:31 PM', '00:30:15', ''
union all
select cast('2024-05-13' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '10:07:18 AM', '', '01:07:18', ''
union all
select cast('2024-05-11' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:23:57 AM', '06:47:57 PM', '00:23:57', ''
union all
select cast('2024-05-11' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '09:28:05 AM', '01:28:16 PM', '00:28:05', ''
union all
select cast('2024-05-11' as date), 'Dave Tong', 'eyelevel.dave@gmail.com', '10:38:59 AM', '07:58:42 PM', '01:38:59', '00:58:42'
union all
select cast('2024-05-11' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:19:41 AM', '06:34:20 PM', '00:19:41', ''
union all
select cast('2024-05-11' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:32:03 AM', '06:30:38 PM', '00:32:03', ''
union all
select cast('2024-05-11' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:23:13 AM', '06:34:34 PM', '00:23:13', ''
union all
select cast('2024-05-11' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '09:32:23 AM', '06:35:53 PM', '00:32:23', ''
union all
select cast('2024-05-10' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:27:55 AM', '06:58:05 PM', '00:27:55', ''
union all
select cast('2024-05-10' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '09:12:06 AM', '06:31:25 PM', '00:12:06', ''
union all
select cast('2024-05-10' as date), 'Dave Tong', 'eyelevel.dave@gmail.com', '10:48:31 AM', '07:40:33 PM', '01:48:31', '00:40:33'
union all
select cast('2024-05-10' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:21:00 AM', '06:37:41 PM', '00:21:00', ''
union all
select cast('2024-05-10' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:30:58 AM', '06:40:19 PM', '00:30:58', ''
union all
select cast('2024-05-10' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:23:39 AM', '06:33:47 PM', '00:23:39', ''
union all
select cast('2024-05-10' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '10:05:28 AM', '06:38:57 PM', '01:05:28', ''
union all
select cast('2024-05-09' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:31:53 AM', '06:39:10 PM', '00:31:53', ''
union all
select cast('2024-05-09' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '08:31:58 AM', '06:36:31 PM', '', ''
union all
select cast('2024-05-09' as date), 'Dave Tong', 'eyelevel.dave@gmail.com', '10:51:35 AM', '07:41:46 PM', '01:51:35', '00:41:46'
union all
select cast('2024-05-09' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:18:50 AM', '06:39:35 PM', '00:18:50', ''
union all
select cast('2024-05-09' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:25:54 AM', '06:30:09 PM', '00:25:54', ''
union all
select cast('2024-05-08' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '08:58:44 AM', '', '', ''
union all
select cast('2024-05-08' as date), 'Dave Tong', 'eyelevel.dave@gmail.com', '02:21:45 PM', '', '05:21:45', ''
union all
select cast('2024-05-08' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:12:58 AM', '06:37:52 PM', '00:12:58', ''
union all
select cast('2024-05-08' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:55:02 AM', '06:31:07 PM', '00:55:02', ''
union all
select cast('2024-05-08' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:22:26 AM', '06:38:31 PM', '00:22:26', ''
union all
select cast('2024-05-08' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '09:59:12 AM', '06:54:22 PM', '00:59:12', ''
union all
select cast('2024-05-07' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:32:38 AM', '06:31:32 PM', '00:32:38', ''
union all
select cast('2024-05-07' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '09:24:37 AM', '06:30:55 PM', '00:24:37', ''
union all
select cast('2024-05-07' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:17:52 AM', '06:39:59 PM', '00:17:52', ''
union all
select cast('2024-05-07' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:39:39 AM', '06:31:17 PM', '00:39:39', ''
union all
select cast('2024-05-07' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '09:56:58 AM', '06:52:09 PM', '00:56:58', ''
union all
select cast('2024-05-06' as date), 'Dave Tong', 'eyelevel.dave@gmail.com', '10:18:04 AM', '08:08:43 PM', '01:18:04', '01:08:43'
union all
select cast('2024-05-06' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:59:33 AM', '06:40:02 PM', '00:59:33', ''
union all
select cast('2024-05-06' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:29:27 AM', '06:34:38 PM', '00:29:27', ''
union all
select cast('2024-05-06' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '10:02:53 AM', '06:44:02 PM', '01:02:53', ''
union all
select cast('2024-05-04' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:27:50 AM', '06:48:09 PM', '00:27:50', ''
union all
select cast('2024-05-04' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '09:01:31 AM', '06:31:16 PM', '00:01:31', ''
union all
select cast('2024-05-04' as date), 'Dave Tong', 'eyelevel.dave@gmail.com', '10:22:47 AM', '07:07:03 PM', '01:22:47', '00:07:03'
union all
select cast('2024-05-04' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:28:16 AM', '06:35:46 PM', '00:28:16', ''
union all
select cast('2024-05-04' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:27:17 AM', '06:30:05 PM', '00:27:17', ''
union all
select cast('2024-05-04' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '06:35:51 PM', '', '09:35:51', ''
union all
select cast('2024-05-03' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:29:42 AM', '06:49:21 PM', '00:29:42', ''
union all
select cast('2024-05-03' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '09:29:32 AM', '06:31:10 PM', '00:29:32', ''
union all
select cast('2024-05-03' as date), 'Dave Tong', 'eyelevel.dave@gmail.com', '10:50:41 AM', '', '01:50:41', ''
union all
select cast('2024-05-03' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:28:55 AM', '06:40:52 PM', '00:28:55', ''
union all
select cast('2024-05-03' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:32:05 AM', '06:36:58 PM', '00:32:05', ''
union all
select cast('2024-05-03' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:27:56 AM', '06:31:11 PM', '00:27:56', ''
union all
select cast('2024-05-03' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '10:04:32 AM', '06:41:28 PM', '01:04:32', ''
union all
select cast('2024-05-02' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:37:14 AM', '06:42:14 PM', '00:37:14', ''
union all
select cast('2024-05-02' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '09:06:36 AM', '06:35:37 PM', '00:06:36', ''
union all
select cast('2024-05-02' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:21:15 AM', '06:35:09 PM', '00:21:15', ''
union all
select cast('2024-05-02' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:25:19 AM', '06:31:03 PM', '00:25:19', ''
union all
select cast('2024-04-30' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '09:09:58 AM', '06:29:29 PM', '00:09:58', ''
union all
select cast('2024-04-30' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:24:48 AM', '06:38:14 PM', '00:24:48', ''
union all
select cast('2024-04-30' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:31:32 AM', '06:29:33 PM', '00:31:32', ''
union all
select cast('2024-04-30' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '10:04:08 AM', '06:43:54 PM', '01:04:08', ''
union all
select cast('2024-04-29' as date), 'Aysenem Durdyyeva', 'eyelevel.aysenem@gmail.com', '10:02:12 AM', '06:52:22 PM', '01:02:12', ''
union all
select cast('2024-04-29' as date), 'Dave Tong', 'eyelevel.dave@gmail.com', '10:03:29 AM', '', '01:03:29', ''
union all
select cast('2024-04-29' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:32:23 AM', '06:52:20 PM', '00:32:23', ''
union all
select cast('2024-04-29' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:32:20 AM', '', '00:32:20', ''
union all
select cast('2024-04-29' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '10:05:43 AM', '06:52:38 PM', '01:05:43', ''
union all
select cast('2024-04-27' as date), 'Aysenem Durdyyeva', 'eyelevel.aysenem@gmail.com', '09:32:14 AM', '06:33:44 PM', '00:32:14', ''
union all
select cast('2024-04-27' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:27:40 AM', '06:32:08 PM', '00:27:40', ''
union all
select cast('2024-04-27' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '06:04:53 PM', '06:29:40 PM', '09:04:53', ''
union all
select cast('2024-04-27' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '08:57:47 AM', '06:36:42 PM', '', ''
union all
select cast('2024-04-27' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:20:08 AM', '06:33:14 PM', '00:20:08', ''
union all
select cast('2024-04-27' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:17:19 AM', '06:32:31 PM', '00:17:19', ''
union all
select cast('2024-04-27' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '09:21:47 AM', '06:37:11 PM', '00:21:47', ''
union all
select cast('2024-04-26' as date), 'Aysenem Durdyyeva', 'eyelevel.aysenem@gmail.com', '09:53:10 AM', '06:45:08 PM', '00:53:10', ''
union all
select cast('2024-04-26' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:35:22 AM', '06:45:31 PM', '00:35:22', ''
union all
select cast('2024-04-26' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '08:40:10 AM', '06:31:48 PM', '', ''
union all
select cast('2024-04-26' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:32:23 AM', '06:45:53 PM', '00:32:23', ''
union all
select cast('2024-04-26' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:31:09 AM', '06:38:45 PM', '00:31:09', ''
union all
select cast('2024-04-26' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '09:18:46 AM', '06:34:52 PM', '00:18:46', ''
union all
select cast('2024-04-25' as date), 'Aysenem Durdyyeva', 'eyelevel.aysenem@gmail.com', '01:48:35 PM', '02:02:23 PM', '04:48:35', ''
union all
select cast('2024-04-25' as date), 'Cathy Ho', 'eyelevel.cathy@gmail.com', '09:28:31 AM', '06:37:22 PM', '00:28:31', ''
union all
select cast('2024-04-25' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '09:26:54 AM', '06:33:55 PM', '00:26:54', ''
union all
select cast('2024-04-25' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:16:34 AM', '06:33:45 PM', '00:16:34', ''
union all
select cast('2024-04-25' as date), 'Loveleen Kaur', 'eyelevel.loveleen@gmail.com', '10:00:56 AM', '06:32:08 PM', '01:00:56', ''
union all
select cast('2024-04-24' as date), 'Aysenem Durdyyeva', 'eyelevel.aysenem@gmail.com', '09:50:40 AM', '06:34:14 PM', '00:50:40', ''
union all
select cast('2024-04-24' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '09:28:46 AM', '06:29:26 PM', '00:28:46', ''
union all
select cast('2024-04-24' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:20:29 AM', '06:44:07 PM', '00:20:29', ''
union all
select cast('2024-04-24' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:33:20 AM', '06:42:56 PM', '00:33:20', ''
union all
select cast('2024-04-24' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '09:53:49 AM', '06:43:35 PM', '00:53:49', ''
union all
select cast('2024-04-23' as date), 'Chesman Ngan', 'eyelevel.chesman@gmail.com', '09:00:18 AM', '06:29:52 PM', '00:00:18', ''
union all
select cast('2024-04-23' as date), 'Hazel Zhang', 'eyelevel.hazel@gmail.com', '09:19:01 AM', '06:47:23 PM', '00:19:01', ''
union all
select cast('2024-04-23' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:37:43 AM', '06:30:15 PM', '00:37:43', ''
union all
select cast('2024-04-23' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '11:37:14 AM', '06:47:26 PM', '02:37:14', ''
union all
select cast('2024-04-22' as date), 'Aysenem Durdyyeva', 'eyelevel.aysenem@gmail.com', '09:28:01 AM', '06:36:42 PM', '00:28:01', ''
union all
select cast('2024-04-22' as date), 'Dave Tong', 'eyelevel.dave@gmail.com', '09:19:56 AM', '09:23:53 PM', '00:19:56', '02:23:53'
union all
select cast('2024-04-22' as date), 'Katheeja Ibrahim', 'eyelevel.katheeja@gmail.com', '09:26:19 AM', '06:45:33 PM', '00:26:19', ''
union all
select cast('2024-04-22' as date), 'Venus Cheung', 'eyelevel.venus@gmail.com', '10:02:19 AM', '06:47:20 PM', '01:02:19', '';
select 'dbr.tab.next';
select 'DBR.text' as 'DBR.text', 'Eye Level Belcher\'s' as 'centername';
select 'dbr.text', 'Student Check-in records from 2024-04-22 to 2024-05-22';
select 'dbr.hdr', 'Date', 'Student';
select 'dbr.search', 1;
select 'dbr.subtitle', 'Student Check-in Report ';
select 'dbr.css', '.nowrap {white-space:nowrap}';
select 'dbr.resultclass', 'nowrap';
select 'dbr.column.filter', 'Date', 'select';
select 'dbr.column.filter', 'Student', 'text';
select cast(NULL as date) as 'Date', '' as 'Student', '' as 'ID', cast(NULL as time) as 'Time', '' as 'Device name', '' as 'Device version', '' as 'Device identifier'
where 1=0;
