-
Notifications
You must be signed in to change notification settings - Fork 9
Expand file tree
/
Copy pathThirdTable.sql
More file actions
2033 lines (2030 loc) · 238 KB
/
Copy pathThirdTable.sql
File metadata and controls
2033 lines (2030 loc) · 238 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
USE [70-761]
IF EXISTS(SELECT 1 FROM sys.tables WHERE name = 'Transactions')
DROP TABLE Transactions
CREATE TABLE Transactions
(
Amount smallmoney NOT NULL,
TransactionDate date NOT NULL,
PersonID int NULL
)
GO
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (849.6800, CAST(N'2017-03-07' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (64.2100, CAST(N'2013-09-16' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (426.3500, CAST(N'2015-09-23' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (878.2600, CAST(N'2012-02-07' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (940.5200, CAST(N'2017-07-04' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (543.4300, CAST(N'2018-04-02' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (403.7900, CAST(N'2012-10-22' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (76.8500, CAST(N'2009-12-22' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (681.0100, CAST(N'2019-07-24' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (28.6100, CAST(N'2019-01-07' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (34.8500, CAST(N'2009-01-02' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (368.2500, CAST(N'2007-01-05' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (139.3300, CAST(N'2011-12-02' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (27.3700, CAST(N'2015-11-09' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (752.6500, CAST(N'2018-02-20' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (659.2300, CAST(N'2019-05-10' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (941.6400, CAST(N'2008-06-10' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (798.9600, CAST(N'2011-08-30' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (202.8700, CAST(N'2016-12-09' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (651.8800, CAST(N'2008-11-12' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (314.4500, CAST(N'2010-06-29' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (965.7300, CAST(N'2009-08-05' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (676.6600, CAST(N'2007-06-14' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (826.4800, CAST(N'2011-02-16' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (715.4600, CAST(N'2011-01-31' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (341.5200, CAST(N'2013-01-30' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (156.0200, CAST(N'2014-01-02' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (999.6300, CAST(N'2008-08-29' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (526.5500, CAST(N'2017-01-30' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (688.5600, CAST(N'2009-04-17' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (434.7200, CAST(N'2019-06-25' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (889.6700, CAST(N'2016-09-16' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (367.7400, CAST(N'2011-09-29' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (531.8000, CAST(N'2008-07-07' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (260.5000, CAST(N'2014-09-19' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (969.6300, CAST(N'2010-03-24' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (99.1700, CAST(N'2008-07-30' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (477.1600, CAST(N'2012-03-21' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (719.5800, CAST(N'2007-07-25' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (370.9000, CAST(N'2007-01-24' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (210.9900, CAST(N'2011-03-08' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (828.9300, CAST(N'2009-04-01' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (831.1300, CAST(N'2009-01-19' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (993.8100, CAST(N'2013-10-28' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (168.0300, CAST(N'2008-01-01' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (74.8200, CAST(N'2009-01-07' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (945.2000, CAST(N'2015-03-23' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (759.8600, CAST(N'2017-09-25' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (509.2700, CAST(N'2008-01-31' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (649.0900, CAST(N'2009-11-17' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (216.5500, CAST(N'2018-09-10' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (26.2200, CAST(N'2010-10-26' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (889.2900, CAST(N'2017-05-19' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (553.6700, CAST(N'2012-05-11' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (700.1400, CAST(N'2018-07-19' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (767.2900, CAST(N'2019-10-08' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (768.7900, CAST(N'2013-12-19' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (198.1700, CAST(N'2019-10-15' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (44.0600, CAST(N'2008-09-23' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (750.0600, CAST(N'2018-03-30' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (593.9900, CAST(N'2010-08-30' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (794.1100, CAST(N'2018-08-07' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (211.0100, CAST(N'2010-05-14' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (251.8500, CAST(N'2015-01-05' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (611.7600, CAST(N'2012-05-21' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (528.4400, CAST(N'2012-11-22' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (698.9300, CAST(N'2015-12-22' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (217.0200, CAST(N'2014-02-19' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (955.2100, CAST(N'2008-10-02' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (67.0600, CAST(N'2010-12-01' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (953.8400, CAST(N'2013-05-28' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (412.5200, CAST(N'2007-03-07' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (962.0100, CAST(N'2016-02-04' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (4.1500, CAST(N'2013-10-15' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (722.4700, CAST(N'2010-12-15' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (933.7800, CAST(N'2010-08-04' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (69.3700, CAST(N'2018-12-03' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (734.7200, CAST(N'2016-03-22' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (663.5700, CAST(N'2019-12-20' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (116.6300, CAST(N'2010-02-12' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (124.3900, CAST(N'2017-11-13' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (781.4800, CAST(N'2009-10-30' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (61.7900, CAST(N'2008-07-25' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (985.5700, CAST(N'2015-04-06' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (604.7000, CAST(N'2017-03-23' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (823.7700, CAST(N'2016-11-22' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (102.0200, CAST(N'2016-11-28' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (655.7800, CAST(N'2009-03-27' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (338.0300, CAST(N'2015-08-14' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (237.7000, CAST(N'2019-07-24' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (746.6200, CAST(N'2017-10-18' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (516.2400, CAST(N'2019-09-24' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (882.9900, CAST(N'2014-03-26' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (638.6100, CAST(N'2008-01-31' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (966.3000, CAST(N'2012-07-11' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (407.5400, CAST(N'2019-09-20' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (967.9500, CAST(N'2015-10-12' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (685.2600, CAST(N'2019-10-02' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (414.3800, CAST(N'2018-06-05' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (56.6900, CAST(N'2013-07-17' AS Date), 10)
GO
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (69.2500, CAST(N'2010-12-21' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (239.4400, CAST(N'2007-04-10' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (14.6700, CAST(N'2015-10-29' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (321.7400, CAST(N'2015-05-28' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (976.6400, CAST(N'2007-01-09' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (997.9800, CAST(N'2013-07-09' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (214.2900, CAST(N'2016-03-30' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (403.6500, CAST(N'2015-03-09' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (973.8300, CAST(N'2010-07-09' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (692.0400, CAST(N'2014-01-30' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (33.5200, CAST(N'2008-12-10' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (883.9800, CAST(N'2018-01-12' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (952.6700, CAST(N'2015-06-26' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (778.9300, CAST(N'2019-07-11' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (195.9700, CAST(N'2012-06-18' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (150.4000, CAST(N'2013-05-17' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (125.5600, CAST(N'2007-01-05' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (261.9200, CAST(N'2014-11-14' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (687.9000, CAST(N'2009-11-24' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (452.0200, CAST(N'2019-10-17' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (877.9800, CAST(N'2010-01-14' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (994.5500, CAST(N'2015-10-15' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (12.8600, CAST(N'2015-07-23' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (61.3700, CAST(N'2018-03-29' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (105.3400, CAST(N'2015-10-13' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (850.6000, CAST(N'2007-03-26' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (918.4200, CAST(N'2007-06-25' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (869.5300, CAST(N'2008-12-10' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (948.6800, CAST(N'2017-07-19' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (280.3800, CAST(N'2010-05-03' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (261.5800, CAST(N'2012-06-29' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (437.9000, CAST(N'2016-10-14' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (269.2300, CAST(N'2015-01-05' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (649.8800, CAST(N'2013-10-15' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (90.2200, CAST(N'2016-10-18' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (17.3600, CAST(N'2017-06-28' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (496.6000, CAST(N'2016-06-27' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (89.4800, CAST(N'2008-05-13' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (75.8200, CAST(N'2015-07-27' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (182.7200, CAST(N'2010-07-22' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (994.9100, CAST(N'2012-06-05' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (7.7400, CAST(N'2015-09-25' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (407.3000, CAST(N'2020-01-13' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (49.1700, CAST(N'2018-05-31' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (631.4300, CAST(N'2017-04-28' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (388.0000, CAST(N'2017-12-25' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (599.2000, CAST(N'2008-07-09' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (423.4800, CAST(N'2010-10-04' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (796.5400, CAST(N'2017-11-09' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (955.8200, CAST(N'2015-12-30' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (80.0300, CAST(N'2009-01-19' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (269.8900, CAST(N'2016-03-03' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (371.2000, CAST(N'2016-07-06' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (609.4800, CAST(N'2017-04-12' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (844.4400, CAST(N'2018-05-07' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (488.6200, CAST(N'2011-11-15' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (426.0600, CAST(N'2019-01-11' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (148.5000, CAST(N'2019-12-31' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (955.6300, CAST(N'2013-04-15' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (402.3800, CAST(N'2014-01-30' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (738.4900, CAST(N'2015-08-24' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (217.5400, CAST(N'2007-05-22' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (846.2700, CAST(N'2017-08-18' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (92.6000, CAST(N'2007-05-16' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (443.5000, CAST(N'2016-12-09' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (478.4900, CAST(N'2019-03-08' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (396.2400, CAST(N'2008-06-13' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (668.8500, CAST(N'2010-12-24' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (790.7600, CAST(N'2018-09-26' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (857.7300, CAST(N'2017-10-25' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (232.0600, CAST(N'2016-05-10' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (396.2300, CAST(N'2011-08-30' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (245.0900, CAST(N'2007-11-15' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (685.3700, CAST(N'2007-06-21' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (778.0700, CAST(N'2009-04-15' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (93.8200, CAST(N'2011-09-13' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (343.6900, CAST(N'2015-04-27' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (563.1600, CAST(N'2018-07-06' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (31.5200, CAST(N'2018-01-19' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (594.8700, CAST(N'2016-06-23' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (224.2700, CAST(N'2019-05-15' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (314.5100, CAST(N'2018-10-17' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (876.6200, CAST(N'2009-07-10' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (97.4700, CAST(N'2008-10-31' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (725.8400, CAST(N'2012-09-13' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (330.0100, CAST(N'2014-03-20' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (606.8700, CAST(N'2018-10-31' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (313.3300, CAST(N'2019-01-14' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (727.4800, CAST(N'2007-08-13' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (325.0300, CAST(N'2017-05-15' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (270.6900, CAST(N'2014-06-26' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (413.1700, CAST(N'2011-11-25' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (290.2000, CAST(N'2016-05-27' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (904.3700, CAST(N'2007-01-30' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (576.1800, CAST(N'2007-08-02' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (199.3100, CAST(N'2015-02-06' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (577.0400, CAST(N'2011-11-18' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (463.9300, CAST(N'2019-09-06' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (591.2700, CAST(N'2016-08-17' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (285.3300, CAST(N'2016-07-27' AS Date), 2)
GO
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (565.0000, CAST(N'2010-06-10' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (259.1100, CAST(N'2014-05-21' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (667.3200, CAST(N'2012-12-14' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (80.6700, CAST(N'2013-09-02' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (836.5200, CAST(N'2018-04-12' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (236.6800, CAST(N'2019-05-07' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (294.0200, CAST(N'2018-03-15' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (824.1900, CAST(N'2010-05-04' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (915.8400, CAST(N'2019-04-01' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (112.5400, CAST(N'2010-06-10' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (240.6000, CAST(N'2009-07-07' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (491.9000, CAST(N'2014-02-18' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (381.0400, CAST(N'2007-11-22' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (631.4800, CAST(N'2011-05-10' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (62.7700, CAST(N'2013-04-24' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (633.6600, CAST(N'2019-10-25' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (482.1400, CAST(N'2009-03-10' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (167.4100, CAST(N'2012-02-13' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (483.2600, CAST(N'2018-03-16' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (330.7800, CAST(N'2008-07-16' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (114.8600, CAST(N'2017-06-27' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (820.6600, CAST(N'2011-10-27' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (72.9500, CAST(N'2017-02-03' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (906.5700, CAST(N'2015-12-29' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (206.6100, CAST(N'2007-08-27' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (71.2600, CAST(N'2018-11-01' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (279.1300, CAST(N'2014-05-23' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (290.0100, CAST(N'2009-07-10' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (710.3500, CAST(N'2015-12-23' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (830.5800, CAST(N'2018-06-25' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (769.3900, CAST(N'2015-11-30' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (176.8500, CAST(N'2012-01-05' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (494.1000, CAST(N'2012-05-01' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (886.7700, CAST(N'2017-12-29' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (68.2600, CAST(N'2008-01-23' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (321.5800, CAST(N'2011-09-07' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (701.7200, CAST(N'2018-09-28' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (469.3100, CAST(N'2008-09-02' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (274.0000, CAST(N'2017-09-20' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (75.4100, CAST(N'2017-03-14' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (104.1000, CAST(N'2016-09-22' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (517.1700, CAST(N'2009-10-08' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (779.6900, CAST(N'2007-03-21' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (815.3900, CAST(N'2013-08-20' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (272.4500, CAST(N'2007-08-15' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (633.5600, CAST(N'2008-06-09' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (326.3100, CAST(N'2015-11-09' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (168.5000, CAST(N'2019-07-29' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (112.8900, CAST(N'2017-04-19' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (844.5900, CAST(N'2007-08-27' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (453.1400, CAST(N'2007-07-23' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (30.4500, CAST(N'2009-10-02' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (467.1800, CAST(N'2018-11-27' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (898.6600, CAST(N'2009-07-15' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (801.0000, CAST(N'2019-05-07' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (695.1400, CAST(N'2007-11-07' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (895.6200, CAST(N'2010-11-25' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (913.3000, CAST(N'2017-07-06' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (584.4700, CAST(N'2011-02-25' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (428.9400, CAST(N'2011-10-11' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (987.0100, CAST(N'2012-09-12' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (521.4600, CAST(N'2011-01-12' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (523.6000, CAST(N'2011-03-07' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (339.3600, CAST(N'2007-07-13' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (722.2500, CAST(N'2013-10-28' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (364.0100, CAST(N'2011-04-01' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (576.3200, CAST(N'2008-05-05' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (335.9500, CAST(N'2008-12-01' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (617.3500, CAST(N'2015-09-11' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (967.5900, CAST(N'2013-06-04' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (550.9500, CAST(N'2012-05-02' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (226.0500, CAST(N'2019-01-25' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (372.8800, CAST(N'2018-02-07' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (862.1200, CAST(N'2007-10-15' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (650.1000, CAST(N'2013-04-12' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (381.0900, CAST(N'2013-12-02' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (997.3100, CAST(N'2007-05-09' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (62.8300, CAST(N'2009-08-17' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (41.0600, CAST(N'2012-04-10' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (783.2200, CAST(N'2018-08-22' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (138.0000, CAST(N'2009-06-17' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (274.7200, CAST(N'2014-04-29' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (46.8400, CAST(N'2010-01-06' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (542.3300, CAST(N'2007-03-08' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (985.8400, CAST(N'2008-08-22' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (129.9400, CAST(N'2017-07-19' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (411.6200, CAST(N'2015-03-11' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (732.4200, CAST(N'2009-06-19' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (514.4400, CAST(N'2011-07-15' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (782.1000, CAST(N'2015-08-11' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (645.6900, CAST(N'2013-12-24' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (213.2100, CAST(N'2009-06-17' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (725.8200, CAST(N'2013-05-27' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (602.2400, CAST(N'2012-05-21' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (165.6300, CAST(N'2012-02-10' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (36.4900, CAST(N'2011-08-24' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (573.5900, CAST(N'2016-02-16' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (727.8100, CAST(N'2018-11-07' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (835.3500, CAST(N'2016-06-14' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (237.8200, CAST(N'2012-03-26' AS Date), 0)
GO
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (595.0200, CAST(N'2016-07-01' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (508.8700, CAST(N'2015-02-13' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (759.5400, CAST(N'2017-12-01' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (141.9300, CAST(N'2008-11-03' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (303.1100, CAST(N'2017-08-16' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (357.0100, CAST(N'2012-04-16' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (388.3400, CAST(N'2018-05-16' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (727.6100, CAST(N'2008-06-24' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (894.7600, CAST(N'2015-12-07' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (471.9900, CAST(N'2009-06-05' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (664.8900, CAST(N'2017-04-28' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (788.2200, CAST(N'2018-09-14' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (406.2900, CAST(N'2010-04-08' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (77.0000, CAST(N'2016-03-21' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (4.1000, CAST(N'2015-11-13' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (9.8500, CAST(N'2011-02-18' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (325.9600, CAST(N'2009-11-04' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (188.1200, CAST(N'2016-08-02' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (929.3500, CAST(N'2018-10-30' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (747.6800, CAST(N'2013-01-24' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (456.9400, CAST(N'2012-08-02' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (921.4600, CAST(N'2009-01-02' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (334.2600, CAST(N'2014-10-08' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (74.2600, CAST(N'2007-08-09' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (745.8500, CAST(N'2016-06-15' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (511.4600, CAST(N'2015-08-03' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (918.3500, CAST(N'2013-07-25' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (450.5700, CAST(N'2014-06-09' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (683.7700, CAST(N'2018-09-25' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (293.8600, CAST(N'2014-12-17' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (534.0600, CAST(N'2017-12-13' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (659.6200, CAST(N'2008-08-14' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (934.7300, CAST(N'2008-07-29' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (607.2800, CAST(N'2009-10-22' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (429.7200, CAST(N'2007-04-02' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (13.8300, CAST(N'2008-06-09' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (490.5900, CAST(N'2007-01-30' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (530.7600, CAST(N'2011-08-11' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (805.2400, CAST(N'2017-09-04' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (794.8000, CAST(N'2018-08-01' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (372.8300, CAST(N'2012-05-08' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (811.7200, CAST(N'2018-10-31' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (58.6200, CAST(N'2010-12-20' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (40.5800, CAST(N'2015-10-15' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (206.7700, CAST(N'2008-11-05' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (736.7800, CAST(N'2008-10-09' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (998.2800, CAST(N'2015-03-03' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (592.2000, CAST(N'2010-10-27' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (52.4000, CAST(N'2016-12-26' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (162.7800, CAST(N'2008-04-29' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (30.3600, CAST(N'2017-06-07' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (82.3900, CAST(N'2016-06-06' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (558.1100, CAST(N'2007-08-30' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (883.7600, CAST(N'2013-05-14' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (445.2200, CAST(N'2017-01-27' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (58.3800, CAST(N'2011-05-27' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (247.7500, CAST(N'2018-11-09' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (2.7900, CAST(N'2014-11-27' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (276.4600, CAST(N'2011-11-08' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (82.7000, CAST(N'2008-04-24' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (883.3400, CAST(N'2018-05-24' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (796.7400, CAST(N'2009-04-16' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (18.1000, CAST(N'2010-03-12' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (555.1400, CAST(N'2018-05-08' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (651.4700, CAST(N'2017-05-04' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (704.8800, CAST(N'2019-02-20' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (537.6400, CAST(N'2013-06-20' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (815.6400, CAST(N'2014-11-20' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (979.0600, CAST(N'2012-03-30' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (308.0200, CAST(N'2018-07-31' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (253.3700, CAST(N'2007-11-28' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (964.9200, CAST(N'2017-09-29' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (984.6500, CAST(N'2019-02-13' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (399.3700, CAST(N'2007-03-22' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (147.6500, CAST(N'2019-07-09' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (37.4700, CAST(N'2011-11-03' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (924.1300, CAST(N'2018-02-28' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (499.6500, CAST(N'2012-01-19' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (150.7900, CAST(N'2019-10-09' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (162.7400, CAST(N'2009-11-11' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (6.1500, CAST(N'2013-04-24' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (304.5700, CAST(N'2018-11-28' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (809.7200, CAST(N'2016-01-22' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (202.6000, CAST(N'2007-01-01' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (425.9000, CAST(N'2014-07-03' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (502.6900, CAST(N'2016-07-13' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (257.8100, CAST(N'2012-10-11' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (94.3800, CAST(N'2008-03-24' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (266.7600, CAST(N'2011-09-05' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (255.1200, CAST(N'2007-03-23' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (285.6800, CAST(N'2010-01-28' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (845.1300, CAST(N'2014-12-02' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (29.7700, CAST(N'2018-08-03' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (804.2700, CAST(N'2015-07-27' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (821.8000, CAST(N'2015-10-08' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (814.9900, CAST(N'2008-08-27' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (404.9700, CAST(N'2011-05-20' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (227.7100, CAST(N'2013-02-28' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (121.8800, CAST(N'2008-10-15' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (991.0000, CAST(N'2017-09-26' AS Date), 3)
GO
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (107.1900, CAST(N'2008-07-25' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (252.9500, CAST(N'2015-02-19' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (710.9800, CAST(N'2014-06-25' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (509.6800, CAST(N'2011-11-28' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (68.3100, CAST(N'2012-08-31' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (769.9500, CAST(N'2012-05-29' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (268.9400, CAST(N'2014-09-10' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (466.4300, CAST(N'2010-09-30' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (284.9000, CAST(N'2011-03-14' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (573.7600, CAST(N'2011-04-22' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (699.7200, CAST(N'2013-02-27' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (164.9300, CAST(N'2017-12-25' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (279.7000, CAST(N'2018-04-19' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (632.7300, CAST(N'2017-10-27' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (439.3100, CAST(N'2010-09-29' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (453.2200, CAST(N'2018-04-10' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (162.0100, CAST(N'2018-12-05' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (707.6500, CAST(N'2009-06-26' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (310.5600, CAST(N'2018-07-10' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (106.1500, CAST(N'2009-10-20' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (741.2900, CAST(N'2018-07-11' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (892.4500, CAST(N'2015-07-13' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (539.1600, CAST(N'2007-01-23' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (277.6800, CAST(N'2009-05-25' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (74.9000, CAST(N'2019-06-04' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (467.5700, CAST(N'2007-12-14' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (334.3300, CAST(N'2008-01-24' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (259.9400, CAST(N'2017-06-01' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (83.5100, CAST(N'2017-09-07' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (220.7000, CAST(N'2016-10-28' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (572.1000, CAST(N'2017-11-24' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (848.2600, CAST(N'2007-06-04' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (694.5800, CAST(N'2009-07-14' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (629.2500, CAST(N'2017-06-16' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (341.2200, CAST(N'2014-11-26' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (72.8800, CAST(N'2011-07-15' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (268.5400, CAST(N'2009-09-10' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (694.3800, CAST(N'2016-02-03' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (145.9700, CAST(N'2010-11-23' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (683.3500, CAST(N'2017-10-24' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (188.2700, CAST(N'2010-10-05' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (458.8900, CAST(N'2019-12-04' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (944.0900, CAST(N'2018-04-02' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (724.6400, CAST(N'2011-09-12' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (52.7300, CAST(N'2007-11-29' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (46.1000, CAST(N'2009-05-21' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (259.3700, CAST(N'2012-03-09' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (35.2800, CAST(N'2011-02-08' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (233.5400, CAST(N'2008-01-14' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (328.3100, CAST(N'2014-11-25' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (747.3400, CAST(N'2012-04-02' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (325.4100, CAST(N'2014-02-19' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (781.3600, CAST(N'2015-01-26' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (82.4200, CAST(N'2007-11-23' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (632.7000, CAST(N'2013-08-22' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (233.0700, CAST(N'2010-11-15' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (833.6000, CAST(N'2012-04-13' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (252.7400, CAST(N'2017-12-12' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (603.9500, CAST(N'2007-01-03' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (970.3100, CAST(N'2016-03-11' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (720.0800, CAST(N'2017-12-01' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (110.4400, CAST(N'2013-01-31' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (25.3600, CAST(N'2010-12-22' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (33.1100, CAST(N'2016-06-06' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (330.8400, CAST(N'2017-09-08' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (790.8700, CAST(N'2019-04-10' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (899.2400, CAST(N'2014-03-18' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (854.0400, CAST(N'2008-09-29' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (23.2500, CAST(N'2018-12-26' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (434.2300, CAST(N'2016-02-11' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (928.0500, CAST(N'2017-12-12' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (46.4900, CAST(N'2012-10-26' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (796.4300, CAST(N'2015-11-19' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (148.8900, CAST(N'2013-09-10' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (777.9500, CAST(N'2015-12-21' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (941.0800, CAST(N'2011-08-16' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (778.0700, CAST(N'2019-01-08' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (412.9200, CAST(N'2014-02-13' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (581.0400, CAST(N'2010-12-20' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (462.5600, CAST(N'2012-08-14' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (987.5500, CAST(N'2008-09-25' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (867.5500, CAST(N'2009-08-12' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (757.1700, CAST(N'2008-10-15' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (499.8200, CAST(N'2007-06-11' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (526.0800, CAST(N'2013-08-29' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (636.5000, CAST(N'2014-07-29' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (602.1300, CAST(N'2020-01-14' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (2.2400, CAST(N'2010-11-24' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (369.6600, CAST(N'2016-08-29' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (404.9500, CAST(N'2012-04-30' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (323.7700, CAST(N'2014-10-13' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (763.2500, CAST(N'2015-11-04' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (542.8200, CAST(N'2016-01-12' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (669.7100, CAST(N'2007-01-19' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (323.6100, CAST(N'2010-02-11' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (229.0800, CAST(N'2018-06-14' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (969.4700, CAST(N'2017-04-27' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (95.6200, CAST(N'2009-07-09' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (947.2300, CAST(N'2016-03-16' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (211.0100, CAST(N'2012-08-17' AS Date), 5)
GO
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (787.2300, CAST(N'2013-09-16' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (2.2700, CAST(N'2011-08-05' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (347.7100, CAST(N'2016-10-28' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (341.6000, CAST(N'2007-09-17' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (661.6900, CAST(N'2015-04-13' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (319.8100, CAST(N'2013-05-07' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (800.0900, CAST(N'2009-08-04' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (623.0000, CAST(N'2015-02-18' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (348.2400, CAST(N'2012-11-29' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (289.9400, CAST(N'2017-10-09' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (908.6700, CAST(N'2007-07-16' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (572.9600, CAST(N'2007-04-11' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (176.0600, CAST(N'2013-10-17' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (956.0600, CAST(N'2015-02-16' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (819.9000, CAST(N'2018-01-02' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (645.9800, CAST(N'2011-04-18' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (239.2900, CAST(N'2018-08-08' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (210.9400, CAST(N'2019-08-15' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (849.7400, CAST(N'2014-07-28' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (510.8300, CAST(N'2014-05-05' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (500.3600, CAST(N'2015-05-22' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (881.7900, CAST(N'2010-03-24' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (196.2000, CAST(N'2014-06-24' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (978.4100, CAST(N'2012-06-20' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (124.8400, CAST(N'2009-04-30' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (584.3900, CAST(N'2007-04-24' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (984.0400, CAST(N'2015-06-19' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (116.3800, CAST(N'2011-05-17' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (94.4100, CAST(N'2015-12-04' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (348.2900, CAST(N'2012-12-03' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (554.5200, CAST(N'2015-07-28' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (24.5300, CAST(N'2017-01-31' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (483.3900, CAST(N'2015-05-25' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (264.0000, CAST(N'2007-05-21' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (828.6600, CAST(N'2017-11-14' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (164.0700, CAST(N'2017-08-04' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (241.7000, CAST(N'2014-04-25' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (873.1800, CAST(N'2014-03-10' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (688.6600, CAST(N'2011-11-03' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (97.1000, CAST(N'2009-02-18' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (543.9200, CAST(N'2012-09-24' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (773.5400, CAST(N'2007-09-12' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (504.1300, CAST(N'2013-03-28' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (810.6000, CAST(N'2010-11-19' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (905.7500, CAST(N'2016-11-16' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (777.0900, CAST(N'2009-09-23' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (968.5600, CAST(N'2015-06-18' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (320.9100, CAST(N'2010-05-21' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (774.5800, CAST(N'2019-09-10' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (544.5000, CAST(N'2017-01-13' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (774.3200, CAST(N'2019-08-13' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (413.3300, CAST(N'2019-01-16' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (452.6300, CAST(N'2019-09-06' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (588.8700, CAST(N'2015-10-15' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (417.4600, CAST(N'2012-04-30' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (187.8600, CAST(N'2019-05-22' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (619.4900, CAST(N'2011-07-29' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (439.0100, CAST(N'2008-10-09' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (137.7700, CAST(N'2018-01-22' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (609.0400, CAST(N'2015-09-24' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (108.8900, CAST(N'2016-02-19' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (803.1000, CAST(N'2013-09-05' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (692.1500, CAST(N'2011-10-06' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (115.6900, CAST(N'2013-05-30' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (339.2200, CAST(N'2016-09-29' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (609.2100, CAST(N'2011-11-04' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (935.2700, CAST(N'2018-12-28' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (327.7600, CAST(N'2010-08-17' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (255.8600, CAST(N'2010-03-30' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (174.0200, CAST(N'2011-10-05' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (98.1000, CAST(N'2007-12-04' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (366.8900, CAST(N'2014-01-15' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (318.0400, CAST(N'2012-02-20' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (470.7400, CAST(N'2016-03-30' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (521.3600, CAST(N'2012-05-10' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (950.0800, CAST(N'2016-05-20' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (311.0500, CAST(N'2018-02-01' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (834.4800, CAST(N'2010-12-09' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (906.6300, CAST(N'2016-02-19' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (339.4100, CAST(N'2015-02-09' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (957.8200, CAST(N'2012-06-28' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (936.5600, CAST(N'2013-12-26' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (387.2900, CAST(N'2015-09-16' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (0.3500, CAST(N'2010-02-24' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (816.3500, CAST(N'2008-06-05' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (42.7900, CAST(N'2014-07-04' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (288.4000, CAST(N'2009-05-07' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (703.3800, CAST(N'2016-08-31' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (749.2300, CAST(N'2008-06-06' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (889.4100, CAST(N'2018-11-05' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (126.3100, CAST(N'2019-06-27' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (606.9300, CAST(N'2019-01-01' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (525.3500, CAST(N'2009-04-03' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (203.9900, CAST(N'2012-06-06' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (424.7400, CAST(N'2013-12-16' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (604.2100, CAST(N'2010-09-02' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (560.9500, CAST(N'2016-06-20' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (331.7900, CAST(N'2010-01-07' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (523.9100, CAST(N'2015-10-22' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (321.7500, CAST(N'2015-09-08' AS Date), 1)
GO
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (308.4400, CAST(N'2011-05-12' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (460.3300, CAST(N'2019-12-13' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (562.5500, CAST(N'2019-01-01' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (8.1400, CAST(N'2019-07-22' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (726.6400, CAST(N'2016-06-01' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (295.0700, CAST(N'2007-10-19' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (777.2400, CAST(N'2012-04-11' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (254.9400, CAST(N'2016-06-02' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (720.3000, CAST(N'2012-02-22' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (276.5200, CAST(N'2007-05-30' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (919.7400, CAST(N'2013-09-17' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (475.9000, CAST(N'2016-04-22' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (58.2000, CAST(N'2012-06-27' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (111.4100, CAST(N'2017-09-04' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (522.4400, CAST(N'2007-04-16' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (351.4000, CAST(N'2009-02-27' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (136.4000, CAST(N'2008-05-26' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (375.6900, CAST(N'2011-04-07' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (812.9600, CAST(N'2018-09-20' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (252.8600, CAST(N'2010-05-25' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (22.3800, CAST(N'2012-04-06' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (316.9400, CAST(N'2013-09-04' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (488.6300, CAST(N'2016-06-13' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (987.8700, CAST(N'2012-11-02' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (489.3900, CAST(N'2011-06-21' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (334.4900, CAST(N'2007-06-05' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (924.1000, CAST(N'2010-07-20' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (807.1500, CAST(N'2010-08-04' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (241.1200, CAST(N'2018-06-01' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (555.6100, CAST(N'2009-07-28' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (618.9400, CAST(N'2013-09-04' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (870.2700, CAST(N'2011-01-03' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (588.9800, CAST(N'2012-02-02' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (467.7100, CAST(N'2014-05-09' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (516.1500, CAST(N'2011-01-07' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (570.1500, CAST(N'2012-12-19' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (711.7000, CAST(N'2013-07-09' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (611.0400, CAST(N'2007-08-13' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (858.7700, CAST(N'2009-11-20' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (563.2300, CAST(N'2009-07-23' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (381.7700, CAST(N'2012-10-05' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (610.1500, CAST(N'2011-08-30' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (278.8500, CAST(N'2013-05-17' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (22.9900, CAST(N'2007-09-14' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (691.9900, CAST(N'2014-01-08' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (77.8100, CAST(N'2007-07-02' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (92.6100, CAST(N'2012-10-26' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (132.0400, CAST(N'2016-08-19' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (617.3900, CAST(N'2018-10-19' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (787.2600, CAST(N'2016-03-10' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (642.7000, CAST(N'2007-08-06' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (772.6800, CAST(N'2012-10-22' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (828.6500, CAST(N'2009-12-09' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (809.4000, CAST(N'2017-10-19' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (808.3100, CAST(N'2012-06-29' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (351.2100, CAST(N'2009-03-19' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (512.7800, CAST(N'2009-08-14' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (245.7800, CAST(N'2016-08-12' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (262.4100, CAST(N'2015-02-09' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (575.1200, CAST(N'2013-01-21' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (978.9000, CAST(N'2018-11-20' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (415.2000, CAST(N'2013-10-21' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (532.6500, CAST(N'2015-07-03' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (98.4700, CAST(N'2014-07-28' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (500.1000, CAST(N'2015-03-13' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (857.6600, CAST(N'2012-06-07' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (481.0800, CAST(N'2010-11-11' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (483.4400, CAST(N'2009-02-27' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (123.5900, CAST(N'2017-08-11' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (910.9200, CAST(N'2009-04-01' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (219.0100, CAST(N'2017-03-24' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (218.3700, CAST(N'2013-12-03' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (778.7300, CAST(N'2011-10-13' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (29.3900, CAST(N'2010-02-22' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (106.5000, CAST(N'2015-03-09' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (386.2200, CAST(N'2009-06-22' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (402.7100, CAST(N'2011-05-20' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (686.7900, CAST(N'2012-09-24' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (864.0300, CAST(N'2010-01-28' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (433.6900, CAST(N'2018-08-22' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (947.7000, CAST(N'2018-12-26' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (820.1900, CAST(N'2007-09-19' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (408.0700, CAST(N'2016-01-20' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (132.0200, CAST(N'2013-08-26' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (15.7800, CAST(N'2014-10-30' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (53.8000, CAST(N'2018-02-01' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (877.2600, CAST(N'2018-09-03' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (984.6500, CAST(N'2009-01-28' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (726.6000, CAST(N'2015-06-16' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (269.7500, CAST(N'2012-06-29' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (330.8500, CAST(N'2018-02-07' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (421.6200, CAST(N'2011-03-25' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (601.0400, CAST(N'2015-01-15' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (391.2100, CAST(N'2010-03-02' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (305.1900, CAST(N'2011-09-19' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (630.2600, CAST(N'2012-10-22' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (186.1000, CAST(N'2014-02-07' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (10.1400, CAST(N'2012-08-02' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (129.3200, CAST(N'2008-10-21' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (455.7100, CAST(N'2011-11-21' AS Date), 6)
GO
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (728.2500, CAST(N'2019-10-21' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (68.3700, CAST(N'2016-04-06' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (809.0400, CAST(N'2019-04-26' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (949.2500, CAST(N'2015-04-24' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (113.4800, CAST(N'2011-09-28' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (400.1800, CAST(N'2013-09-12' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (270.3000, CAST(N'2013-07-08' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (701.5800, CAST(N'2015-05-11' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (114.7300, CAST(N'2015-09-28' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (246.9800, CAST(N'2019-10-11' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (904.6300, CAST(N'2011-12-30' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (722.4600, CAST(N'2019-05-17' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (99.5700, CAST(N'2009-10-08' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (99.5200, CAST(N'2014-12-17' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (17.0600, CAST(N'2009-09-24' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (725.1100, CAST(N'2017-02-20' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (405.6400, CAST(N'2009-03-20' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (283.9300, CAST(N'2012-07-12' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (548.3700, CAST(N'2011-05-13' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (586.1100, CAST(N'2007-10-17' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (457.7000, CAST(N'2018-02-21' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (171.1100, CAST(N'2007-01-02' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (670.2600, CAST(N'2018-11-29' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (604.3600, CAST(N'2019-11-22' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (666.4100, CAST(N'2011-06-22' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (225.9000, CAST(N'2014-04-01' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (391.9700, CAST(N'2011-05-17' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (751.0300, CAST(N'2013-05-29' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (335.2200, CAST(N'2008-09-16' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (137.1500, CAST(N'2016-11-21' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (220.2600, CAST(N'2017-04-21' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (348.3500, CAST(N'2018-05-22' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (886.7600, CAST(N'2013-03-01' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (29.7100, CAST(N'2015-03-18' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (684.0600, CAST(N'2018-04-30' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (229.4500, CAST(N'2015-11-30' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (75.3400, CAST(N'2009-06-29' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (118.6500, CAST(N'2018-06-08' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (429.8100, CAST(N'2019-12-05' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (40.9700, CAST(N'2019-07-04' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (589.4700, CAST(N'2012-10-08' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (206.5100, CAST(N'2013-05-03' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (392.2700, CAST(N'2015-09-21' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (221.3700, CAST(N'2009-02-26' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (432.2900, CAST(N'2013-03-05' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (860.7300, CAST(N'2011-11-15' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (933.0300, CAST(N'2019-06-18' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (5.7400, CAST(N'2016-10-24' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (402.5700, CAST(N'2011-11-09' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (657.8500, CAST(N'2018-01-11' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (271.5400, CAST(N'2014-06-19' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (456.7200, CAST(N'2012-08-16' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (988.1300, CAST(N'2018-01-31' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (342.1300, CAST(N'2018-10-23' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (658.8000, CAST(N'2012-11-26' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (181.6000, CAST(N'2018-11-14' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (976.4200, CAST(N'2018-01-23' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (147.1600, CAST(N'2011-07-06' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (516.0900, CAST(N'2016-11-15' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (301.8600, CAST(N'2008-05-30' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (429.2400, CAST(N'2014-01-14' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (90.0200, CAST(N'2007-05-22' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (8.4200, CAST(N'2018-10-01' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (694.9500, CAST(N'2019-05-20' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (996.7400, CAST(N'2013-08-23' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (647.8500, CAST(N'2011-08-10' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (98.1200, CAST(N'2015-05-26' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (140.8400, CAST(N'2015-08-10' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (302.7600, CAST(N'2016-09-07' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (828.3500, CAST(N'2015-05-29' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (245.6500, CAST(N'2011-07-01' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (634.5900, CAST(N'2009-05-28' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (293.0000, CAST(N'2007-12-05' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (270.4000, CAST(N'2018-01-26' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (887.0600, CAST(N'2017-01-06' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (175.3600, CAST(N'2014-02-26' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (568.8600, CAST(N'2016-12-19' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (130.5600, CAST(N'2016-06-16' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (996.5000, CAST(N'2013-05-08' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (353.8000, CAST(N'2010-11-03' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (181.6200, CAST(N'2018-05-31' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (360.2900, CAST(N'2012-10-02' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (683.8800, CAST(N'2007-01-12' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (211.7500, CAST(N'2018-02-08' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (527.1900, CAST(N'2011-11-23' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (509.0100, CAST(N'2015-02-05' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (396.6200, CAST(N'2013-09-11' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (870.0500, CAST(N'2018-12-07' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (759.9000, CAST(N'2017-12-06' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (656.7500, CAST(N'2014-04-30' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (928.3000, CAST(N'2018-05-07' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (608.4500, CAST(N'2017-11-16' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (322.2600, CAST(N'2011-09-22' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (728.5000, CAST(N'2013-07-29' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (967.1800, CAST(N'2014-01-02' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (844.7500, CAST(N'2019-07-15' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (841.2400, CAST(N'2009-04-24' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (614.0800, CAST(N'2013-04-02' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (869.1600, CAST(N'2019-08-20' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (265.2000, CAST(N'2010-07-15' AS Date), 2)
GO
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (522.6300, CAST(N'2017-11-03' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (321.6100, CAST(N'2013-01-29' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (61.6500, CAST(N'2011-11-23' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (254.5800, CAST(N'2008-02-22' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (482.5800, CAST(N'2019-02-21' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (656.1500, CAST(N'2017-04-24' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (605.6000, CAST(N'2012-04-05' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (846.2300, CAST(N'2009-05-05' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (91.0500, CAST(N'2014-10-02' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (56.1800, CAST(N'2019-04-23' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (59.1600, CAST(N'2011-06-09' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (321.7900, CAST(N'2007-07-31' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (81.1200, CAST(N'2017-06-09' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (719.9800, CAST(N'2012-08-30' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (729.4600, CAST(N'2013-06-20' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (813.5900, CAST(N'2016-12-29' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (5.0200, CAST(N'2014-10-15' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (37.8500, CAST(N'2010-08-10' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (733.2400, CAST(N'2013-05-14' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (82.3800, CAST(N'2010-11-05' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (289.2000, CAST(N'2016-08-18' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (909.1800, CAST(N'2019-10-16' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (628.0400, CAST(N'2017-08-17' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (556.8400, CAST(N'2008-05-06' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (347.8200, CAST(N'2009-06-30' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (613.0400, CAST(N'2007-04-20' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (713.9700, CAST(N'2015-09-25' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (88.0400, CAST(N'2010-12-27' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (801.3300, CAST(N'2016-07-25' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (883.1000, CAST(N'2009-03-25' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (78.6300, CAST(N'2011-02-17' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (287.3600, CAST(N'2012-10-16' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (969.7200, CAST(N'2010-08-10' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (885.0400, CAST(N'2016-01-28' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (171.5100, CAST(N'2008-07-01' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (612.7100, CAST(N'2011-09-01' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (788.7700, CAST(N'2018-11-13' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (242.3500, CAST(N'2016-10-20' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (785.7800, CAST(N'2018-02-23' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (603.8900, CAST(N'2020-01-01' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (941.3600, CAST(N'2009-11-03' AS Date), 0)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (883.3300, CAST(N'2017-12-04' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (187.0600, CAST(N'2013-10-29' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (975.2100, CAST(N'2017-08-11' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (517.1700, CAST(N'2014-09-17' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (236.5100, CAST(N'2018-06-29' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (17.0600, CAST(N'2012-11-06' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (184.2600, CAST(N'2017-06-29' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (486.1100, CAST(N'2013-09-19' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (890.5600, CAST(N'2013-03-14' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (173.1500, CAST(N'2011-07-21' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (764.3400, CAST(N'2018-10-09' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (479.2200, CAST(N'2011-07-19' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (924.2000, CAST(N'2017-01-17' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (368.2400, CAST(N'2016-09-08' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (242.0300, CAST(N'2007-09-10' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (274.4700, CAST(N'2014-02-06' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (814.3900, CAST(N'2011-12-28' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (868.5300, CAST(N'2016-07-06' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (869.0500, CAST(N'2018-07-03' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (501.7600, CAST(N'2012-04-19' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (460.8600, CAST(N'2017-04-05' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (450.7800, CAST(N'2012-02-10' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (587.5300, CAST(N'2017-09-28' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (74.6500, CAST(N'2009-12-30' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (178.6600, CAST(N'2016-07-19' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (826.3300, CAST(N'2011-06-14' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (891.1600, CAST(N'2017-10-03' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (378.4600, CAST(N'2019-09-12' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (456.4700, CAST(N'2013-06-28' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (969.5600, CAST(N'2019-01-02' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (521.9700, CAST(N'2016-11-14' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (503.6300, CAST(N'2011-12-26' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (726.1300, CAST(N'2017-06-08' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (540.9400, CAST(N'2016-08-04' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (568.2400, CAST(N'2007-05-29' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (431.3200, CAST(N'2007-10-26' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (894.6500, CAST(N'2016-02-23' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (560.2400, CAST(N'2010-04-27' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (432.5500, CAST(N'2009-01-22' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (151.1700, CAST(N'2010-02-01' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (823.9200, CAST(N'2015-07-28' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (253.1100, CAST(N'2011-07-19' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (100.3100, CAST(N'2008-02-19' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (501.3900, CAST(N'2007-01-11' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (1.8300, CAST(N'2017-11-23' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (890.6400, CAST(N'2012-09-06' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (24.3200, CAST(N'2010-12-28' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (719.1800, CAST(N'2012-03-12' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (636.7500, CAST(N'2012-02-20' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (245.7900, CAST(N'2009-01-29' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (201.2300, CAST(N'2011-07-06' AS Date), 6)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (536.0700, CAST(N'2013-05-20' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (864.5100, CAST(N'2018-03-09' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (473.5900, CAST(N'2016-12-22' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (572.2600, CAST(N'2013-03-07' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (980.9100, CAST(N'2018-09-20' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (78.0400, CAST(N'2019-11-27' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (900.1200, CAST(N'2019-08-21' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (50.0600, CAST(N'2015-05-12' AS Date), 15)
GO
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (474.4900, CAST(N'2019-09-23' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (316.3400, CAST(N'2019-02-05' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (648.5700, CAST(N'2015-12-09' AS Date), 2)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (516.0800, CAST(N'2010-01-25' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (289.4900, CAST(N'2016-05-19' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (467.1400, CAST(N'2012-05-15' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (411.3500, CAST(N'2013-06-25' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (955.0100, CAST(N'2007-12-11' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (822.9800, CAST(N'2016-06-01' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (14.1300, CAST(N'2014-05-27' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (616.6500, CAST(N'2017-10-03' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (32.7500, CAST(N'2017-07-14' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (222.1300, CAST(N'2019-09-16' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (105.9200, CAST(N'2011-09-02' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (101.7400, CAST(N'2019-10-23' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (540.0800, CAST(N'2016-05-03' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (137.0000, CAST(N'2015-03-19' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (848.8600, CAST(N'2015-08-07' AS Date), 18)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (306.7000, CAST(N'2015-06-25' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (824.4300, CAST(N'2013-07-18' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (133.8500, CAST(N'2011-06-16' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (41.9400, CAST(N'2007-06-11' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (727.5500, CAST(N'2015-07-09' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (121.3900, CAST(N'2010-09-02' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (796.9000, CAST(N'2013-08-21' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (283.6400, CAST(N'2009-07-17' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (556.0600, CAST(N'2019-04-18' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (319.1700, CAST(N'2014-01-16' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (70.8600, CAST(N'2011-09-23' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (298.7800, CAST(N'2013-08-14' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (582.5000, CAST(N'2019-08-30' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (138.2000, CAST(N'2017-04-17' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (115.4800, CAST(N'2010-12-01' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (428.4100, CAST(N'2010-08-10' AS Date), 11)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (905.7600, CAST(N'2020-01-01' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (493.4800, CAST(N'2007-08-27' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (492.9500, CAST(N'2014-06-25' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (346.4000, CAST(N'2014-05-13' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (143.4200, CAST(N'2009-01-14' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (84.3500, CAST(N'2012-05-02' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (825.4900, CAST(N'2019-11-21' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (504.4600, CAST(N'2012-10-16' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (933.6400, CAST(N'2011-10-25' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (585.4100, CAST(N'2018-08-02' AS Date), 15)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (865.3400, CAST(N'2009-03-04' AS Date), 4)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (804.5200, CAST(N'2017-03-02' AS Date), 22)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (395.5100, CAST(N'2017-12-06' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (44.1400, CAST(N'2013-06-13' AS Date), 21)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (342.3600, CAST(N'2015-06-25' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (222.5200, CAST(N'2009-06-10' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (903.5300, CAST(N'2008-05-22' AS Date), 20)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (168.7600, CAST(N'2017-03-31' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (484.4700, CAST(N'2018-07-11' AS Date), 14)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (108.7000, CAST(N'2017-02-08' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (613.7700, CAST(N'2013-11-26' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (301.9600, CAST(N'2019-05-02' AS Date), 23)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (992.5000, CAST(N'2017-01-24' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (360.0500, CAST(N'2018-07-12' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (238.0100, CAST(N'2012-05-02' AS Date), 16)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (23.0300, CAST(N'2014-04-15' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (563.9800, CAST(N'2018-07-26' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (506.6800, CAST(N'2012-03-29' AS Date), 19)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (722.1600, CAST(N'2009-02-12' AS Date), 8)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (273.4300, CAST(N'2018-04-04' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (225.8500, CAST(N'2008-05-29' AS Date), 1)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (326.0900, CAST(N'2014-06-27' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (405.7700, CAST(N'2011-04-04' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (967.7700, CAST(N'2014-04-30' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (194.1600, CAST(N'2019-07-30' AS Date), 9)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (820.7500, CAST(N'2017-02-23' AS Date), 5)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (593.6500, CAST(N'2009-02-06' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (315.7400, CAST(N'2018-11-15' AS Date), 12)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (387.1100, CAST(N'2012-06-26' AS Date), 17)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (690.6000, CAST(N'2012-10-17' AS Date), 10)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (421.6000, CAST(N'2016-04-12' AS Date), 7)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (881.9400, CAST(N'2015-01-09' AS Date), 3)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (680.8200, CAST(N'2014-04-07' AS Date), 13)
INSERT [dbo].[Transactions] ([Amount], [TransactionDate], [PersonID]) VALUES (205.2700, CAST(N'2009-03-27' AS Date), 18)