Get data between 3PM and 2AM

Question

Get data between 3PM and 2AM

NineIron

SSChampion

Points: 12529
More actions
November 8, 2016 at 9:35 am

#331845

This data represents visits to our Emergency Room. I need to pull the records for patients that were registered between 3PM and 2AM the next day. Any thoughts?
create table #Test
(AccountNumber varchar(30),
RegistrationDateTime datetime
)
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199071','2016-10-01 01:04:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199073','2016-10-01 02:37:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199075','2016-10-01 02:56:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199076','2016-10-01 03:15:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199079','2016-10-01 04:25:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199080','2016-10-01 04:32:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199082','2016-10-01 05:11:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199083','2016-10-01 05:15:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199084','2016-10-01 05:18:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199092','2016-10-01 06:02:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199093','2016-10-01 06:02:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199094','2016-10-01 06:14:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199095','2016-10-01 06:32:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199098','2016-10-01 07:01:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199100','2016-10-01 07:13:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199107','2016-10-01 07:44:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199119','2016-10-01 08:10:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199151','2016-10-01 08:50:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199152','2016-10-01 08:52:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199160','2016-10-01 09:05:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199161','2016-10-01 09:07:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199163','2016-10-01 09:08:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199169','2016-10-01 09:15:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199174','2016-10-01 09:19:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199193','2016-10-01 09:47:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199198','2016-10-01 09:57:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199199','2016-10-01 09:58:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199203','2016-10-01 10:08:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199204','2016-10-01 10:11:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199206','2016-10-01 10:16:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199209','2016-10-01 10:18:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199219','2016-10-01 10:30:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199220','2016-10-01 10:31:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199222','2016-10-01 10:32:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199232','2016-10-01 10:45:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199244','2016-10-01 11:00:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199253','2016-10-01 11:10:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199255','2016-10-01 11:12:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199269','2016-10-01 11:25:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199271','2016-10-01 11:26:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199273','2016-10-01 11:31:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199278','2016-10-01 11:38:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199279','2016-10-01 11:41:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199285','2016-10-01 11:50:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199288','2016-10-01 11:54:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199289','2016-10-01 11:56:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199290','2016-10-01 11:57:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199292','2016-10-01 11:59:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199294','2016-10-01 12:04:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199295','2016-10-01 12:04:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199296','2016-10-01 12:06:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199298','2016-10-01 12:10:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199299','2016-10-01 12:12:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199300','2016-10-01 12:16:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199304','2016-10-01 12:33:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199309','2016-10-01 12:53:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199310','2016-10-01 13:03:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199314','2016-10-01 13:12:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199317','2016-10-01 13:19:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199319','2016-10-01 13:24:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199322','2016-10-01 13:35:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199325','2016-10-01 13:42:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199326','2016-10-01 13:43:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199327','2016-10-01 13:52:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199329','2016-10-01 13:56:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199330','2016-10-01 14:01:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199342','2016-10-01 14:34:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199343','2016-10-01 14:44:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199346','2016-10-01 15:02:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199347','2016-10-01 15:48:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199348','2016-10-01 15:52:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199349','2016-10-01 15:54:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199352','2016-10-01 16:14:20.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199353','2016-10-01 16:25:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199354','2016-10-01 16:24:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199356','2016-10-01 16:34:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199358','2016-10-01 16:39:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199359','2016-10-01 16:50:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199360','2016-10-01 16:56:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199361','2016-10-01 16:59:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199362','2016-10-01 17:11:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199363','2016-10-01 17:11:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199368','2016-10-01 17:25:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199369','2016-10-01 17:32:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199373','2016-10-01 17:47:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199374','2016-10-01 17:48:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199376','2016-10-01 18:23:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199377','2016-10-01 18:27:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199381','2016-10-01 18:55:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199383','2016-10-01 18:59:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199384','2016-10-01 18:59:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199388','2016-10-01 19:06:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199393','2016-10-01 19:26:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199394','2016-10-01 19:29:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199396','2016-10-01 19:30:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199398','2016-10-01 19:36:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199400','2016-10-01 19:40:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199403','2016-10-01 19:55:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199405','2016-10-01 20:12:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199406','2016-10-01 20:20:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199407','2016-10-01 20:24:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199409','2016-10-01 20:44:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199410','2016-10-01 20:50:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199412','2016-10-01 21:33:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199413','2016-10-01 21:42:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199414','2016-10-01 21:50:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199415','2016-10-01 21:51:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199416','2016-10-01 21:52:10.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199418','2016-10-01 21:57:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199419','2016-10-01 21:57:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199420','2016-10-01 22:05:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199421','2016-10-01 22:07:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199423','2016-10-01 22:36:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199425','2016-10-01 22:46:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199426','2016-10-01 22:53:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199427','2016-10-01 22:57:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199428','2016-10-01 23:10:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199431','2016-10-01 23:29:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199432','2016-10-01 23:35:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199433','2016-10-01 23:43:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199434','2016-10-01 23:51:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199435','2016-10-01 23:55:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199436','2016-10-02 00:04:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199438','2016-10-02 00:30:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199440','2016-10-02 01:32:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199441','2016-10-02 01:35:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199442','2016-10-02 01:44:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199443','2016-10-02 01:51:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199444','2016-10-02 01:54:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199445','2016-10-02 02:08:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199446','2016-10-02 02:16:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199448','2016-10-02 02:50:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199449','2016-10-02 02:52:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199452','2016-10-02 03:59:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199453','2016-10-02 05:01:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199455','2016-10-02 05:22:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199459','2016-10-02 06:03:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199460','2016-10-02 06:12:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199461','2016-10-02 06:47:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199462','2016-10-02 06:55:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199467','2016-10-02 07:20:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199468','2016-10-02 07:22:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199469','2016-10-02 07:23:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199471','2016-10-02 07:25:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199486','2016-10-02 08:24:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199487','2016-10-02 08:28:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199491','2016-10-02 08:37:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199493','2016-10-02 08:39:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199495','2016-10-02 08:46:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199496','2016-10-02 08:47:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199499','2016-10-02 09:02:10.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199502','2016-10-02 09:09:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199508','2016-10-02 09:31:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199514','2016-10-02 09:50:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199516','2016-10-02 09:54:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199520','2016-10-02 10:05:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199525','2016-10-02 10:43:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199527','2016-10-02 10:35:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199529','2016-10-02 10:42:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199531','2016-10-02 10:45:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199532','2016-10-02 10:46:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199533','2016-10-02 10:48:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199535','2016-10-02 10:54:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199536','2016-10-02 11:01:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199537','2016-10-02 11:03:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199538','2016-10-02 11:11:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199545','2016-10-02 11:34:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199546','2016-10-02 11:36:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199554','2016-10-02 11:58:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199557','2016-10-02 12:01:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199559','2016-10-02 12:11:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199560','2016-10-02 12:17:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199562','2016-10-02 12:21:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199564','2016-10-02 12:34:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199565','2016-10-02 12:50:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199567','2016-10-02 13:07:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199568','2016-10-02 13:07:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199569','2016-10-02 13:09:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199570','2016-10-02 13:13:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199571','2016-10-02 13:17:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199572','2016-10-02 13:21:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199573','2016-10-02 13:24:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199584','2016-10-02 13:44:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199585','2016-10-02 13:50:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199587','2016-10-02 13:56:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199590','2016-10-02 14:24:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199594','2016-10-02 14:37:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199596','2016-10-02 14:38:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199601','2016-10-02 15:00:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199606','2016-10-02 15:22:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199615','2016-10-02 15:41:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199616','2016-10-02 15:42:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199619','2016-10-02 15:48:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199624','2016-10-02 15:53:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199626','2016-10-02 15:57:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199628','2016-10-02 16:03:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199632','2016-10-02 16:14:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199637','2016-10-02 16:25:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199638','2016-10-02 16:26:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199639','2016-10-02 16:27:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199640','2016-10-02 16:31:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199647','2016-10-02 16:47:10.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199651','2016-10-02 16:54:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199652','2016-10-02 16:57:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199657','2016-10-02 17:28:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199659','2016-10-02 17:41:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199661','2016-10-02 17:48:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199662','2016-10-02 18:12:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199663','2016-10-02 18:19:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199664','2016-10-02 18:21:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199665','2016-10-02 18:38:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199666','2016-10-02 18:47:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199668','2016-10-02 18:53:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199669','2016-10-02 19:00:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199674','2016-10-02 19:16:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199677','2016-10-02 19:24:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199688','2016-10-02 19:37:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199690','2016-10-02 20:08:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199691','2016-10-02 20:13:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199694','2016-10-02 20:35:20.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199695','2016-10-02 20:43:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199696','2016-10-02 21:03:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199697','2016-10-02 21:13:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199699','2016-10-02 21:54:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199700','2016-10-02 21:57:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199701','2016-10-02 22:39:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199702','2016-10-02 23:12:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199703','2016-10-02 23:15:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199705','2016-10-02 23:36:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199706','2016-10-02 23:38:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199708','2016-10-02 23:43:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199709','2016-10-03 00:00:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199710','2016-10-03 00:02:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199711','2016-10-03 00:58:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199712','2016-10-03 01:22:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199715','2016-10-03 02:45:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199717','2016-10-03 03:44:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199718','2016-10-03 04:08:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199719','2016-10-03 04:21:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199724','2016-10-03 04:53:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199725','2016-10-03 05:15:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199727','2016-10-03 06:06:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199728','2016-10-03 06:11:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199729','2016-10-03 06:18:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199732','2016-10-03 06:42:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199736','2016-10-03 06:50:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199737','2016-10-03 06:53:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199739','2016-10-03 06:55:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199774','2016-10-03 07:51:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199778','2016-10-03 07:57:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199822','2016-10-03 08:37:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199856','2016-10-03 08:53:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199868','2016-10-03 09:00:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199903','2016-10-03 09:14:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199938','2016-10-03 09:26:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199944','2016-10-03 09:28:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199957','2016-10-03 09:32:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199966','2016-10-03 09:36:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199974','2016-10-03 09:38:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199977','2016-10-03 09:39:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200001','2016-10-03 09:47:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200008','2016-10-03 09:51:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200016','2016-10-03 09:54:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200040','2016-10-03 10:02:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200067','2016-10-03 10:11:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200085','2016-10-03 10:18:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200091','2016-10-03 10:21:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200102','2016-10-03 10:25:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200114','2016-10-03 10:28:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200146','2016-10-03 10:40:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200157','2016-10-03 10:44:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200208','2016-10-03 11:01:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200215','2016-10-03 11:03:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200226','2016-10-03 11:06:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200228','2016-10-03 11:07:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200231','2016-10-03 11:08:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200237','2016-10-03 11:09:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200240','2016-10-03 11:10:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200254','2016-10-03 11:18:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200307','2016-10-03 11:35:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200315','2016-10-03 11:38:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200339','2016-10-03 11:48:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200342','2016-10-03 11:50:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200385','2016-10-03 12:06:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200395','2016-10-03 12:09:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200396','2016-10-03 12:10:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200422','2016-10-03 12:18:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200442','2016-10-03 12:26:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200444','2016-10-03 12:27:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200469','2016-10-03 12:38:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200470','2016-10-03 12:42:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200481','2016-10-03 12:51:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200492','2016-10-03 12:58:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200496','2016-10-03 13:03:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200509','2016-10-03 13:11:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200519','2016-10-03 13:17:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200530','2016-10-03 13:21:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200532','2016-10-03 13:22:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200535','2016-10-03 13:25:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200539','2016-10-03 13:27:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200546','2016-10-03 13:33:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200550','2016-10-03 13:34:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200557','2016-10-03 13:36:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200568','2016-10-03 13:43:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200585','2016-10-03 13:49:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200586','2016-10-03 13:50:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200595','2016-10-03 13:52:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200608','2016-10-03 14:00:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200632','2016-10-03 14:08:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200694','2016-10-03 14:39:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200706','2016-10-03 14:43:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200712','2016-10-03 14:47:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200722','2016-10-03 14:50:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200796','2016-10-03 15:20:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200822','2016-10-03 15:30:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200858','2016-10-03 15:46:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200872','2016-10-03 15:54:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200924','2016-10-03 16:17:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200939','2016-10-03 16:24:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200960','2016-10-03 16:34:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200961','2016-10-03 16:35:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200963','2016-10-03 16:38:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200971','2016-10-03 16:47:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200978','2016-10-03 16:49:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201012','2016-10-03 17:13:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201027','2016-10-03 17:28:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201037','2016-10-03 17:37:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201049','2016-10-03 17:43:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201051','2016-10-03 17:45:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201054','2016-10-03 17:53:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201066','2016-10-03 18:09:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201072','2016-10-03 18:18:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201074','2016-10-03 18:20:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201075','2016-10-03 18:22:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201076','2016-10-03 18:27:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201081','2016-10-03 18:46:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201082','2016-10-03 18:49:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201094','2016-10-03 19:07:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201096','2016-10-03 19:12:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201098','2016-10-03 19:25:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201100','2016-10-03 19:30:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201101','2016-10-03 19:32:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201105','2016-10-03 19:36:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201106','2016-10-03 19:48:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201107','2016-10-03 19:57:10.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201108','2016-10-03 19:59:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201111','2016-10-03 20:12:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201118','2016-10-03 20:16:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201125','2016-10-03 20:18:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201128','2016-10-03 20:24:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201129','2016-10-03 20:29:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201130','2016-10-03 20:32:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201132','2016-10-03 20:41:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201135','2016-10-03 20:45:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201172','2016-10-03 21:20:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201176','2016-10-03 21:24:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201178','2016-10-03 21:44:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201181','2016-10-03 22:28:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201184','2016-10-03 23:16:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201185','2016-10-03 23:45:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201186','2016-10-03 23:48:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201187','2016-10-04 00:01:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201190','2016-10-04 00:33:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201195','2016-10-04 02:01:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201196','2016-10-04 02:24:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201197','2016-10-04 02:37:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201198','2016-10-04 02:50:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201199','2016-10-04 02:59:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201200','2016-10-04 03:09:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201202','2016-10-04 03:47:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201203','2016-10-04 03:54:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201204','2016-10-04 04:44:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201205','2016-10-04 05:29:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201206','2016-10-04 05:31:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201207','2016-10-04 06:02:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201208','2016-10-04 06:08:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201211','2016-10-04 06:24:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201212','2016-10-04 06:32:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201221','2016-10-04 06:58:20.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201250','2016-10-04 07:57:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201251','2016-10-04 07:57:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201277','2016-10-04 08:24:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201300','2016-10-04 08:36:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201304','2016-10-04 08:38:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201381','2016-10-04 09:13:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201392','2016-10-04 09:19:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201418','2016-10-04 09:29:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201429','2016-10-04 09:34:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201438','2016-10-04 09:37:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201464','2016-10-04 09:47:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201471','2016-10-04 09:50:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201526','2016-10-04 10:13:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201530','2016-10-04 10:16:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201539','2016-10-04 10:19:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201564','2016-10-04 10:28:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201571','2016-10-04 10:31:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201572','2016-10-04 10:31:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201576','2016-10-04 10:33:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201604','2016-10-04 10:45:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201629','2016-10-04 10:55:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201647','2016-10-04 11:05:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201654','2016-10-04 11:10:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201676','2016-10-04 11:18:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201724','2016-10-04 11:31:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201743','2016-10-04 11:37:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201755','2016-10-04 11:40:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201793','2016-10-04 11:55:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201803','2016-10-04 12:03:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201828','2016-10-04 12:17:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201830','2016-10-04 12:19:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201842','2016-10-04 12:26:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201881','2016-10-04 12:51:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201890','2016-10-04 12:55:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201892','2016-10-04 12:56:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201901','2016-10-04 12:59:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201983','2016-10-04 13:44:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201994','2016-10-04 13:49:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202006','2016-10-04 13:54:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202019','2016-10-04 14:01:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202042','2016-10-04 14:15:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202064','2016-10-04 14:25:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202074','2016-10-04 14:28:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202089','2016-10-04 14:35:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202107','2016-10-04 14:41:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202110','2016-10-04 14:43:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202114','2016-10-04 14:46:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202122','2016-10-04 14:50:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202166','2016-10-04 15:06:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202183','2016-10-04 15:15:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202203','2016-10-04 15:27:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202218','2016-10-04 15:38:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202250','2016-10-04 15:52:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202257','2016-10-04 15:58:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202268','2016-10-04 16:03:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202278','2016-10-04 16:09:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202284','2016-10-04 16:11:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202289','2016-10-04 16:14:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202303','2016-10-04 16:24:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202328','2016-10-04 16:37:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202341','2016-10-04 16:40:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202346','2016-10-04 16:43:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202355','2016-10-04 16:48:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202369','2016-10-04 16:55:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202375','2016-10-04 16:58:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202382','2016-10-04 17:05:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202386','2016-10-04 17:08:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202391','2016-10-04 17:11:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202398','2016-10-04 17:15:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202402','2016-10-04 17:18:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202404','2016-10-04 17:19:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202406','2016-10-04 17:21:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202412','2016-10-04 17:25:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202416','2016-10-04 17:30:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202425','2016-10-04 17:37:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202434','2016-10-04 17:46:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202437','2016-10-04 17:53:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202452','2016-10-04 18:12:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202454','2016-10-04 18:14:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202455','2016-10-04 18:16:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202468','2016-10-04 18:36:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202476','2016-10-04 18:55:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202477','2016-10-04 18:54:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202482','2016-10-04 19:03:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202483','2016-10-04 19:04:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202485','2016-10-04 19:06:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202492','2016-10-04 19:14:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202500','2016-10-04 19:21:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202505','2016-10-04 19:24:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202508','2016-10-04 19:28:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202512','2016-10-04 19:33:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202516','2016-10-04 19:35:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202518','2016-10-04 19:35:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202533','2016-10-04 20:02:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202548','2016-10-04 20:12:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202549','2016-10-04 20:14:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202565','2016-10-04 20:26:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202570','2016-10-04 20:32:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202576','2016-10-04 20:42:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202578','2016-10-04 20:47:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202585','2016-10-04 21:10:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202587','2016-10-04 21:17:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202588','2016-10-04 21:32:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202590','2016-10-04 21:37:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202591','2016-10-04 21:45:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202594','2016-10-04 22:06:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202595','2016-10-04 22:24:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202596','2016-10-04 22:27:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202597','2016-10-04 22:39:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202600','2016-10-04 23:06:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202602','2016-10-04 23:15:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202603','2016-10-04 23:18:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202606','2016-10-04 23:36:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202607','2016-10-04 23:38:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202609','2016-10-04 23:46:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202610','2016-10-04 23:56:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202611','2016-10-05 00:06:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202612','2016-10-05 00:28:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202614','2016-10-05 00:54:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202615','2016-10-05 01:22:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202616','2016-10-05 01:57:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202617','2016-10-05 02:36:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202620','2016-10-05 03:08:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202621','2016-10-05 03:44:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202623','2016-10-05 05:02:10.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202627','2016-10-05 06:13:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202628','2016-10-05 06:15:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202630','2016-10-05 06:37:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202641','2016-10-05 07:08:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202642','2016-10-05 07:11:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202652','2016-10-05 07:43:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202706','2016-10-05 08:42:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202792','2016-10-05 09:18:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202821','2016-10-05 09:31:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202898','2016-10-05 10:00:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202904','2016-10-05 10:00:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202946','2016-10-05 10:18:10.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202951','2016-10-05 10:19:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202984','2016-10-05 10:28:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202997','2016-10-05 10:34:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203011','2016-10-05 10:40:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203024','2016-10-05 10:44:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203027','2016-10-05 10:45:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203033','2016-10-05 10:47:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203039','2016-10-05 10:49:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203047','2016-10-05 10:52:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203049','2016-10-05 10:52:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203052','2016-10-05 10:54:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203075','2016-10-05 11:02:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203124','2016-10-05 11:19:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203130','2016-10-05 11:24:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203175','2016-10-05 11:40:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203200','2016-10-05 11:48:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203221','2016-10-05 11:55:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203256','2016-10-05 12:13:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203282','2016-10-05 12:25:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203292','2016-10-05 12:30:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203296','2016-10-05 12:33:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203300','2016-10-05 12:34:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203348','2016-10-05 12:59:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203354','2016-10-05 13:01:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203356','2016-10-05 13:02:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203379','2016-10-05 13:17:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203395','2016-10-05 13:29:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203396','2016-10-05 13:30:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203401','2016-10-05 13:32:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203403','2016-10-05 13:33:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203409','2016-10-05 13:35:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203413','2016-10-05 13:38:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203434','2016-10-05 13:45:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203450','2016-10-05 13:52:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203460','2016-10-05 13:55:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203516','2016-10-05 14:24:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203523','2016-10-05 14:30:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203541','2016-10-05 14:39:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203552','2016-10-05 14:45:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203560','2016-10-05 14:30:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203564','2016-10-05 14:51:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203585','2016-10-05 14:59:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203602','2016-10-05 15:05:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203613','2016-10-05 15:10:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203645','2016-10-05 15:22:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203655','2016-10-05 15:27:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203692','2016-10-05 15:41:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203701','2016-10-05 15:45:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203738','2016-10-05 15:58:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203740','2016-10-05 16:00:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203749','2016-10-05 16:03:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203758','2016-10-05 16:06:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203762','2016-10-05 16:07:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203777','2016-10-05 16:14:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203791','2016-10-05 16:18:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203793','2016-10-05 16:20:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203809','2016-10-05 16:32:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203823','2016-10-05 16:41:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203848','2016-10-05 17:01:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203851','2016-10-05 17:04:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203860','2016-10-05 17:17:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203871','2016-10-05 17:27:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203877','2016-10-05 17:33:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203878','2016-10-05 17:35:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203881','2016-10-05 17:42:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203883','2016-10-05 17:43:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203886','2016-10-05 17:47:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203888','2016-10-05 17:50:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203899','2016-10-05 17:58:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203904','2016-10-05 18:06:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203914','2016-10-05 18:26:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203917','2016-10-05 18:35:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203920','2016-10-05 18:52:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203925','2016-10-05 19:04:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203926','2016-10-05 19:08:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203928','2016-10-05 19:10:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203929','2016-10-05 19:17:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203931','2016-10-05 19:20:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203932','2016-10-05 19:25:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203933','2016-10-05 19:26:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203934','2016-10-05 19:28:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203938','2016-10-05 19:37:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203939','2016-10-05 19:38:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203940','2016-10-05 19:39:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203943','2016-10-05 19:44:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203945','2016-10-05 19:46:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203958','2016-10-05 19:57:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203959','2016-10-05 20:02:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203960','2016-10-05 20:03:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203973','2016-10-05 20:16:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203975','2016-10-05 20:17:20.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203976','2016-10-05 20:19:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203983','2016-10-05 20:28:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203991','2016-10-05 20:37:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203992','2016-10-05 20:40:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203995','2016-10-05 20:46:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203998','2016-10-05 20:48:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204001','2016-10-05 20:50:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204011','2016-10-05 20:57:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204015','2016-10-05 21:00:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204032','2016-10-05 21:12:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204033','2016-10-05 21:13:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204034','2016-10-05 21:15:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204036','2016-10-05 21:21:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204040','2016-10-05 21:46:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204041','2016-10-05 21:56:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204042','2016-10-05 22:13:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204046','2016-10-05 22:50:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204048','2016-10-05 23:04:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204049','2016-10-05 23:08:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204058','2016-10-06 00:06:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204059','2016-10-06 00:13:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204060','2016-10-06 00:16:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204061','2016-10-06 00:18:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204069','2016-10-06 01:43:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204070','2016-10-06 02:07:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204072','2016-10-06 02:42:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204073','2016-10-06 02:45:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204074','2016-10-06 03:16:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204075','2016-10-06 03:43:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204076','2016-10-06 04:19:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204077','2016-10-06 05:36:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204078','2016-10-06 05:48:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204081','2016-10-06 06:30:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204084','2016-10-06 06:35:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204085','2016-10-06 06:40:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204100','2016-10-06 07:08:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204109','2016-10-06 07:15:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204120','2016-10-06 07:27:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204122','2016-10-06 07:34:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204155','2016-10-06 08:10:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204163','2016-10-06 08:13:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204169','2016-10-06 08:15:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204172','2016-10-06 08:17:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204191','2016-10-06 08:36:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204201','2016-10-06 08:39:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204205','2016-10-06 08:41:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204224','2016-10-06 08:49:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204253','2016-10-06 09:04:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204259','2016-10-06 09:07:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204278','2016-10-06 09:15:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204311','2016-10-06 09:27:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204384','2016-10-06 10:04:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204435','2016-10-06 10:27:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204458','2016-10-06 10:36:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204468','2016-10-06 10:41:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204475','2016-10-06 10:45:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204485','2016-10-06 10:46:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204493','2016-10-06 10:51:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204496','2016-10-06 10:53:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204502','2016-10-06 10:56:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204507','2016-10-06 10:58:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204549','2016-10-06 11:16:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204560','2016-10-06 11:20:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204563','2016-10-06 11:22:20.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204597','2016-10-06 11:31:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204635','2016-10-06 11:45:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204657','2016-10-06 11:55:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204678','2016-10-06 12:10:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204694','2016-10-06 12:21:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204698','2016-10-06 12:24:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204717','2016-10-06 12:33:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204721','2016-10-06 12:36:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204733','2016-10-06 12:43:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204735','2016-10-06 12:44:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204785','2016-10-06 13:13:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204791','2016-10-06 13:19:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204877','2016-10-06 13:57:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204881','2016-10-06 13:58:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204893','2016-10-06 14:04:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204901','2016-10-06 14:09:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204903','2016-10-06 14:09:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204912','2016-10-06 14:13:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204934','2016-10-06 14:27:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204939','2016-10-06 14:32:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205017','2016-10-06 14:54:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205022','2016-10-06 14:56:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205023','2016-10-06 14:56:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205040','2016-10-06 15:03:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205046','2016-10-06 15:07:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205064','2016-10-06 15:17:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205075','2016-10-06 15:21:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205095','2016-10-06 15:29:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205120','2016-10-06 15:40:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205125','2016-10-06 15:40:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205140','2016-10-06 15:47:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205163','2016-10-06 15:56:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205168','2016-10-06 15:58:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205186','2016-10-06 16:11:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205196','2016-10-06 16:15:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205211','2016-10-06 16:20:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205231','2016-10-06 16:29:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205274','2016-10-06 16:55:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205285','2016-10-06 17:00:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205302','2016-10-06 17:18:20.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205314','2016-10-06 17:38:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205315','2016-10-06 17:39:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205319','2016-10-06 17:44:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205326','2016-10-06 17:54:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205329','2016-10-06 17:58:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205331','2016-10-06 18:00:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205332','2016-10-06 18:09:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205333','2016-10-06 18:11:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205336','2016-10-06 18:12:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205339','2016-10-06 18:13:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205349','2016-10-06 18:19:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205351','2016-10-06 18:31:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205372','2016-10-06 19:06:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205373','2016-10-06 19:05:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205374','2016-10-06 19:07:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205378','2016-10-06 19:23:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205382','2016-10-06 19:51:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205384','2016-10-06 19:59:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205389','2016-10-06 20:06:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205392','2016-10-06 20:12:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205397','2016-10-06 20:16:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205398','2016-10-06 20:17:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205416','2016-10-06 20:30:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205431','2016-10-06 20:48:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205452','2016-10-06 20:58:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205471','2016-10-06 21:12:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205478','2016-10-06 21:18:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205479','2016-10-06 21:20:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205481','2016-10-06 21:19:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205482','2016-10-06 21:23:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205484','2016-10-06 21:26:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205486','2016-10-06 21:35:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205487','2016-10-06 21:35:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205488','2016-10-06 21:58:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205489','2016-10-06 22:03:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205490','2016-10-06 22:15:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205491','2016-10-06 22:20:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205492','2016-10-06 22:28:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205493','2016-10-06 22:35:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205494','2016-10-06 22:54:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205496','2016-10-06 23:01:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205497','2016-10-06 23:02:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205498','2016-10-06 23:18:20.000')

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148786 More actions · Answer 1

Just cast RegistrationDateTime as time and write your WHERE clause so it returns rows where it's less than '02:00' or greater than '15:00'.

John

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 2

NineIron (11/8/2016)
This data represents visits to our Emergency Room. I need to pull the records for patients that were registered between 3PM and 2AM the next day. Any thoughts?
create table #Test
(AccountNumber varchar(30),
RegistrationDateTime datetime
)
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199071','2016-10-01 01:04:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199073','2016-10-01 02:37:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199075','2016-10-01 02:56:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199076','2016-10-01 03:15:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199079','2016-10-01 04:25:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199080','2016-10-01 04:32:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199082','2016-10-01 05:11:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199083','2016-10-01 05:15:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199084','2016-10-01 05:18:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199092','2016-10-01 06:02:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199093','2016-10-01 06:02:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199094','2016-10-01 06:14:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199095','2016-10-01 06:32:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199098','2016-10-01 07:01:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199100','2016-10-01 07:13:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199107','2016-10-01 07:44:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199119','2016-10-01 08:10:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199151','2016-10-01 08:50:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199152','2016-10-01 08:52:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199160','2016-10-01 09:05:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199161','2016-10-01 09:07:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199163','2016-10-01 09:08:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199169','2016-10-01 09:15:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199174','2016-10-01 09:19:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199193','2016-10-01 09:47:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199198','2016-10-01 09:57:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199199','2016-10-01 09:58:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199203','2016-10-01 10:08:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199204','2016-10-01 10:11:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199206','2016-10-01 10:16:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199209','2016-10-01 10:18:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199219','2016-10-01 10:30:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199220','2016-10-01 10:31:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199222','2016-10-01 10:32:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199232','2016-10-01 10:45:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199244','2016-10-01 11:00:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199253','2016-10-01 11:10:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199255','2016-10-01 11:12:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199269','2016-10-01 11:25:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199271','2016-10-01 11:26:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199273','2016-10-01 11:31:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199278','2016-10-01 11:38:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199279','2016-10-01 11:41:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199285','2016-10-01 11:50:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199288','2016-10-01 11:54:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199289','2016-10-01 11:56:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199290','2016-10-01 11:57:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199292','2016-10-01 11:59:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199294','2016-10-01 12:04:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199295','2016-10-01 12:04:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199296','2016-10-01 12:06:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199298','2016-10-01 12:10:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199299','2016-10-01 12:12:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199300','2016-10-01 12:16:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199304','2016-10-01 12:33:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199309','2016-10-01 12:53:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199310','2016-10-01 13:03:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199314','2016-10-01 13:12:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199317','2016-10-01 13:19:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199319','2016-10-01 13:24:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199322','2016-10-01 13:35:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199325','2016-10-01 13:42:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199326','2016-10-01 13:43:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199327','2016-10-01 13:52:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199329','2016-10-01 13:56:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199330','2016-10-01 14:01:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199342','2016-10-01 14:34:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199343','2016-10-01 14:44:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199346','2016-10-01 15:02:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199347','2016-10-01 15:48:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199348','2016-10-01 15:52:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199349','2016-10-01 15:54:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199352','2016-10-01 16:14:20.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199353','2016-10-01 16:25:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199354','2016-10-01 16:24:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199356','2016-10-01 16:34:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199358','2016-10-01 16:39:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199359','2016-10-01 16:50:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199360','2016-10-01 16:56:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199361','2016-10-01 16:59:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199362','2016-10-01 17:11:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199363','2016-10-01 17:11:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199368','2016-10-01 17:25:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199369','2016-10-01 17:32:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199373','2016-10-01 17:47:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199374','2016-10-01 17:48:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199376','2016-10-01 18:23:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199377','2016-10-01 18:27:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199381','2016-10-01 18:55:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199383','2016-10-01 18:59:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199384','2016-10-01 18:59:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199388','2016-10-01 19:06:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199393','2016-10-01 19:26:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199394','2016-10-01 19:29:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199396','2016-10-01 19:30:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199398','2016-10-01 19:36:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199400','2016-10-01 19:40:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199403','2016-10-01 19:55:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199405','2016-10-01 20:12:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199406','2016-10-01 20:20:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199407','2016-10-01 20:24:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199409','2016-10-01 20:44:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199410','2016-10-01 20:50:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199412','2016-10-01 21:33:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199413','2016-10-01 21:42:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199414','2016-10-01 21:50:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199415','2016-10-01 21:51:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199416','2016-10-01 21:52:10.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199418','2016-10-01 21:57:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199419','2016-10-01 21:57:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199420','2016-10-01 22:05:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199421','2016-10-01 22:07:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199423','2016-10-01 22:36:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199425','2016-10-01 22:46:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199426','2016-10-01 22:53:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199427','2016-10-01 22:57:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199428','2016-10-01 23:10:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199431','2016-10-01 23:29:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199432','2016-10-01 23:35:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199433','2016-10-01 23:43:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199434','2016-10-01 23:51:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199435','2016-10-01 23:55:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199436','2016-10-02 00:04:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199438','2016-10-02 00:30:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199440','2016-10-02 01:32:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199441','2016-10-02 01:35:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199442','2016-10-02 01:44:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199443','2016-10-02 01:51:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199444','2016-10-02 01:54:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199445','2016-10-02 02:08:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199446','2016-10-02 02:16:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199448','2016-10-02 02:50:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199449','2016-10-02 02:52:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199452','2016-10-02 03:59:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199453','2016-10-02 05:01:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199455','2016-10-02 05:22:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199459','2016-10-02 06:03:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199460','2016-10-02 06:12:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199461','2016-10-02 06:47:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199462','2016-10-02 06:55:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199467','2016-10-02 07:20:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199468','2016-10-02 07:22:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199469','2016-10-02 07:23:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199471','2016-10-02 07:25:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199486','2016-10-02 08:24:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199487','2016-10-02 08:28:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199491','2016-10-02 08:37:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199493','2016-10-02 08:39:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199495','2016-10-02 08:46:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199496','2016-10-02 08:47:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199499','2016-10-02 09:02:10.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199502','2016-10-02 09:09:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199508','2016-10-02 09:31:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199514','2016-10-02 09:50:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199516','2016-10-02 09:54:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199520','2016-10-02 10:05:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199525','2016-10-02 10:43:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199527','2016-10-02 10:35:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199529','2016-10-02 10:42:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199531','2016-10-02 10:45:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199532','2016-10-02 10:46:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199533','2016-10-02 10:48:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199535','2016-10-02 10:54:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199536','2016-10-02 11:01:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199537','2016-10-02 11:03:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199538','2016-10-02 11:11:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199545','2016-10-02 11:34:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199546','2016-10-02 11:36:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199554','2016-10-02 11:58:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199557','2016-10-02 12:01:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199559','2016-10-02 12:11:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199560','2016-10-02 12:17:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199562','2016-10-02 12:21:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199564','2016-10-02 12:34:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199565','2016-10-02 12:50:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199567','2016-10-02 13:07:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199568','2016-10-02 13:07:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199569','2016-10-02 13:09:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199570','2016-10-02 13:13:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199571','2016-10-02 13:17:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199572','2016-10-02 13:21:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199573','2016-10-02 13:24:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199584','2016-10-02 13:44:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199585','2016-10-02 13:50:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199587','2016-10-02 13:56:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199590','2016-10-02 14:24:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199594','2016-10-02 14:37:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199596','2016-10-02 14:38:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199601','2016-10-02 15:00:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199606','2016-10-02 15:22:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199615','2016-10-02 15:41:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199616','2016-10-02 15:42:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199619','2016-10-02 15:48:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199624','2016-10-02 15:53:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199626','2016-10-02 15:57:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199628','2016-10-02 16:03:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199632','2016-10-02 16:14:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199637','2016-10-02 16:25:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199638','2016-10-02 16:26:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199639','2016-10-02 16:27:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199640','2016-10-02 16:31:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199647','2016-10-02 16:47:10.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199651','2016-10-02 16:54:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199652','2016-10-02 16:57:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199657','2016-10-02 17:28:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199659','2016-10-02 17:41:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199661','2016-10-02 17:48:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199662','2016-10-02 18:12:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199663','2016-10-02 18:19:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199664','2016-10-02 18:21:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199665','2016-10-02 18:38:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199666','2016-10-02 18:47:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199668','2016-10-02 18:53:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199669','2016-10-02 19:00:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199674','2016-10-02 19:16:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199677','2016-10-02 19:24:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199688','2016-10-02 19:37:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199690','2016-10-02 20:08:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199691','2016-10-02 20:13:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199694','2016-10-02 20:35:20.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199695','2016-10-02 20:43:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199696','2016-10-02 21:03:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199697','2016-10-02 21:13:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199699','2016-10-02 21:54:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199700','2016-10-02 21:57:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199701','2016-10-02 22:39:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199702','2016-10-02 23:12:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199703','2016-10-02 23:15:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199705','2016-10-02 23:36:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199706','2016-10-02 23:38:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199708','2016-10-02 23:43:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199709','2016-10-03 00:00:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199710','2016-10-03 00:02:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199711','2016-10-03 00:58:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199712','2016-10-03 01:22:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199715','2016-10-03 02:45:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199717','2016-10-03 03:44:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199718','2016-10-03 04:08:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199719','2016-10-03 04:21:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199724','2016-10-03 04:53:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199725','2016-10-03 05:15:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199727','2016-10-03 06:06:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199728','2016-10-03 06:11:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199729','2016-10-03 06:18:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199732','2016-10-03 06:42:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199736','2016-10-03 06:50:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199737','2016-10-03 06:53:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199739','2016-10-03 06:55:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199774','2016-10-03 07:51:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199778','2016-10-03 07:57:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199822','2016-10-03 08:37:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199856','2016-10-03 08:53:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199868','2016-10-03 09:00:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199903','2016-10-03 09:14:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199938','2016-10-03 09:26:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199944','2016-10-03 09:28:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199957','2016-10-03 09:32:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199966','2016-10-03 09:36:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199974','2016-10-03 09:38:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090199977','2016-10-03 09:39:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200001','2016-10-03 09:47:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200008','2016-10-03 09:51:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200016','2016-10-03 09:54:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200040','2016-10-03 10:02:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200067','2016-10-03 10:11:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200085','2016-10-03 10:18:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200091','2016-10-03 10:21:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200102','2016-10-03 10:25:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200114','2016-10-03 10:28:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200146','2016-10-03 10:40:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200157','2016-10-03 10:44:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200208','2016-10-03 11:01:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200215','2016-10-03 11:03:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200226','2016-10-03 11:06:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200228','2016-10-03 11:07:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200231','2016-10-03 11:08:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200237','2016-10-03 11:09:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200240','2016-10-03 11:10:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200254','2016-10-03 11:18:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200307','2016-10-03 11:35:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200315','2016-10-03 11:38:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200339','2016-10-03 11:48:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200342','2016-10-03 11:50:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200385','2016-10-03 12:06:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200395','2016-10-03 12:09:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200396','2016-10-03 12:10:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200422','2016-10-03 12:18:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200442','2016-10-03 12:26:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200444','2016-10-03 12:27:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200469','2016-10-03 12:38:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200470','2016-10-03 12:42:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200481','2016-10-03 12:51:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200492','2016-10-03 12:58:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200496','2016-10-03 13:03:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200509','2016-10-03 13:11:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200519','2016-10-03 13:17:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200530','2016-10-03 13:21:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200532','2016-10-03 13:22:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200535','2016-10-03 13:25:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200539','2016-10-03 13:27:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200546','2016-10-03 13:33:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200550','2016-10-03 13:34:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200557','2016-10-03 13:36:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200568','2016-10-03 13:43:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200585','2016-10-03 13:49:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200586','2016-10-03 13:50:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200595','2016-10-03 13:52:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200608','2016-10-03 14:00:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200632','2016-10-03 14:08:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200694','2016-10-03 14:39:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200706','2016-10-03 14:43:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200712','2016-10-03 14:47:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200722','2016-10-03 14:50:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200796','2016-10-03 15:20:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200822','2016-10-03 15:30:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200858','2016-10-03 15:46:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200872','2016-10-03 15:54:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200924','2016-10-03 16:17:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200939','2016-10-03 16:24:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200960','2016-10-03 16:34:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200961','2016-10-03 16:35:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200963','2016-10-03 16:38:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200971','2016-10-03 16:47:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090200978','2016-10-03 16:49:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201012','2016-10-03 17:13:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201027','2016-10-03 17:28:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201037','2016-10-03 17:37:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201049','2016-10-03 17:43:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201051','2016-10-03 17:45:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201054','2016-10-03 17:53:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201066','2016-10-03 18:09:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201072','2016-10-03 18:18:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201074','2016-10-03 18:20:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201075','2016-10-03 18:22:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201076','2016-10-03 18:27:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201081','2016-10-03 18:46:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201082','2016-10-03 18:49:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201094','2016-10-03 19:07:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201096','2016-10-03 19:12:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201098','2016-10-03 19:25:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201100','2016-10-03 19:30:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201101','2016-10-03 19:32:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201105','2016-10-03 19:36:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201106','2016-10-03 19:48:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201107','2016-10-03 19:57:10.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201108','2016-10-03 19:59:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201111','2016-10-03 20:12:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201118','2016-10-03 20:16:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201125','2016-10-03 20:18:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201128','2016-10-03 20:24:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201129','2016-10-03 20:29:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201130','2016-10-03 20:32:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201132','2016-10-03 20:41:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201135','2016-10-03 20:45:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201172','2016-10-03 21:20:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201176','2016-10-03 21:24:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201178','2016-10-03 21:44:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201181','2016-10-03 22:28:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201184','2016-10-03 23:16:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201185','2016-10-03 23:45:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201186','2016-10-03 23:48:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201187','2016-10-04 00:01:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201190','2016-10-04 00:33:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201195','2016-10-04 02:01:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201196','2016-10-04 02:24:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201197','2016-10-04 02:37:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201198','2016-10-04 02:50:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201199','2016-10-04 02:59:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201200','2016-10-04 03:09:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201202','2016-10-04 03:47:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201203','2016-10-04 03:54:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201204','2016-10-04 04:44:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201205','2016-10-04 05:29:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201206','2016-10-04 05:31:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201207','2016-10-04 06:02:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201208','2016-10-04 06:08:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201211','2016-10-04 06:24:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201212','2016-10-04 06:32:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201221','2016-10-04 06:58:20.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201250','2016-10-04 07:57:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201251','2016-10-04 07:57:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201277','2016-10-04 08:24:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201300','2016-10-04 08:36:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201304','2016-10-04 08:38:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201381','2016-10-04 09:13:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201392','2016-10-04 09:19:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201418','2016-10-04 09:29:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201429','2016-10-04 09:34:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201438','2016-10-04 09:37:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201464','2016-10-04 09:47:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201471','2016-10-04 09:50:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201526','2016-10-04 10:13:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201530','2016-10-04 10:16:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201539','2016-10-04 10:19:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201564','2016-10-04 10:28:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201571','2016-10-04 10:31:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201572','2016-10-04 10:31:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201576','2016-10-04 10:33:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201604','2016-10-04 10:45:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201629','2016-10-04 10:55:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201647','2016-10-04 11:05:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201654','2016-10-04 11:10:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201676','2016-10-04 11:18:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201724','2016-10-04 11:31:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201743','2016-10-04 11:37:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201755','2016-10-04 11:40:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201793','2016-10-04 11:55:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201803','2016-10-04 12:03:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201828','2016-10-04 12:17:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201830','2016-10-04 12:19:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201842','2016-10-04 12:26:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201881','2016-10-04 12:51:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201890','2016-10-04 12:55:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201892','2016-10-04 12:56:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201901','2016-10-04 12:59:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201983','2016-10-04 13:44:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090201994','2016-10-04 13:49:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202006','2016-10-04 13:54:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202019','2016-10-04 14:01:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202042','2016-10-04 14:15:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202064','2016-10-04 14:25:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202074','2016-10-04 14:28:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202089','2016-10-04 14:35:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202107','2016-10-04 14:41:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202110','2016-10-04 14:43:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202114','2016-10-04 14:46:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202122','2016-10-04 14:50:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202166','2016-10-04 15:06:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202183','2016-10-04 15:15:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202203','2016-10-04 15:27:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202218','2016-10-04 15:38:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202250','2016-10-04 15:52:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202257','2016-10-04 15:58:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202268','2016-10-04 16:03:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202278','2016-10-04 16:09:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202284','2016-10-04 16:11:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202289','2016-10-04 16:14:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202303','2016-10-04 16:24:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202328','2016-10-04 16:37:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202341','2016-10-04 16:40:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202346','2016-10-04 16:43:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202355','2016-10-04 16:48:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202369','2016-10-04 16:55:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202375','2016-10-04 16:58:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202382','2016-10-04 17:05:56.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202386','2016-10-04 17:08:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202391','2016-10-04 17:11:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202398','2016-10-04 17:15:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202402','2016-10-04 17:18:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202404','2016-10-04 17:19:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202406','2016-10-04 17:21:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202412','2016-10-04 17:25:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202416','2016-10-04 17:30:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202425','2016-10-04 17:37:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202434','2016-10-04 17:46:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202437','2016-10-04 17:53:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202452','2016-10-04 18:12:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202454','2016-10-04 18:14:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202455','2016-10-04 18:16:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202468','2016-10-04 18:36:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202476','2016-10-04 18:55:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202477','2016-10-04 18:54:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202482','2016-10-04 19:03:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202483','2016-10-04 19:04:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202485','2016-10-04 19:06:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202492','2016-10-04 19:14:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202500','2016-10-04 19:21:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202505','2016-10-04 19:24:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202508','2016-10-04 19:28:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202512','2016-10-04 19:33:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202516','2016-10-04 19:35:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202518','2016-10-04 19:35:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202533','2016-10-04 20:02:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202548','2016-10-04 20:12:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202549','2016-10-04 20:14:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202565','2016-10-04 20:26:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202570','2016-10-04 20:32:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202576','2016-10-04 20:42:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202578','2016-10-04 20:47:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202585','2016-10-04 21:10:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202587','2016-10-04 21:17:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202588','2016-10-04 21:32:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202590','2016-10-04 21:37:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202591','2016-10-04 21:45:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202594','2016-10-04 22:06:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202595','2016-10-04 22:24:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202596','2016-10-04 22:27:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202597','2016-10-04 22:39:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202600','2016-10-04 23:06:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202602','2016-10-04 23:15:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202603','2016-10-04 23:18:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202606','2016-10-04 23:36:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202607','2016-10-04 23:38:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202609','2016-10-04 23:46:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202610','2016-10-04 23:56:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202611','2016-10-05 00:06:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202612','2016-10-05 00:28:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202614','2016-10-05 00:54:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202615','2016-10-05 01:22:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202616','2016-10-05 01:57:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202617','2016-10-05 02:36:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202620','2016-10-05 03:08:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202621','2016-10-05 03:44:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202623','2016-10-05 05:02:10.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202627','2016-10-05 06:13:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202628','2016-10-05 06:15:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202630','2016-10-05 06:37:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202641','2016-10-05 07:08:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202642','2016-10-05 07:11:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202652','2016-10-05 07:43:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202706','2016-10-05 08:42:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202792','2016-10-05 09:18:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202821','2016-10-05 09:31:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202898','2016-10-05 10:00:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202904','2016-10-05 10:00:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202946','2016-10-05 10:18:10.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202951','2016-10-05 10:19:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202984','2016-10-05 10:28:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090202997','2016-10-05 10:34:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203011','2016-10-05 10:40:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203024','2016-10-05 10:44:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203027','2016-10-05 10:45:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203033','2016-10-05 10:47:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203039','2016-10-05 10:49:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203047','2016-10-05 10:52:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203049','2016-10-05 10:52:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203052','2016-10-05 10:54:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203075','2016-10-05 11:02:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203124','2016-10-05 11:19:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203130','2016-10-05 11:24:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203175','2016-10-05 11:40:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203200','2016-10-05 11:48:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203221','2016-10-05 11:55:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203256','2016-10-05 12:13:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203282','2016-10-05 12:25:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203292','2016-10-05 12:30:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203296','2016-10-05 12:33:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203300','2016-10-05 12:34:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203348','2016-10-05 12:59:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203354','2016-10-05 13:01:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203356','2016-10-05 13:02:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203379','2016-10-05 13:17:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203395','2016-10-05 13:29:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203396','2016-10-05 13:30:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203401','2016-10-05 13:32:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203403','2016-10-05 13:33:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203409','2016-10-05 13:35:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203413','2016-10-05 13:38:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203434','2016-10-05 13:45:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203450','2016-10-05 13:52:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203460','2016-10-05 13:55:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203516','2016-10-05 14:24:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203523','2016-10-05 14:30:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203541','2016-10-05 14:39:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203552','2016-10-05 14:45:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203560','2016-10-05 14:30:00.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203564','2016-10-05 14:51:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203585','2016-10-05 14:59:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203602','2016-10-05 15:05:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203613','2016-10-05 15:10:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203645','2016-10-05 15:22:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203655','2016-10-05 15:27:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203692','2016-10-05 15:41:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203701','2016-10-05 15:45:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203738','2016-10-05 15:58:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203740','2016-10-05 16:00:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203749','2016-10-05 16:03:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203758','2016-10-05 16:06:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203762','2016-10-05 16:07:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203777','2016-10-05 16:14:26.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203791','2016-10-05 16:18:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203793','2016-10-05 16:20:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203809','2016-10-05 16:32:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203823','2016-10-05 16:41:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203848','2016-10-05 17:01:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203851','2016-10-05 17:04:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203860','2016-10-05 17:17:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203871','2016-10-05 17:27:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203877','2016-10-05 17:33:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203878','2016-10-05 17:35:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203881','2016-10-05 17:42:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203883','2016-10-05 17:43:58.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203886','2016-10-05 17:47:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203888','2016-10-05 17:50:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203899','2016-10-05 17:58:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203904','2016-10-05 18:06:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203914','2016-10-05 18:26:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203917','2016-10-05 18:35:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203920','2016-10-05 18:52:17.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203925','2016-10-05 19:04:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203926','2016-10-05 19:08:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203928','2016-10-05 19:10:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203929','2016-10-05 19:17:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203931','2016-10-05 19:20:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203932','2016-10-05 19:25:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203933','2016-10-05 19:26:12.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203934','2016-10-05 19:28:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203938','2016-10-05 19:37:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203939','2016-10-05 19:38:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203940','2016-10-05 19:39:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203943','2016-10-05 19:44:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203945','2016-10-05 19:46:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203958','2016-10-05 19:57:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203959','2016-10-05 20:02:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203960','2016-10-05 20:03:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203973','2016-10-05 20:16:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203975','2016-10-05 20:17:20.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203976','2016-10-05 20:19:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203983','2016-10-05 20:28:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203991','2016-10-05 20:37:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203992','2016-10-05 20:40:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203995','2016-10-05 20:46:30.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090203998','2016-10-05 20:48:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204001','2016-10-05 20:50:09.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204011','2016-10-05 20:57:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204015','2016-10-05 21:00:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204032','2016-10-05 21:12:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204033','2016-10-05 21:13:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204034','2016-10-05 21:15:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204036','2016-10-05 21:21:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204040','2016-10-05 21:46:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204041','2016-10-05 21:56:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204042','2016-10-05 22:13:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204046','2016-10-05 22:50:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204048','2016-10-05 23:04:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204049','2016-10-05 23:08:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204058','2016-10-06 00:06:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204059','2016-10-06 00:13:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204060','2016-10-06 00:16:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204061','2016-10-06 00:18:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204069','2016-10-06 01:43:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204070','2016-10-06 02:07:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204072','2016-10-06 02:42:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204073','2016-10-06 02:45:06.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204074','2016-10-06 03:16:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204075','2016-10-06 03:43:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204076','2016-10-06 04:19:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204077','2016-10-06 05:36:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204078','2016-10-06 05:48:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204081','2016-10-06 06:30:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204084','2016-10-06 06:35:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204085','2016-10-06 06:40:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204100','2016-10-06 07:08:39.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204109','2016-10-06 07:15:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204120','2016-10-06 07:27:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204122','2016-10-06 07:34:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204155','2016-10-06 08:10:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204163','2016-10-06 08:13:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204169','2016-10-06 08:15:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204172','2016-10-06 08:17:29.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204191','2016-10-06 08:36:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204201','2016-10-06 08:39:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204205','2016-10-06 08:41:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204224','2016-10-06 08:49:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204253','2016-10-06 09:04:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204259','2016-10-06 09:07:28.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204278','2016-10-06 09:15:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204311','2016-10-06 09:27:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204384','2016-10-06 10:04:48.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204435','2016-10-06 10:27:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204458','2016-10-06 10:36:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204468','2016-10-06 10:41:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204475','2016-10-06 10:45:36.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204485','2016-10-06 10:46:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204493','2016-10-06 10:51:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204496','2016-10-06 10:53:25.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204502','2016-10-06 10:56:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204507','2016-10-06 10:58:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204549','2016-10-06 11:16:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204560','2016-10-06 11:20:59.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204563','2016-10-06 11:22:20.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204597','2016-10-06 11:31:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204635','2016-10-06 11:45:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204657','2016-10-06 11:55:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204678','2016-10-06 12:10:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204694','2016-10-06 12:21:41.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204698','2016-10-06 12:24:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204717','2016-10-06 12:33:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204721','2016-10-06 12:36:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204733','2016-10-06 12:43:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204735','2016-10-06 12:44:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204785','2016-10-06 13:13:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204791','2016-10-06 13:19:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204877','2016-10-06 13:57:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204881','2016-10-06 13:58:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204893','2016-10-06 14:04:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204901','2016-10-06 14:09:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204903','2016-10-06 14:09:02.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204912','2016-10-06 14:13:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204934','2016-10-06 14:27:31.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090204939','2016-10-06 14:32:27.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205017','2016-10-06 14:54:16.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205022','2016-10-06 14:56:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205023','2016-10-06 14:56:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205040','2016-10-06 15:03:51.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205046','2016-10-06 15:07:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205064','2016-10-06 15:17:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205075','2016-10-06 15:21:38.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205095','2016-10-06 15:29:15.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205120','2016-10-06 15:40:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205125','2016-10-06 15:40:24.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205140','2016-10-06 15:47:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205163','2016-10-06 15:56:21.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205168','2016-10-06 15:58:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205186','2016-10-06 16:11:22.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205196','2016-10-06 16:15:19.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205211','2016-10-06 16:20:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205231','2016-10-06 16:29:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205274','2016-10-06 16:55:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205285','2016-10-06 17:00:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205302','2016-10-06 17:18:20.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205314','2016-10-06 17:38:07.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205315','2016-10-06 17:39:43.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205319','2016-10-06 17:44:42.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205326','2016-10-06 17:54:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205329','2016-10-06 17:58:11.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205331','2016-10-06 18:00:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205332','2016-10-06 18:09:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205333','2016-10-06 18:11:35.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205336','2016-10-06 18:12:04.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205339','2016-10-06 18:13:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205349','2016-10-06 18:19:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205351','2016-10-06 18:31:44.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205372','2016-10-06 19:06:08.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205373','2016-10-06 19:05:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205374','2016-10-06 19:07:50.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205378','2016-10-06 19:23:55.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205382','2016-10-06 19:51:52.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205384','2016-10-06 19:59:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205389','2016-10-06 20:06:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205392','2016-10-06 20:12:14.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205397','2016-10-06 20:16:03.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205398','2016-10-06 20:17:53.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205416','2016-10-06 20:30:05.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205431','2016-10-06 20:48:33.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205452','2016-10-06 20:58:13.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205471','2016-10-06 21:12:49.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205478','2016-10-06 21:18:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205479','2016-10-06 21:20:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205481','2016-10-06 21:19:46.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205482','2016-10-06 21:23:37.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205484','2016-10-06 21:26:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205486','2016-10-06 21:35:18.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205487','2016-10-06 21:35:54.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205488','2016-10-06 21:58:01.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205489','2016-10-06 22:03:45.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205490','2016-10-06 22:15:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205491','2016-10-06 22:20:57.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205492','2016-10-06 22:28:40.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205493','2016-10-06 22:35:47.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205494','2016-10-06 22:54:32.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205496','2016-10-06 23:01:34.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205497','2016-10-06 23:02:23.000')
insert into #Test(AccountNumber, RegistrationDateTime) values('F00090205498','2016-10-06 23:18:20.000')

So what have you done to try and solve this problem?

NineIron SSChampion Points: 12529 More actions · Answer 3

Here's my where clause, "where convert(time, t.RegistrationDateTime, 121)>='15:00:00.0000000' and convert(time, t.RegistrationDateTime, 121)<'02:00:00.0000000'".

I didn't get any results but, if I run the query with '22:00:00.0000000', I get results.

Luis Cazares SSC Guru Points: 183686 More actions · Answer 4

Something like this?

DECLARE @Date datetime = '20161002';

SELECT *

FROM #Test

WHERE RegistrationDateTime >= DATEADD( HH, 15, @Date)

AND RegistrationDateTime < DATEADD( HH, 26, @Date)

ORDER BY RegistrationDateTime

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

NineIron SSChampion Points: 12529 More actions · Answer 5

NineIron

SSChampion

Points: 12529

November 8, 2016 at 10:41 am

#1911247

Where would I get the value for @Date?

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 6

NineIron (11/8/2016)
Here's my where clause, "where convert(time, t.RegistrationDateTime, 121)>='15:00:00.0000000' and convert(time, t.RegistrationDateTime, 121)<'02:00:00.0000000'".
I didn't get any results but, if I run the query with '22:00:00.0000000', I get results.

How about posting the entire query. Also, what date are you looking for the data between or are you looking for the data between 15:00 and 02:00 for all available dates?

Luis Cazares SSC Guru Points: 183686 More actions · Answer 7

NineIron (11/8/2016)
Where would I get the value for @Date?

How would I know? You're the one asking for "patients that were registered between 3PM and 2AM the next day."

I assumed you wanted data for a specific day. Otherwise, just change your condition to "OR" as you're defining 2 mutually exclusive conditions.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

NineIron SSChampion Points: 12529 More actions · Answer 8

The temp table #Data is essentially #Test in my sample data. So, I want to get the number of visits that occur between 3PM and 2AM. It doesn't matter what day. This query, which you folks helped me with, will pull the number of visits for the week, with the week ending on Friday.

selectWeekEnding,

count(*) as TotalVisits_3To2

--into #WeekEndingCountTotal_3To2

from #Data t

cross apply (

select 4 as Friday /*0=Mon,...,6=Sun*/

) as which_day_of_week

cross apply (

select CAST(DATEADD(DAY, -DATEDIFF(DAY, Friday, t.RegistrationDateTime) % 7 + 7, t.RegistrationDateTime) AS date) AS WeekEnding

) as assign_alias_names

where convert(time, t.RegistrationDateTime, 121)>='15:00:00.0000000' and convert(time, t.RegistrationDateTime, 121)<'02:00:00.0000000'

group by WeekEnding

Luis Cazares SSC Guru Points: 183686 More actions · Answer 9

I repeat, change your AND into an OR.

Or change the time to make them all in the same day.

selectWeekEnding,

count(*) as TotalVisits_3To2

--into #WeekEndingCountTotal_3To2

from #Test t

cross apply (

select 4 as Friday /*0=Mon,...,6=Sun*/

) as which_day_of_week

cross apply (

select CAST(DATEADD(DAY, -DATEDIFF(DAY, Friday, t.RegistrationDateTime) % 7 + 7, t.RegistrationDateTime) AS date) AS WeekEnding

) as assign_alias_names

where DATEPART( HH, DATEADD(HH, -2, t.RegistrationDateTime)) >= 13

group by WeekEnding;

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 10

Luis Cazares (11/8/2016)
NineIron (11/8/2016)
Where would I get the value for @Date?
How would I know? You're the one asking for "patients that were registered between 3PM and 2AM the next day."
I assumed you wanted data for a specific day. Otherwise, just change your condition to "OR" as you're defining 2 mutually exclusive conditions.

I don't see how this works against your sample data.

Based on your sample data, what are you looking for as a result?

NineIron SSChampion Points: 12529 More actions · Answer 11

NineIron

SSChampion

Points: 12529

November 8, 2016 at 11:22 am

#1911258

I get it now. Thanx for your patience.

NineIron SSChampion Points: 12529 More actions · Answer 12

WeekEndingTotalVisits_3To2

2015-08-071

2015-09-111

2015-09-181

2015-09-255

2015-10-02172

2015-10-09608

2015-10-16611

2015-10-23634

2015-10-30636

2015-11-06602

2015-11-13592

2015-11-20562

2015-11-27594

2015-12-04620

2015-12-11639

2015-12-18634

2015-12-25608

2016-01-01551

2016-01-08633

2016-01-15601

2016-01-22586

2016-01-29595

2016-02-05636

2016-02-12614

2016-02-19638

2016-02-26673

2016-03-04665

2016-03-11682

2016-03-18655

2016-03-25609

2016-04-01603

2016-04-08392

2016-04-15386

2016-04-22429

2016-04-29481

2016-05-06432

2016-05-13451

2016-05-20473

2016-05-27472

2016-06-03442

2016-06-10439

2016-06-17452

2016-06-24431

2016-07-01439

2016-07-08466

2016-07-15448

2016-07-22487

2016-07-29430

2016-08-05444

2016-08-12458

2016-08-19470

2016-08-26440

2016-09-02436

2016-09-09464

2016-09-16438

2016-09-23489

2016-09-30444

2016-10-07425

2016-10-14430

2016-10-21395

2016-10-28388

2016-11-04422

2016-11-11235