forked from MicrosoftLearning/dp-data
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcreate-dw.txt
5844 lines (5829 loc) · 263 KB
/
create-dw.txt
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
IF EXISTS (
SELECT * FROM sys.sysobjects
WHERE name = 'DimProduct')
DROP TABLE dbo.DimProduct;
GO
CREATE TABLE dbo.DimProduct
(
ProductKey INTEGER NOT NULL,
ProductAltKey VARCHAR(25) NULL,
ProductName VARCHAR(50) NOT NULL,
Category VARCHAR(50) NULL,
ListPrice DECIMAL NULL
);
GO
INSERT INTO dbo.DimProduct
VALUES
(1, 'RING1', 'Bicycle bell', 'Accssories', 5.99),
(2, 'BRITE1', 'Front light', 'Accessories', 15.49),
(3, 'BRITE2', 'Rear light', 'Accessories', 15.49),
(680,'FR-R92B-58','HL Road Frame - Black, 58','Road Frames', 1432.00),
(706,'FR-R92R-58','HL Road Frame - Red, 58','Road Frames', 1432.00),
(707,'HL-U509-R','Sport-100 Helmet, Red','Helmets', 35.00),
(708,'HL-U509','Sport-100 Helmet, Black','Helmets', 35.00),
(709,'SO-B909-M','Mountain Bike Socks, M','Socks', 10.00),
(710,'SO-B909-L','Mountain Bike Socks, L','Socks', 10.00),
(711,'HL-U509-B','Sport-100 Helmet, Blue','Helmets', 35.00),
(712,'CA-1098','AWC Logo Cap','Caps', 9.00),
(713,'LJ-0192-S','Long-Sleeve Logo Jersey, S','Jerseys', 50.00),
(714,'LJ-0192-M','Long-Sleeve Logo Jersey, M','Jerseys', 50.00),
(715,'LJ-0192-L','Long-Sleeve Logo Jersey, L','Jerseys', 50.00),
(716,'LJ-0192-X','Long-Sleeve Logo Jersey, XL','Jerseys', 50.00),
(717,'FR-R92R-62','HL Road Frame - Red, 62','Road Frames', 1432.00),
(718,'FR-R92R-44','HL Road Frame - Red, 44','Road Frames', 1432.00),
(719,'FR-R92R-48','HL Road Frame - Red, 48','Road Frames', 1432.00),
(720,'FR-R92R-52','HL Road Frame - Red, 52','Road Frames', 1432.00),
(721,'FR-R92R-56','HL Road Frame - Red, 56','Road Frames', 1432.00),
(722,'FR-R38B-58','LL Road Frame - Black, 58','Road Frames',337.00),
(723,'FR-R38B-60','LL Road Frame - Black, 60','Road Frames',337.00),
(724,'FR-R38B-62','LL Road Frame - Black, 62','Road Frames',337.00),
(725,'FR-R38R-44','LL Road Frame - Red, 44','Road Frames',337.00),
(726,'FR-R38R-48','LL Road Frame - Red, 48','Road Frames',337.00),
(727,'FR-R38R-52','LL Road Frame - Red, 52','Road Frames',337.00),
(728,'FR-R38R-58','LL Road Frame - Red, 58','Road Frames',337.00),
(729,'FR-R38R-60','LL Road Frame - Red, 60','Road Frames',337.00),
(730,'FR-R38R-62','LL Road Frame - Red, 62','Road Frames',337.00),
(731,'FR-R72R-44','ML Road Frame - Red, 44','Road Frames',595.00),
(732,'FR-R72R-48','ML Road Frame - Red, 48','Road Frames',595.00),
(733,'FR-R72R-52','ML Road Frame - Red, 52','Road Frames',595.00),
(734,'FR-R72R-58','ML Road Frame - Red, 58','Road Frames',595.00),
(735,'FR-R72R-60','ML Road Frame - Red, 60','Road Frames',595.00),
(736,'FR-R38B-44','LL Road Frame - Black, 44','Road Frames',337.00),
(737,'FR-R38B-48','LL Road Frame - Black, 48','Road Frames',337.00),
(738,'FR-R38B-52','LL Road Frame - Black, 52','Road Frames',337.00),
(739,'FR-M94S-42','HL Mountain Frame - Silver, 42','Mountain Frames', 1365.00),
(740,'FR-M94S-44','HL Mountain Frame - Silver, 44','Mountain Frames', 1365.00),
(741,'FR-M94S-52','HL Mountain Frame - Silver, 48','Mountain Frames', 1365.00),
(742,'FR-M94S-46','HL Mountain Frame - Silver, 46','Mountain Frames', 1365.00),
(743,'FR-M94B-42','HL Mountain Frame - Black, 42','Mountain Frames', 1350.00),
(744,'FR-M94B-44','HL Mountain Frame - Black, 44','Mountain Frames', 1350.00),
(745,'FR-M94B-48','HL Mountain Frame - Black, 48','Mountain Frames', 1350.00),
(746,'FR-M94B-46','HL Mountain Frame - Black, 46','Mountain Frames', 1350.00),
(747,'FR-M94B-38','HL Mountain Frame - Black, 38','Mountain Frames', 1350.00),
(748,'FR-M94S-38','HL Mountain Frame - Silver, 38','Mountain Frames', 1365.00),
(749,'BK-R93R-62','Road-150 Red, 62','Road Bikes', 3578.00),
(750,'BK-R93R-44','Road-150 Red, 44','Road Bikes', 3578.00),
(751,'BK-R93R-48','Road-150 Red, 48','Road Bikes', 3578.00),
(752,'BK-R93R-52','Road-150 Red, 52','Road Bikes', 3578.00),
(753,'BK-R93R-56','Road-150 Red, 56','Road Bikes', 3578.00),
(754,'BK-R68R-58','Road-450 Red, 58','Road Bikes', 1458.00),
(755,'BK-R68R-60','Road-450 Red, 60','Road Bikes', 1458.00),
(756,'BK-R68R-44','Road-450 Red, 44','Road Bikes', 1458.00),
(757,'BK-R68R-48','Road-450 Red, 48','Road Bikes', 1458.00),
(758,'BK-R68R-52','Road-450 Red, 52','Road Bikes', 1458.00),
(759,'BK-R50R-58','Road-650 Red, 58','Road Bikes',783.00),
(760,'BK-R50R-60','Road-650 Red, 60','Road Bikes',783.00),
(761,'BK-R50R-62','Road-650 Red, 62','Road Bikes',783.00),
(762,'BK-R50R-44','Road-650 Red, 44','Road Bikes',783.00),
(763,'BK-R50R-48','Road-650 Red, 48','Road Bikes',783.00),
(764,'BK-R50R-52','Road-650 Red, 52','Road Bikes',783.00),
(765,'BK-R50B-58','Road-650 Black, 58','Road Bikes',783.00),
(766,'BK-R50B-60','Road-650 Black, 60','Road Bikes',783.00),
(767,'BK-R50B-62','Road-650 Black, 62','Road Bikes',783.00),
(768,'BK-R50B-44','Road-650 Black, 44','Road Bikes',783.00),
(769,'BK-R50B-48','Road-650 Black, 48','Road Bikes',783.00),
(770,'BK-R50B-52','Road-650 Black, 52','Road Bikes',783.00),
(771,'BK-M82S-38','Mountain-100 Silver, 38','Mountain Bikes', 3400.00),
(772,'BK-M82S-42','Mountain-100 Silver, 42','Mountain Bikes', 3400.00),
(773,'BK-M82S-44','Mountain-100 Silver, 44','Mountain Bikes', 3400.00),
(774,'BK-M82S-48','Mountain-100 Silver, 48','Mountain Bikes', 3400.00),
(775,'BK-M82B-38','Mountain-100 Black, 38','Mountain Bikes', 3375.00),
(776,'BK-M82B-42','Mountain-100 Black, 42','Mountain Bikes', 3375.00),
(777,'BK-M82B-44','Mountain-100 Black, 44','Mountain Bikes', 3375.00),
(778,'BK-M82B-48','Mountain-100 Black, 48','Mountain Bikes', 3375.00),
(779,'BK-M68S-38','Mountain-200 Silver, 38','Mountain Bikes', 2320.00),
(780,'BK-M68S-42','Mountain-200 Silver, 42','Mountain Bikes', 2320.00),
(781,'BK-M68S-46','Mountain-200 Silver, 46','Mountain Bikes', 2320.00),
(782,'BK-M68B-38','Mountain-200 Black, 38','Mountain Bikes', 2295.00),
(783,'BK-M68B-42','Mountain-200 Black, 42','Mountain Bikes', 2295.00),
(784,'BK-M68B-46','Mountain-200 Black, 46','Mountain Bikes', 2295.00),
(785,'BK-M47B-38','Mountain-300 Black, 38','Mountain Bikes', 1080.00),
(786,'BK-M47B-40','Mountain-300 Black, 40','Mountain Bikes', 1080.00),
(787,'BK-M47B-44','Mountain-300 Black, 44','Mountain Bikes', 1080.00),
(788,'BK-M47B-48','Mountain-300 Black, 48','Mountain Bikes', 1080.00),
(789,'BK-R89R-44','Road-250 Red, 44','Road Bikes', 2443.00),
(790,'BK-R89R-48','Road-250 Red, 48','Road Bikes', 2443.00),
(791,'BK-R89R-52','Road-250 Red, 52','Road Bikes', 2443.00),
(792,'BK-R89R-58','Road-250 Red, 58','Road Bikes', 2443.00),
(793,'BK-R89B-44','Road-250 Black, 44','Road Bikes', 2443.00),
(794,'BK-R89B-48','Road-250 Black, 48','Road Bikes', 2443.00),
(795,'BK-R89B-52','Road-250 Black, 52','Road Bikes', 2443.00),
(796,'BK-R89B-58','Road-250 Black, 58','Road Bikes', 2443.00),
(797,'BK-R64Y-38','Road-550-W Yellow, 38','Road Bikes', 1120.00),
(798,'BK-R64Y-40','Road-550-W Yellow, 40','Road Bikes', 1120.00),
(799,'BK-R64Y-42','Road-550-W Yellow, 42','Road Bikes', 1120.00),
(800,'BK-R64Y-44','Road-550-W Yellow, 44','Road Bikes', 1120.00),
(801,'BK-R64Y-48','Road-550-W Yellow, 48','Road Bikes', 1120.00),
(802,'FK-1639','LL Fork','Forks',148.00),
(803,'FK-5136','ML Fork','Forks',175.00),
(804,'FK-9939','HL Fork','Forks',229.00),
(805,'HS-0296','LL Headset','Headsets', 34.00),
(806,'HS-2451','ML Headset','Headsets',102.00),
(807,'HS-3479','HL Headset','Headsets',125.00),
(808,'HB-M243','LL Mountain Handlebars','Handlebars', 45.00),
(809,'HB-M763','ML Mountain Handlebars','Handlebars', 62.00),
(810,'HB-M918','HL Mountain Handlebars','Handlebars',120.00),
(811,'HB-R504','LL Road Handlebars','Handlebars', 45.00),
(812,'HB-R720','ML Road Handlebars','Handlebars', 62.00),
(813,'HB-R956','HL Road Handlebars','Handlebars',120.00),
(814,'FR-M63B-38','ML Mountain Frame - Black, 38','Mountain Frames',349.00),
(815,'FW-M423','LL Mountain Front Wheel','Wheels', 61.00),
(816,'FW-M762','ML Mountain Front Wheel','Wheels',209.00),
(817,'FW-M928','HL Mountain Front Wheel','Wheels',300.00),
(818,'FW-R623','LL Road Front Wheel','Wheels', 86.00),
(819,'FW-R762','ML Road Front Wheel','Wheels',248.00),
(820,'FW-R820','HL Road Front Wheel','Wheels',330.00),
(821,'FW-T905','Touring Front Wheel','Wheels',218.00),
(822,'FR-R72Y-38','ML Road Frame-W - Yellow, 38','Road Frames',595.00),
(823,'RW-M423','LL Mountain Rear Wheel','Wheels', 88.00),
(824,'RW-M762','ML Mountain Rear Wheel','Wheels',236.00),
(825,'RW-M928','HL Mountain Rear Wheel','Wheels',327.00),
(826,'RW-R623','LL Road Rear Wheel','Wheels',113.00),
(827,'RW-R762','ML Road Rear Wheel','Wheels',275.00),
(828,'RW-R820','HL Road Rear Wheel','Wheels',357.00),
(829,'RW-T905','Touring Rear Wheel','Wheels',245.00),
(830,'FR-M63B-40','ML Mountain Frame - Black, 40','Mountain Frames',349.00),
(831,'FR-M63B-44','ML Mountain Frame - Black, 44','Mountain Frames',349.00),
(832,'FR-M63B-48','ML Mountain Frame - Black, 48','Mountain Frames',349.00),
(833,'FR-R72Y-40','ML Road Frame-W - Yellow, 40','Road Frames',595.00),
(834,'FR-R72Y-42','ML Road Frame-W - Yellow, 42','Road Frames',595.00),
(835,'FR-R72Y-44','ML Road Frame-W - Yellow, 44','Road Frames',595.00),
(836,'FR-R72Y-48','ML Road Frame-W - Yellow, 48','Road Frames',595.00),
(837,'FR-R92B-62','HL Road Frame - Black, 62','Road Frames', 1432.00),
(838,'FR-R92B-44','HL Road Frame - Black, 44','Road Frames', 1432.00),
(839,'FR-R92B-48','HL Road Frame - Black, 48','Road Frames', 1432.00),
(840,'FR-R92B-52','HL Road Frame - Black, 52','Road Frames', 1432.00),
(841,'SH-M897-S','Men`s Sports Shorts, S','Shorts', 60.00),
(842,'PA-T100','Touring-Panniers, Large','Panniers',125.00),
(843,'LO-C100','Cable Lock','Locks', 25.00),
(844,'PU-0452','Minipump','Pumps', 20.00),
(845,'PU-M044','Mountain Pump','Pumps', 25.00),
(846,'LT-T990','Taillights - Battery-Powered','Lights', 14.00),
(847,'LT-H902','Headlights - Dual-Beam','Lights', 35.00),
(848,'LT-H903','Headlights - Weatherproof','Lights', 45.00),
(849,'SH-M897-M','Men`s Sports Shorts, M','Shorts', 60.00),
(850,'SH-M897-L','Men`s Sports Shorts, L','Shorts', 60.00),
(851,'SH-M897-X','Men`s Sports Shorts, XL','Shorts', 60.00),
(852,'TG-W091-S','Women`s Tights, S','Tights', 75.00),
(853,'TG-W091-M','Women`s Tights, M','Tights', 75.00),
(854,'TG-W091-L','Women`s Tights, L','Tights', 75.00),
(855,'SB-M891-S','Men`s Bib-Shorts, S','Bib-Shorts', 90.00),
(856,'SB-M891-M','Men`s Bib-Shorts, M','Bib-Shorts', 90.00),
(857,'SB-M891-L','Men`s Bib-Shorts, L','Bib-Shorts', 90.00),
(858,'GL-H102-S','Half-Finger Gloves, S','Gloves', 24.00),
(859,'GL-H102-M','Half-Finger Gloves, M','Gloves', 24.00),
(860,'GL-H102-L','Half-Finger Gloves, L','Gloves', 24.00),
(861,'GL-F110-S','Full-Finger Gloves, S','Gloves', 38.00),
(862,'GL-F110-M','Full-Finger Gloves, M','Gloves', 38.00),
(863,'GL-F110-L','Full-Finger Gloves, L','Gloves', 38.00),
(864,'VE-C304-S','Classic Vest, S','Vests', 64.00),
(865,'VE-C304-M','Classic Vest, M','Vests', 64.00),
(866,'VE-C304-L','Classic Vest, L','Vests', 64.00),
(867,'SH-W890-S','Women`s Mountain Shorts, S','Shorts', 70.00),
(868,'SH-W890-M','Women`s Mountain Shorts, M','Shorts', 70.00),
(869,'SH-W890-L','Women`s Mountain Shorts, L','Shorts', 70.00),
(870,'WB-H098','Water Bottle - 30 oz.','Bottles and Cages', 5.00),
(871,'BC-M005','Mountain Bottle Cage','Bottles and Cages', 10.00),
(872,'BC-R205','Road Bottle Cage','Bottles and Cages', 9.00),
(873,'PK-7098','Patch Kit/8 Patches','Tires and Tubes', 2.00),
(874,'SO-R809-M','Racing Socks, M','Socks', 9.00),
(875,'SO-R809-L','Racing Socks, L','Socks', 9.00),
(876,'RA-H123','Hitch Rack - 4-Bike','Bike Racks',120.00),
(877,'CL-9009','Bike Wash - Dissolver','Cleaners', 8.00),
(878,'FE-6654','Fender Set - Mountain','Fenders', 22.00),
(879,'ST-1401','All-Purpose Bike Stand','Bike Stands',159.00),
(880,'HY-1023-70','Hydration Pack - 70 oz.','Hydration Packs', 55.00),
(881,'SJ-0194-S','Short-Sleeve Classic Jersey, S','Jerseys', 54.00),
(882,'SJ-0194-M','Short-Sleeve Classic Jersey, M','Jerseys', 54.00),
(883,'SJ-0194-L','Short-Sleeve Classic Jersey, L','Jerseys', 54.00),
(884,'SJ-0194-X','Short-Sleeve Classic Jersey, XL','Jerseys', 54.00),
(885,'FR-T98Y-60','HL Touring Frame - Yellow, 60','Touring Frames', 1004.00),
(886,'FR-T67Y-62','LL Touring Frame - Yellow, 62','Touring Frames',333.00),
(887,'FR-T98Y-46','HL Touring Frame - Yellow, 46','Touring Frames', 1004.00),
(888,'FR-T98Y-50','HL Touring Frame - Yellow, 50','Touring Frames', 1004.00),
(889,'FR-T98Y-54','HL Touring Frame - Yellow, 54','Touring Frames', 1004.00),
(890,'FR-T98U-46','HL Touring Frame - Blue, 46','Touring Frames', 1004.00),
(891,'FR-T98U-50','HL Touring Frame - Blue, 50','Touring Frames', 1004.00),
(892,'FR-T98U-54','HL Touring Frame - Blue, 54','Touring Frames', 1004.00),
(893,'FR-T98U-60','HL Touring Frame - Blue, 60','Touring Frames', 1004.00),
(894,'RD-2308','Rear Derailleur','Derailleurs',121.00),
(895,'FR-T67U-50','LL Touring Frame - Blue, 50','Touring Frames',333.00),
(896,'FR-T67U-54','LL Touring Frame - Blue, 54','Touring Frames',333.00),
(897,'FR-T67U-58','LL Touring Frame - Blue, 58','Touring Frames',333.00),
(898,'FR-T67U-62','LL Touring Frame - Blue, 62','Touring Frames',333.00),
(899,'FR-T67Y-44','LL Touring Frame - Yellow, 44','Touring Frames',333.00),
(900,'FR-T67Y-50','LL Touring Frame - Yellow, 50','Touring Frames',333.00),
(901,'FR-T67Y-54','LL Touring Frame - Yellow, 54','Touring Frames',333.00),
(902,'FR-T67Y-58','LL Touring Frame - Yellow, 58','Touring Frames',333.00),
(903,'FR-T67U-44','LL Touring Frame - Blue, 44','Touring Frames',333.00),
(904,'FR-M63S-40','ML Mountain Frame-W - Silver, 40','Mountain Frames',364.00),
(905,'FR-M63S-42','ML Mountain Frame-W - Silver, 42','Mountain Frames',364.00),
(906,'FR-M63S-46','ML Mountain Frame-W - Silver, 46','Mountain Frames',364.00),
(907,'RB-9231','Rear Brakes','Brakes',107.00),
(908,'SE-M236','LL Mountain Seat/Saddle','Saddles', 27.00),
(909,'SE-M798','ML Mountain Seat/Saddle','Saddles', 39.00),
(910,'SE-M940','HL Mountain Seat/Saddle','Saddles', 53.00),
(911,'SE-R581','LL Road Seat/Saddle','Saddles', 27.00),
(912,'SE-R908','ML Road Seat/Saddle','Saddles', 39.00),
(913,'SE-R995','HL Road Seat/Saddle','Saddles', 53.00),
(914,'SE-T312','LL Touring Seat/Saddle','Saddles', 27.00),
(915,'SE-T762','ML Touring Seat/Saddle','Saddles', 39.00),
(916,'SE-T924','HL Touring Seat/Saddle','Saddles', 53.00),
(917,'FR-M21S-42','LL Mountain Frame - Silver, 42','Mountain Frames',264.00),
(918,'FR-M21S-44','LL Mountain Frame - Silver, 44','Mountain Frames',264.00),
(919,'FR-M21S-48','LL Mountain Frame - Silver, 48','Mountain Frames',264.00),
(920,'FR-M21S-52','LL Mountain Frame - Silver, 52','Mountain Frames',264.00),
(921,'TT-M928','Mountain Tire Tube','Tires and Tubes', 5.00),
(922,'TT-R982','Road Tire Tube','Tires and Tubes', 4.00),
(923,'TT-T092','Touring Tire Tube','Tires and Tubes', 5.00),
(924,'FR-M21B-42','LL Mountain Frame - Black, 42','Mountain Frames',250.00),
(925,'FR-M21B-44','LL Mountain Frame - Black, 44','Mountain Frames',250.00),
(926,'FR-M21B-48','LL Mountain Frame - Black, 48','Mountain Frames',250.00),
(927,'FR-M21B-52','LL Mountain Frame - Black, 52','Mountain Frames',250.00),
(928,'TI-M267','LL Mountain Tire','Tires and Tubes', 25.00),
(929,'TI-M602','ML Mountain Tire','Tires and Tubes', 30.00),
(930,'TI-M823','HL Mountain Tire','Tires and Tubes', 35.00),
(931,'TI-R092','LL Road Tire','Tires and Tubes', 21.00),
(932,'TI-R628','ML Road Tire','Tires and Tubes', 25.00),
(933,'TI-R982','HL Road Tire','Tires and Tubes', 33.00),
(934,'TI-T723','Touring Tire','Tires and Tubes', 29.00),
(935,'PD-M282','LL Mountain Pedal','Pedals', 40.00),
(936,'PD-M340','ML Mountain Pedal','Pedals', 62.00),
(937,'PD-M562','HL Mountain Pedal','Pedals', 81.00),
(938,'PD-R347','LL Road Pedal','Pedals', 40.00),
(939,'PD-R563','ML Road Pedal','Pedals', 62.00),
(940,'PD-R853','HL Road Pedal','Pedals', 81.00),
(941,'PD-T852','Touring Pedal','Pedals', 81.00),
(942,'FR-M63S-38','ML Mountain Frame-W - Silver, 38','Mountain Frames',364.00),
(943,'FR-M21B-40','LL Mountain Frame - Black, 40','Mountain Frames',250.00),
(944,'FR-M21S-40','LL Mountain Frame - Silver, 40','Mountain Frames',264.00),
(945,'FD-2342','Front Derailleur','Derailleurs', 91.00),
(946,'HB-T721','LL Touring Handlebars','Handlebars', 46.00),
(947,'HB-T928','HL Touring Handlebars','Handlebars', 92.00),
(948,'FB-9873','Front Brakes','Brakes',107.00),
(949,'CS-4759','LL Crankset','Cranksets',175.00),
(950,'CS-6583','ML Crankset','Cranksets',256.00),
(951,'CS-9183','HL Crankset','Cranksets',405.00),
(952,'CH-0234','Chain','Chains', 20.00),
(953,'BK-T44U-60','Touring-2000 Blue, 60','Touring Bikes', 1215.00),
(954,'BK-T79Y-46','Touring-1000 Yellow, 46','Touring Bikes', 2384.00),
(955,'BK-T79Y-50','Touring-1000 Yellow, 50','Touring Bikes', 2384.00),
(956,'BK-T79Y-54','Touring-1000 Yellow, 54','Touring Bikes', 2384.00),
(957,'BK-T79Y-60','Touring-1000 Yellow, 60','Touring Bikes', 2384.00),
(958,'BK-T18U-54','Touring-3000 Blue, 54','Touring Bikes',742.00),
(959,'BK-T18U-58','Touring-3000 Blue, 58','Touring Bikes',742.00),
(960,'BK-T18U-62','Touring-3000 Blue, 62','Touring Bikes',742.00),
(961,'BK-T18Y-44','Touring-3000 Yellow, 44','Touring Bikes',742.00),
(962,'BK-T18Y-50','Touring-3000 Yellow, 50','Touring Bikes',742.00),
(963,'BK-T18Y-54','Touring-3000 Yellow, 54','Touring Bikes',742.00),
(964,'BK-T18Y-58','Touring-3000 Yellow, 58','Touring Bikes',742.00),
(965,'BK-T18Y-62','Touring-3000 Yellow, 62','Touring Bikes',742.00),
(966,'BK-T79U-46','Touring-1000 Blue, 46','Touring Bikes', 2384.00),
(967,'BK-T79U-50','Touring-1000 Blue, 50','Touring Bikes', 2384.00),
(968,'BK-T79U-54','Touring-1000 Blue, 54','Touring Bikes', 2384.00),
(969,'BK-T79U-60','Touring-1000 Blue, 60','Touring Bikes', 2384.00),
(970,'BK-T44U-46','Touring-2000 Blue, 46','Touring Bikes', 1215.00),
(971,'BK-T44U-50','Touring-2000 Blue, 50','Touring Bikes', 1215.00),
(972,'BK-T44U-54','Touring-2000 Blue, 54','Touring Bikes', 1215.00),
(973,'BK-R79Y-40','Road-350-W Yellow, 40','Road Bikes', 1701.00),
(974,'BK-R79Y-42','Road-350-W Yellow, 42','Road Bikes', 1701.00),
(975,'BK-R79Y-44','Road-350-W Yellow, 44','Road Bikes', 1701.00),
(976,'BK-R79Y-48','Road-350-W Yellow, 48','Road Bikes', 1701.00),
(977,'BK-R19B-58','Road-750 Black, 58','Road Bikes',540.00),
(978,'BK-T18U-44','Touring-3000 Blue, 44','Touring Bikes',742.00),
(979,'BK-T18U-50','Touring-3000 Blue, 50','Touring Bikes',742.00),
(980,'BK-M38S-38','Mountain-400-W Silver, 38','Mountain Bikes',769.00),
(981,'BK-M38S-40','Mountain-400-W Silver, 40','Mountain Bikes',769.00),
(982,'BK-M38S-42','Mountain-400-W Silver, 42','Mountain Bikes',769.00),
(983,'BK-M38S-46','Mountain-400-W Silver, 46','Mountain Bikes',769.00),
(984,'BK-M18S-40','Mountain-500 Silver, 40','Mountain Bikes',565.00),
(985,'BK-M18S-42','Mountain-500 Silver, 42','Mountain Bikes',565.00),
(986,'BK-M18S-44','Mountain-500 Silver, 44','Mountain Bikes',565.00),
(987,'BK-M18S-48','Mountain-500 Silver, 48','Mountain Bikes',565.00),
(988,'BK-M18S-52','Mountain-500 Silver, 52','Mountain Bikes',565.00),
(989,'BK-M18B-40','Mountain-500 Black, 40','Mountain Bikes',540.00),
(990,'BK-M18B-42','Mountain-500 Black, 42','Mountain Bikes',540.00),
(991,'BK-M18B-44','Mountain-500 Black, 44','Mountain Bikes',540.00),
(992,'BK-M18B-48','Mountain-500 Black, 48','Mountain Bikes',540.00),
(993,'BK-M18B-52','Mountain-500 Black, 52','Mountain Bikes',540.00),
(994,'BB-7421','LL Bottom Bracket','Bottom Brackets', 54.00),
(995,'BB-8107','ML Bottom Bracket','Bottom Brackets',101.00),
(996,'BB-9108','HL Bottom Bracket','Bottom Brackets',121.00),
(997,'BK-R19B-44','Road-750 Black, 44','Road Bikes',540.00),
(998,'BK-R19B-48','Road-750 Black, 48','Road Bikes',540.00),
(999,'BK-R19B-52','Road-750 Black, 52','Road Bikes',540.00);
GO
IF EXISTS (
SELECT * FROM sys.sysobjects
WHERE name = 'DimCustomer')
DROP TABLE dbo.DimCustomer;
GO
CREATE TABLE dbo.DimCustomer
(CustomerKey INT NOT NULL,
CustomerAltKey VARCHAR(50) NULL,
Title VARCHAR(5) NULL,
FirstName VARCHAR(50) NOT NULL,
LastName VARCHAR(50) NULL,
AddressLine1 VARCHAR(200) NULL,
City VARCHAR(50) NULL,
StateProvince VARCHAR(50) NULL,
CountryRegion VARCHAR(50) NULL,
PostalCode VARCHAR(20) NULL);
GO
INSERT INTO dbo.DimCustomer
VALUES
( 29485,'catherine0@adventure-works.com','Ms.','Catherine','Abel','57251 Serene Blvd','Van Nuys','California','United States','91411'),
( 29486,'kim2@adventure-works.com','Ms.','Kim','Abercrombie','Tanger Factory','Branch','Minnesota','United States','55056'),
( 29489,'frances0@adventure-works.com','Ms.','Frances','Adams','6900 Sisk Road','Modesto','California','United States','95354'),
( 29490,'margaret0@adventure-works.com','Ms.','Margaret','Smith','Lewiston Mall','Lewiston','Idaho','United States','83501'),
( 29492,'jay1@adventure-works.com','Mr.','Jay','Adams','Blue Ridge Mall','Kansas City','Missouri','United States','64106'),
( 29494,'samuel0@adventure-works.com','Mr.','Samuel','Agcaoili','No. 25800-130 King Street West','Toronto','Ontario','Canada','M4B 1V5'),
( 29496,'robert1@adventure-works.com','Mr.','Robert','Ahlering','6500 East Grant Road','Tucson','Arizona','United States','85701'),
( 29497,'françois1@adventure-works.com','Mr.','François','Ferrier','Eastridge Mall','Casper','Wyoming','United States','82601'),
( 29499,'amy1@adventure-works.com','Ms.','Amy','Alberts','252851 Rowan Place','Richmond','British Columbia','Canada','V6B 3P7'),
( 29502,'paul2@adventure-works.com','Mr.','Paul','Alcorn','White Mountain Mall','Rock Springs','Wyoming','United States','82901'),
( 29503,'gregory0@adventure-works.com','Mr.','Gregory','Alderson','25981 College Street','Montreal','Quebec','Canada','H1Y 2H5'),
( 29505,'michelle0@adventure-works.com','Ms.','Michelle','Alexander','22589 West Craig Road','North Las Vegas','Nevada','United States','89030'),
( 29506,'sean2@adventure-works.com','Mr.','Sean','Jacobson','2551 East Warner Road','Gilbert','Arizona','United States','85233'),
( 29508,'marvin0@adventure-works.com','Mr.','Marvin','Allen','First Colony Mall','Sugar Land','Texas','United States','77478'),
( 29510,'cecil0@adventure-works.com','Mr.','Cecil','Allison','254 Colonnade Road','Nepean','Ontario','Canada','K2J 2W5'),
( 29511,'oscar0@adventure-works.com','Mr.','Oscar','Alpuerto','Rocky Mountain Pines Outlet','Loveland','Colorado','United States','80537'),
( 29515,'maxwell0@adventure-works.com','Mr.','Maxwell','Amland','Suite 99320 255 - 510th Avenue S.W.','Calgary','Alberta','Canada','T2P 2G8'),
( 29517,'ramona0@adventure-works.com','Ms.','Ramona','Antrim','998 Forest Road','Saginaw','Michigan','United States','48601'),
( 29521,'tom1@adventure-works.com','Mr.','Tom','Johnston','Belz Factory Outlet','Las Vegas','Nevada','United States','89106'),
( 29522,'thomas1@adventure-works.com','Mr.','Thomas','Armstrong','Fox Hills','Culver City','California','United States','90232'),
( 29523,'john6@adventure-works.com','Mr.','John','Arthur','2345 North Freeway','Houston','Texas','United States','77003'),
( 29524,'chris3@adventure-works.com','Mr.','Chris','Ashton','70 N.W. Plaza','Saint Ann','Missouri','United States','63074'),
( 29525,'teresa0@adventure-works.com','Ms.','Teresa','Atkinson','The Citadel Commerce Plaza','City Of Commerce','California','United States','90040'),
( 29527,'robert2@adventure-works.com','Mr.','Robert','Avalos','700 Bureau Road','Montreal','Quebec','Canada','H1Y 2H7'),
( 29528,'stephen1@adventure-works.com','Mr.','Stephen','Ayers','2533 Eureka Rd.','Southgate','Michigan','United States','48195'),
( 29530,'daniel0@adventure-works.com','Mr.','Daniel','Blanco','Suite 800 2530 Slater Street','Ottawa','Ontario','Canada','K4B 1T7'),
( 29531,'cory0@adventure-works.com','Mr.','Cory','Booth','Eastern Beltway Center','Las Vegas','Nevada','United States','89106'),
( 29532,'james3@adventure-works.com','Mr.','James','Bailey','Southgate Mall','Missoula','Montana','United States','59801'),
( 29533,'douglas1@adventure-works.com','Mr.','Douglas','Baldwin','Horizon Outlet Center','Holland','Michigan','United States','49423'),
( 29535,'wayne0@adventure-works.com','Mr.','Wayne','Banack','48255 I-10 E. @ Eastpoint Blvd.','Baytown','Texas','United States','77520'),
( 29536,'robert3@adventure-works.com','Mr.','Robert','Barker','6789 Warren Road','Westland','Michigan','United States','48185'),
( 29539,'josh0@adventure-works.com','Mr.','Josh','Barnhill','25 First Canadian Place','Toronto','Ontario','Canada','M4B 1V5'),
( 29541,'gytis0@adventure-works.com',NULL,'Gytis','Barzdukas','25900-700-9th Ave S.W.','Calgary','Alberta','Canada','T2P 2G8'),
( 29544,'shaun0@adventure-works.com','Mr.','Shaun','Beasley','2500-622 5th Ave Sw','Calgary','Alberta','Canada','T2P 2G8'),
( 29545,'john8@adventure-works.com','Mr.','John','Beaver','1318 Lasalle Street','Bothell','Washington','United States','98011'),
( 29546,'christopher1@adventure-works.com','Mr.','Christopher','Beck','93-2501, Blackfriars Road,','London','England','United Kingdom','SE1 8HL'),
( 29548,'ann0@adventure-works.com','Ms.','Ann','Beebe','25537 Hillside Avenue','Victoria','British Columbia','Canada','V8V'),
( 29550,'stanley0@adventure-works.com','Mr.','Stanley','Alan','567 Sw Mcloughlin Blvd','Milwaukie','Oregon','United States','97222'),
( 29553,'edna0@adventure-works.com','Ms.','Edna','Benson','Po Box 8035996','Dallas','Texas','United States','75201'),
( 29554,'payton0@adventure-works.com','Mr.','Payton','Benson','997000 Telegraph Rd.','Southfield','Michigan','United States','48034'),
( 29557,'alexander0@adventure-works.com','Mr.','Alexander','Berger','253711 Mayfield Place, Unit 150','Richmond','British Columbia','Canada','V6B 3P7'),
( 29558,'john10@adventure-works.com','Mr.','John','Berger','5700 Explorer Drive','Mississauga','Ontario','Canada','L4W 5J3'),
( 29559,'robert4@adventure-works.com','Mr.','Robert','Bernacchi','2681 Eagle Peak','Bellevue','Washington','United States','98004'),
( 29560,'matthias1@adventure-works.com','Mr.','Matthias','Berndt','Escondido','Escondido','California','United States','92025'),
( 29562,'steven1@adventure-works.com','Mr.','Steven','Brown','5500 Grossmont Center Drive','La Mesa','California','United States','91941'),
( 29565,'jimmy1@adventure-works.com','Mr.','Jimmy','Bischoff','3065 Santa Margarita Parkway','Trabuco Canyon','California','United States','92679'),
( 29566,'mae1@adventure-works.com','Ms.','Mae','Black','Redford Plaza','Redford','Michigan','United States','48239'),
( 29567,'jackie0@adventure-works.com','Ms.','Jackie','Blackwell','2575 Bloor Street East','Toronto','Ontario','Canada','M4B 1V6'),
( 29568,'donald0@adventure-works.com','Mr.','Donald','Blanton','Corporate Office','El Segundo','California','United States','90245'),
( 29569,'linda4@adventure-works.com','Ms.','Linda','Burnett','2505 Gateway Drive','North Sioux City','South Dakota','United States','57049'),
( 29570,'michael11@adventure-works.com','Mr.','Michael','Blythe','9903 Highway 6 South','Houston','Texas','United States','77003'),
( 29571,'gabriel0@adventure-works.com','Ms.','Gabriel','Bockenkamp','67 Rainer Ave S','Renton','Washington','United States','98055'),
( 29573,'luis0@adventure-works.com','Sr.','Luis','Bonifaz','72502 Eastern Ave.','Bell Gardens','California','United States','90201'),
( 29574,'randall0@adventure-works.com','Mr.','Randall','Boseman','2500 North Stemmons Freeway','Dallas','Texas','United States','75201'),
( 29576,'eli0@adventure-works.com','Mr.','Eli','Bowen','63 West Beaver Creek','Richmond Hill','Ontario','Canada','L4E 3M5'),
( 29577,'lester0@adventure-works.com','Mr.','Lester','Bowman','770 Notre Datme Quest Bureau 800','Montreal','Quebec','Canada','H1Y 2H7'),
( 29579,'cornelius0@adventure-works.com','Mr.','Cornelius','Brandon','789 West Alameda','Westminster','Colorado','United States','80030'),
( 29580,'richard1@adventure-works.com','Mr.','Richard','Bready','4251 First Avenue','Seattle','Washington','United States','98104'),
( 29582,'ted0@adventure-works.com','Mr.','Ted','Bremer','Bldg. 9n/99298','Redmond','Washington','United States','98052'),
( 29583,'alan1@adventure-works.com','Mr.','Alan','Brewer','4255 East Lies Road','Carol Stream','Illinois','United States','60188'),
( 29584,'walter0@adventure-works.com','Mr.','Walter','Brian','25136 Jefferson Blvd.','Culver City','California','United States','90232'),
( 29585,'christopher2@adventure-works.com','Mr.','Christopher','Bright','Washington Square','Portland','Oregon','United States','97205'),
( 29587,'john12@adventure-works.com','Mr.','John','Brooks','99-3 Forest Works','London','England','United Kingdom','E17 6JF'),
( 29588,'willie0@adventure-works.com','Mr.','Willie','Brooks','Holiday Village Mall','Great Falls','Montana','United States','59401'),
( 29590,'jo2@adventure-works.com','Mr.','Jo','Brown','250000 Eight Mile Road','Detroit','Michigan','United States','48226'),
( 29591,'robert5@adventure-works.com','Mr.','Robert','Brown','250880 Baur Blvd','Saint Louis','Missouri','United States','63103'),
( 29593,'mary5@adventure-works.com','Ms.','Mary','Browning','Noah Lane','Chicago','Illinois','United States','60610'),
( 29596,'eric3@adventure-works.com','Mr.','Eric','Brumfield','600 Slater Street','Ottawa','Ontario','Canada','K4B 1S2'),
( 29598,'michael13@adventure-works.com','Mr.','Michael','Brundage','22555 Paseo De Las Americas','San Diego','California','United States','92102'),
( 29599,'shirley0@adventure-works.com','Ms.','Shirley','Bruner','4781 Highway 95','Sandpoint','Idaho','United States','83864'),
( 29600,'june0@adventure-works.com','Ms.','June','Brunner','678 Eastman Ave.','Midland','Michigan','United States','48640'),
( 29601,'dirk0@adventure-works.com','Mr.','Dirk','Bruno','251 Indell Lane','Brampton','Ontario','Canada','L6W 2T7'),
( 29603,'janainabarreirogambaro0@adventure-works.com','Sra.','Janaina Barreiro Gambaro','Bueno','995 Crescent','Richmond Hill','Ontario','Canada','L4E 3M5'),
( 29605,'megan0@adventure-works.com','Ms.','Megan','Burke','Arcadia Crossing','Phoenix','Arizona','United States','85004'),
( 29606,'karren0@adventure-works.com','Ms.','Karren','Burkhardt','2502 Evergreen Ste E','Everett','Washington','United States','98201'),
( 29608,'timothy0@adventure-works.com','Mr.','Timothy','Burnett','45259 Canada Way','Burnaby','British Columbia','Canada','V5G 4S4'),
( 29611,'jared0@adventure-works.com','Mr.','Jared','Bustamante','3307 Evergreen Blvd','Washougal','Washington','United States','98671'),
( 29612,'richard2@adventure-works.com','Mr.','Richard','Byham','Knaves Beech Ind.','High Wycombe','England','United Kingdom','HP10 9QY'),
( 29614,'ryan1@adventure-works.com','Mr.','Ryan','Calafato','254480 River Rd','Richmond','British Columbia','Canada','V6B 3P7'),
( 29615,'mari0@adventure-works.com','Ms.','Mari','Caldwell','2524 Barlby Road','London','England','United Kingdom','W10 6BL'),
( 29616,'barbara2@adventure-works.com','Ms.','Barbara','Calone','25306 Harvey Rd.','College Station','Texas','United States','77840'),
( 29617,'lindsey0@adventure-works.com','Ms.','Lindsey','Camacho','S Sound Ctr Suite 25300','Lacey','Washington','United States','98503'),
( 29618,'gustavo1@adventure-works.com','Sr.','Gustavo','Camargo','Ellesfield Ave','Bracknell','England','United Kingdom','RG12 8TB'),
( 29620,'joan0@adventure-works.com','Ms.','Joan','Campbell','P.O. Box 44000','Winnipeg','Manitoba','Canada','R3'),
( 29622,'henry0@adventure-works.com','Mr.','Henry','Campen','2507 Pacific Ave S','Tacoma','Washington','United States','98403'),
( 29623,'chris5@adventure-works.com','Mr.','Chris','Cannon','Lakewood Mall','Lakewood','California','United States','90712'),
( 29625,'suzanadeabreu0@adventure-works.com','Ms.','Suzana De Abreu','Canuto','20225 Lansing Ave','Montreal','Quebec','Canada','H1Y 2H7'),
( 29627,'johnny0@adventure-works.com','Mr.','Johnny','Caprio','22580 Free Street','Toronto','Ontario','Canada','M4B 1V7'),
( 29629,'carlton0@adventure-works.com','Mr.','Carlton','Carlisle','400-25155 West Pender St','Vancouver','British Columbia','Canada','V7L 4J4'),
( 29631,'jane0@adventure-works.com','Ms.','Jane','Carmichael','5967 W Las Positas Blvd','Pleasanton','California','United States','94566'),
( 29632,'jovita0@adventure-works.com','Ms.','Jovita','Carmody','253950 N.E. 178th Place','Woodinville','Washington','United States','98072'),
( 29635,'rob2@adventure-works.com','Mr.','Rob','Caron','Ward Parkway Center','Kansas City','Missouri','United States','64106'),
( 29636,'andy1@adventure-works.com','Mr.','Andy','Carothers','566 S. Main','Cedar City','Utah','United States','84720'),
( 29637,'donna0@adventure-works.com','Ms.','Donna','Carreras','12345 Sterling Avenue','Irving','Texas','United States','75061'),
( 29638,'rosmarie0@adventure-works.com','Ms.','Rosmarie','Carroll','39933 Mission Oaks Blvd','Camarillo','California','United States','93010'),
( 29639,'joseph1@adventure-works.com','Mr.','Joseph','Castellucio','2511 Baker Road','Toronto','Ontario','Canada','M4B 1V7'),
( 29641,'raul0@adventure-works.com','Mr.','Raul','Casts','99040 California Avenue','Sand City','California','United States','93955'),
( 29643,'matthew1@adventure-works.com','Mr.','Matthew','Cavallari','North 93270 Newport Highway','Spokane','Washington','United States','99202'),
( 29644,'brigid0@adventure-works.com','Ms.','Brigid','Cavendish','Banbury','Oxon','England','United Kingdom','OX16 8RS'),
( 29645,'andrew2@adventure-works.com','Mr.','Andrew','Cencini','558 S 6th St','Klamath Falls','Oregon','United States','97601'),
( 29646,'stacey0@adventure-works.com','Ms.','Stacey','Cereghino','220 Mercy Drive','Garland','Texas','United States','75040'),
( 29649,'pat1@adventure-works.com','Mr.','Pat','Chambers','30025 Wayburne Drive, Suite 275','Burnaby','British Columbia','Canada','V5G 4W1'),
( 29650,'forrest0@adventure-works.com','Mr.','Forrest','Chandler','The Quad @ WestView','Whittier','California','United States','90605'),
( 29651,'lee0@adventure-works.com','Mr.','Lee','Chapla','99433 S. Greenbay Rd.','Racine','Wisconsin','United States','53182'),
( 29653,'pei0@adventure-works.com','Mr.','Pei','Chow','4660 Rodeo Road','Santa Fe','New Mexico','United States','87501'),
( 29654,'yao-qiang0@adventure-works.com','Mr.','Yao-Qiang','Cheng','25 N State St','Chicago','Illinois','United States','60610'),
( 29655,'nicky0@adventure-works.com','Ms.','Nicky','Chesnut','9920 North Telegraph Rd.','Pontiac','Michigan','United States','48342'),
( 29659,'ruth1@adventure-works.com','Ms.','Ruth','Choin','7760 N. Pan Am Expwy','San Antonio','Texas','United States','78204'),
( 29660,'anthony0@adventure-works.com','Mr.','Anthony','Chor','Riverside','Sherman Oaks','California','United States','91403'),
( 29662,'jill1@adventure-works.com','Ms.','Jill','Christie','54254 Pacific Ave.','Stockton','California','United States','95202'),
( 29663,'alice1@adventure-works.com','Ms.','Alice','Clark','42500 W 76th St','Chicago','Illinois','United States','60610'),
( 29666,'jane1@adventure-works.com','Ms.','Jane','Clayton','Po Box 83270','Vancouver','British Columbia','Canada','V7L 4J4'),
( 29668,'connie0@adventure-works.com','Ms.','Connie','Coffman','25269 Wood Dale Rd.','Wood Dale','Illinois','United States','60191'),
( 29671,'pat2@adventure-works.com','Mr.','Pat','Coleman','25245 Rue Sherbrooke Ouest','Montreal','Quebec','Canada','H1Y 2H5'),
( 29673,'john14@adventure-works.com','Mr.','John','Colon','77 Beale Street','San Francisco','California','United States','94109'),
( 29674,'scott1@adventure-works.com','Mr.','Scott','Colvin','25550 Executive Dr','Elgin','Illinois','United States','60120'),
( 29677,'william1@adventure-works.com','Mr.','William','Conner','2560 Bay Street','Toronto','Ontario','Canada','M4B 1V7'),
( 29680,'dorothy0@adventure-works.com','Ms.','Dorothy','Contreras','Suite 25800 3401 - 10810th Avenue','Surrey','British Columbia','Canada','V3T 4W3'),
( 29682,'scott2@adventure-works.com','Mr.','Scott','Cooper','Pavillion @ Redlands','Redlands','California','United States','92373'),
( 29683,'eva0@adventure-works.com','Ms.','Eva','Corets','2540 Dell Range Blvd','Cheyenne','Wyoming','United States','82001'),
( 29684,'marlin0@adventure-works.com','Mr.','Marlin','Coriell','99800 Tittabawasee Rd.','Saginaw','Michigan','United States','48601'),
( 29686,'jack2@adventure-works.com','Mr.','Jack','Creasey','Factory Merchants','Barstow','California','United States','92311'),
( 29688,'grant1@adventure-works.com','Mr.','Grant','Culbertson','399700 John R. Rd.','Madison Heights','Michigan','United States','48071'),
( 29689,'scott3@adventure-works.com','Mr.','Scott','Culp','750 Lakeway Dr','Bellingham','Washington','United States','98225'),
( 29690,'conor0@adventure-works.com','Mr.','Conor','Cunningham','Sports Store At Park City','Park City','Utah','United States','84098'),
( 29692,'thierry1@adventure-works.com','Mr.','Thierry','D`Hers','Box 99354 300 Union Street','Saint John','Brunswick','Canada','E2P 1E3'),
( 29695,'megan1@adventure-works.com','Ms.','Megan','Davis','48995 Evergreen Wy.','Everett','Washington','United States','98201'),
( 29696,'alvaro0@adventure-works.com','Sr.','Alvaro','De Matos Miranda Filho','Mountain Square','Upland','California','United States','91786'),
( 29698,'jacob0@adventure-works.com','Mr.','Jacob','Dean','#9900 2700 Production Way','Burnaby','British Columbia','Canada','V5A 4X1'),
( 29699,'alexander1@adventure-works.com','Mr.','Alexander','Deborde','6777 Kingsway','Burnaby','British Columbia','Canada','V5H 3Z7'),
( 29702,'aidan0@adventure-works.com','Ms.','Aidan','Delaney','Corporate Office','Garland','Texas','United States','75040'),
( 29703,'stefan0@adventure-works.com','Mr.','Stefan','Delmarco','Incom Sports Center','Ontario','California','United States','91764'),
( 29705,'della0@adventure-works.com','Ms.','Della','Demott Jr','25575 The Queensway','Etobicoke','Ontario','Canada','M9W 3P3'),
( 29708,'prashanth0@adventure-works.com','Mr.','Prashanth','Desai','Sapp Road West','Round Rock','Texas','United States','78664'),
( 29709,'bev0@adventure-works.com','Ms.','Bev','Desalvo','7009 Sw Hall Blvd.','Tigard','Oregon','United States','97223'),
( 29710,'brenda2@adventure-works.com','Ms.','Brenda','Diaz','2560 E. Newlands Dr','Fernley','Nevada','United States','89408'),
( 29711,'gabriele0@adventure-works.com','Ms.','Gabriele','Dickmann','250551 Shellbridge Way','Richmond','British Columbia','Canada','V6B 3P7'),
( 29713,'dick1@adventure-works.com','Mr.','Dick','Dievendorff','Bradford','W. York','England','United Kingdom','BD1 4SJ'),
( 29714,'rudolph0@adventure-works.com','Mr.','Rudolph','Dillon','595 Burning Street','Vancouver','British Columbia','Canada','V7L 4J4'),
( 29716,'blaine0@adventure-works.com','Mr.','Blaine','Dockter','99000 S. Avalon Blvd. Suite 750','Carson','California','United States','90746'),
( 29717,'cindy0@adventure-works.com','Ms.','Cindy','Dodd','994 Sw Cherry Park Rd','Troutdale','Oregon','United States','97060'),
( 29719,'patricia0@adventure-works.com','Ms.','Patricia','Doyle','225 South 314th Street','Federal Way','Washington','United States','98003'),
( 29720,'gerald0@adventure-works.com','Mr.','Gerald','Drury','4635 S. Harrison Blvd.','Ogden','Utah','United States','84401'),
( 29722,'reuben1@adventure-works.com','Mr.','Reuben','D`sa','9950 Ferrand Drive, 9th Floor','Toronto','Ontario','Canada','M4B 1V4'),
( 29727,'bart0@adventure-works.com','Mr.','Bart','Duncan','99295 S.e. Tualatin Valley_hwy.','Hillsboro','Oregon','United States','97123'),
( 29728,'maciej1@adventure-works.com','Mr.','Maciej','Dusza','2564 S. Redwood Rd.','Riverton','Utah','United States','84065'),
( 29730,'linda5@adventure-works.com','Ms.','Linda','Ecoffey','67255 - 8th Street N.E., Suite 350','Calgary','Alberta','Canada','T2P 2G8'),
( 29732,'carol2@adventure-works.com','Ms.','Carol','Elliott','25220 Airline Road','Corpus Christi','Texas','United States','78404'),
( 29733,'shannon0@adventure-works.com','Ms.','Shannon','Elliott','Factory Stores/tucson','Tucson','Arizona','United States','85701'),
( 29734,'jauna0@adventure-works.com','Ms.','Jauna','Elson','2573 Dufferin Street','Toronto','Ontario','Canada','M4B 1V5'),
( 29736,'terry1@adventure-works.com','Mr.','Terry','Eminhizer','Warrington Ldc Unit 25/2','Woolston','England','United Kingdom','WA1 4SY'),
( 29737,'john16@adventure-works.com','Mr.','John','Emory','Medford','Medford','Oregon','United States','97504'),
( 29738,'gail1@adventure-works.com','Ms.','Gail','Erickson','44025 W. Empire','Denby','South Dakota','United States','57716'),
( 29739,'mark2@adventure-works.com','Mr.','Mark','Erickson','Factory Stores Of America','Mesa','Arizona','United States','85201'),
( 29740,'martha0@adventure-works.com','Ms.','Martha','Espinoza','6700 Boul Taschereau','Brossard','Quebec','Canada','J4Z 1C5'),
( 29741,'janeth1@adventure-works.com','Sra.','Janeth','Esteves','6 The Farm, Liberty Road','Maidenhead','England','United Kingdom','SL67RJ'),
( 29742,'twanna0@adventure-works.com','Ms.','Twanna','Evans','Lewis County Mall','Chehalis','Washington','United States','98532'),
( 29743,'ann1@adventure-works.com','Ms.','Ann','Evans','Ring Plaza','Norridge','Illinois','United States','60706'),
( 29744,'john17@adventure-works.com','Mr.','John','Evans','7709 West Virginia Avenue','Phoenix','Arizona','United States','85004'),
( 29747,'carolyn0@adventure-works.com','Ms.','Carolyn','Farino','3250 South Meridian','Puyallup','Washington','United States','98371'),
( 29748,'geri0@adventure-works.com','Ms.','Geri','Farrell','49925 Crestview Drive N.E.','Rio Rancho','New Mexico','United States','87124'),
( 29750,'rhoda0@adventure-works.com','Ms.','Rhoda','Finley','6030 Conroy Road','Ottawa','Ontario','Canada','K4B 1S3'),
( 29753,'kathie1@adventure-works.com','Ms.','Kathie','Flood','705 SE Mall Parkway','Everett','Washington','United States','98201'),
( 29755,'kelly0@adventure-works.com','Ms.','Kelly','Focht','5990 Avebury Road','Mississauga','Ontario','Canada','L5B 3V4'),
( 29757,'garth0@adventure-works.com','Mr.','Garth','Fort','3250 Baldwin Park Blvd','Baldwin Park','California','United States','91706'),
( 29758,'dorothy1@adventure-works.com','Ms.','Dorothy','Fox','Lakeline Mall','Cedar Park','Texas','United States','78613'),
( 29761,'susan3@adventure-works.com','Ms.','Susan','French','69251 Creditview Road','Mississauga','Ontario','Canada','L5B 3V4'),
( 29763,'mihail1@adventure-works.com','Mr.','Mihail','Frintu','Bayshore Mall','Eureka','California','United States','95501'),
( 29764,'john19@adventure-works.com','Mr.','John','Ford','23025 S.W. Military Rd.','San Antonio','Texas','United States','78204'),
( 29765,'paul3@adventure-works.com','Mr.','Paul','Fulton','Horizon Outlet Center','Monroe','Michigan','United States','98272'),
( 29766,'bob1@adventure-works.com','Mr.','Bob','Gage','43251 Viking Way, Unit 130','Richmond','British Columbia','Canada','V6B 3P7'),
( 29768,'michael15@adventure-works.com','Mr.','Michael','Galos','West Park Plaza','Irvine','California','United States','92614'),
( 29769,'jon0@adventure-works.com','Mr.','Jon','Ganio','3900 S. 997th St.','Milwaukee','Wisconsin','United States','53202'),
( 29770,'kathleen0@adventure-works.com','Ms.','Kathleen','Garza','6388 Lake City Way','Burnaby','British Columbia','Canada','V5A 3A6'),
( 29771,'dominic0@adventure-works.com','Mr.','Dominic','Gash','5420 West 22500 South','Salt Lake City','Utah','United States','84101'),
( 29772,'janet1@adventure-works.com','Ms.','Janet','Gates','165 North Main','Austin','Texas','United States','78701'),
( 29773,'orlando0@adventure-works.com','Mr.','Orlando','Gee','2251 Elliot Avenue','Seattle','Washington','United States','98104'),
( 29774,'darren0@adventure-works.com','Mr.','Darren','Gehring','509 Nafta Boulevard','Laredo','Texas','United States','78040'),
( 29775,'jim1@adventure-works.com','Mr.','Jim','Geist','35525-9th Street Sw','Puyallup','Washington','United States','98371'),
( 29776,'barbara4@adventure-works.com','Ms.','Barbara','German','Science Park South, Birchwood','Warrington','England','United Kingdom','WA3 7BH'),
( 29778,'leo0@adventure-works.com','Mr.','Leo','Giakoumakis','Elmhurst Road, Goring','Reading','England','United Kingdom','RG7 5H7'),
( 29780,'frances1@adventure-works.com','Mr.','Frances','Giglio','9979 Bayview Drive','Barrie','Ontario','Canada','L4N'),
( 29781,'guy0@adventure-works.com','Mr.','Guy','Gilbert','Vista Marketplace','Alhambra','California','United States','91801'),
( 29782,'janet2@adventure-works.com','Ms.','Janet','Gilliat','9995 West Central Entrance','Duluth','Minnesota','United States','55802'),
( 29783,'mary6@adventure-works.com','Ms.','Mary','Gimmi','5525 South Hover Road','Longmont','Colorado','United States','80501'),
( 29784,'jeanie0@adventure-works.com','Ms.','Jeanie','Glenn','9909 W. Ventura Boulevard','Camarillo','California','United States','93010'),
( 29785,'diane3@adventure-works.com','Ms.','Diane','Glimp','4400 March Road','Kanata','Ontario','Canada','K2L 1H5'),
( 29787,'scott4@adventure-works.com','Mr.','Scott','Gode','2583 Se 272nd St','Kent','Washington','United States','98031'),
( 29788,'mete0@adventure-works.com','Mr.','Mete','Goktepe','Hanford Mall','Hanford','California','United States','93230'),
( 29789,'brian4@adventure-works.com','Mr.','Brian','Goldstein','965 De La Gauchetiere West','Montreal','Quebec','Canada','H1Y 2H8'),
( 29792,'abigail0@adventure-works.com','Ms.','Abigail','Gonzalez','99450 Highway 59 North','Humble','Texas','United States','77338'),
( 29793,'michael16@adventure-works.com','Mr.','Michael','Graff','9700 Sisk Road','Modesto','California','United States','95354'),
( 29794,'derek0@adventure-works.com','Mr.','Derek','Graham','655-4th Ave S.W.','Calgary','Alberta','Canada','T2P 2G8'),
( 29796,'jon1@adventure-works.com','Mr.','Jon','Grande','Galashiels','Liverpool','England','United Kingdom','L4 4HB'),
( 29797,'jane2@adventure-works.com','Ms.','Jane','Greer','2550 Signet Drive','Weston','Ontario','Canada','M9V 4W3'),
( 29799,'douglas2@adventure-works.com','Mr.','Douglas','Groncki','70259 West Sunnyview Ave','Visalia','California','United States','93291'),
( 29800,'brian5@adventure-works.com','Mr.','Brian','Groth','Gateway','Portland','Oregon','United States','97205'),
( 29803,'hattie0@adventure-works.com','Ms.','Hattie','Haemon','55 Lakeshore Blvd East','Toronto','Ontario','Canada','M4B 1V6'),
( 29805,'erin1@adventure-works.com','Ms.','Erin','Hagens','25001 Montague Expressway','Milpitas','California','United States','95035'),
( 29806,'betty0@adventure-works.com','Ms.','Betty','Haines','640 South 994th St. W.','Billings','Montana','United States','59101'),
( 29807,'bryan2@adventure-works.com','Mr.','Bryan','Hamilton','Station E','Chalk Riber','Ontario','Canada','K0J 1J0'),
( 29809,'kerim0@adventure-works.com','Mr.','Kerim','Hanif','60025 Bollinger Canyon Road','San Ramon','California','United States','94583'),
( 29810,'jean1@adventure-works.com','Ms.','Jean','Handley','259826 Russell Rd. South','Kent','Washington','United States','98031'),
( 29813,'katherine0@adventure-works.com','Ms.','Katherine','Harding','52560 Free Street','Toronto','Ontario','Canada','M4B 1V7'),
( 29815,'lucy0@adventure-works.com','Mr.','Lucy','Harrington','482505 Warm Springs Blvd.','Fremont','California','United States','94536'),
( 29816,'keith0@adventure-works.com','Mr.','Keith','Harris','7943 Walnut Ave','Renton','Washington','United States','98055'),
( 29818,'roger0@adventure-works.com','Mr.','Roger','Harui','9927 N. Main St.','Tooele','Utah','United States','84074'),
( 29819,'ann2@adventure-works.com','Ms.','Ann','Hass','Medford Outlet Center','Medford','Minnesota','United States','55049'),
( 29822,'james8@adventure-works.com','Mr.','James','Haugh','660 Saint-Jacques, Bureau 400','Montreal','Quebec','Canada','H1Y 2H8'),
( 29824,'brenda3@adventure-works.com','Ms.','Brenda','Heaney','990th Floor 700 De La GauchetiSre Ou','Montreal','Quebec','Canada','H1Y 2H3'),
( 29826,'john20@adventure-works.com','Mr.','John','Hanson','825 W 500 S','Bountiful','Utah','United States','84010'),
( 29827,'valerie0@adventure-works.com','Ms.','Valerie','Hendricks','Kansas City Factory Outlet','Odessa','Missouri','United States','64076'),
( 29830,'kari0@adventure-works.com','Mr.','Kari','Hensien','253131 Lake Frasier Drive, Office No. 2','Calgary','Alberta','Canada','T2P 2G8'),
( 29831,'irene0@adventure-works.com','Ms.','Irene','Hernandez','25730, boul. St-Régis','Dorval','Quebec','Canada','H9P 1H1'),
( 29832,'jésus0@adventure-works.com','Mr.','Jésus','Hernandez','32605 West 252 Mile Road, Suite 250','Aurora','Ontario','Canada','L4G 7N6'),
( 29834,'cheryl0@adventure-works.com','Ms.','Cheryl','Herring','Corp Ofc Accts Payable','El Segundo','California','United States','90245'),
( 29835,'ronald1@adventure-works.com','Mr.','Ronald','Heymsfield','250775 SW Hillsdale Hwy','Beaverton','Oregon','United States','97005'),
( 29840,'andrew4@adventure-works.com','Mr.','Andrew','Hill','7000 Victoria Park Avenue','Toronto','Ontario','Canada','M4B 1V4'),
( 29842,'mike3@adventure-works.com','Mr.','Mike','Hines','25250 N 90th St','Scottsdale','Arizona','United States','85257'),
( 29843,'matthew3@adventure-works.com','Mr.','Matthew','Hink','No. 60 Bellis Fair Parkway','Bellingham','Washington','United States','98225'),
( 29847,'david16@adventure-works.com','Mr.','David','Hodgson','99700 Bell Road','Auburn','California','United States','95603'),
( 29848,'helge0@adventure-works.com','Ms.','Helge','Hoeing','Cedar Creek Stores','Mosinee','Wisconsin','United States','54455'),
( 29850,'bob2@adventure-works.com','Mr.','Bob','Hodges','Ohms Road','Houston','Texas','United States','77003'),
( 29851,'jean2@adventure-works.com','Ms.','Jean','Holloway','Unit 99a Battery Retail Pk','Birmingham','England','United Kingdom','B29 6SL'),
( 29852,'eddie0@adventure-works.com','Mr.','Eddie','Holmes','Bureau 9900 825, Avenue Querbes','Outremont','Quebec','Canada','H1Y 2G5'),
( 29853,'juanita0@adventure-works.com','Ms.','Juanita','Holman','Lake Elisnor Place','Lake Elsinore','California','United States','92530'),
( 29854,'peter3@adventure-works.com','Mr.','Peter','Houston','1200 First Ave.','Joliet','Illinois','United States','60433'),
( 29855,'curtis0@adventure-works.com','Mr.','Curtis','Howard','6th Floor, 25st Canadian Place','Toronto','Ontario','Canada','M4B 1V5'),
( 29857,'janice1@adventure-works.com','Ms.','Janice','Hows','399 Clearing Green','London','England','United Kingdom','EC1R 0DU'),
( 29858,'george1@adventure-works.com','Mr.','George','Huckaby','3390 South 23rd St.','Tacoma','Washington','United States','98403'),
( 29859,'joshua0@adventure-works.com','Mr.','Joshua','Huff','Management Mall','San Antonio','Texas','United States','78204'),
( 29860,'arlene0@adventure-works.com','Ms.','Arlene','Huff','2574 Milton Park','Oxford','England','United Kingdom','OX14 4SE'),
( 29861,'phyllis1@adventure-works.com','Ms.','Phyllis','Huntsman','City Center','Minneapolis','Minnesota','United States','55402'),
( 29862,'lawrence0@adventure-works.com','Mr.','Lawrence','Hurkett','6753 Howard Hughes Parkway','Las Vegas','Nevada','United States','89106'),
( 29863,'ryan4@adventure-works.com','Mr.','Ryan','Ihrig','250333 Southport Road, S.W.','Calgary','Alberta','Canada','T2P 2G8'),
( 29864,'beth0@adventure-works.com','Ms.','Beth','Inghram','9259 - 1110th Avenue Sw','Calgary','Alberta','Canada','T2P 2G8'),
( 29865,'lucio0@adventure-works.com','Mr.','Lucio','Iallo','Simi @ The Plaza','Simi Valley','California','United States','93065'),
( 29866,'richard4@adventure-works.com','Mr.','Richard','Irwin','99828 Routh Street, Suite 825','Dallas','Texas','United States','75201'),
( 29867,'erik0@adventure-works.com','Mr.','Erik','Ismert','4927 S Meridian Ave Ste D','Puyallup','Washington','United States','98371'),
( 29868,'denean0@adventure-works.com','Ms.','Denean','Ison','586 Fulham Road,','London','England','United Kingdom','SW6 SBY'),
( 29870,'bronson0@adventure-works.com','Mr.','Bronson','Jacobs','2510 Crew Court','Montreal','Quebec','Canada','H1Y 2H8'),
( 29871,'eric5@adventure-works.com','Mr.','Eric','Jacobsen','Topanga Plaza','Canoga Park','California','United States','91303'),
( 29872,'jodan0@adventure-works.com','Ms.','Jodan','Jacobson','6030 Robinson Road','Jefferson City','Missouri','United States','65101'),
( 29873,'mary7@adventure-works.com','Ms.','Mary','Alexander','2345 West Spencer Road','Lynnwood','Washington','United States','98036'),
( 29874,'david17@adventure-works.com','Mr.','David','Jaffe','Wade Road','Basingstoke Hants','England','United Kingdom','RG24 8PL'),
( 29876,'vance0@adventure-works.com','Ms.','Vance','Johns','65 Gamelin Street','Hull','Quebec','Canada','8Y'),
( 29877,'joyce0@adventure-works.com','Ms.','Joyce','Jarvis','955 E. County Line Rd.','Englewood','Colorado','United States','80110'),
( 29879,'stephen3@adventure-works.com','Mr.','Stephen','Jiang','9900 Ronson Drive','Etobicoke','Ontario','Canada','M9W 3P3'),
( 29881,'danielle1@adventure-works.com','Ms.','Danielle','Johnson','955 Green Valley Crescent','Ottawa','Ontario','Canada','K4B 1S1'),
( 29883,'barry1@adventure-works.com','Mr.','Barry','Johnson','2000 300th Street','Denver','Colorado','United States','80203'),
( 29884,'brian6@adventure-works.com','Mr.','Brian','Johnson','625 W Jackson Blvd. Unit 2502','Chicago','Illinois','United States','60610'),
( 29885,'david18@adventure-works.com','Mr.','David','Johnson','7990 Ocean Beach Hwy.','Longview','Washington','United States','98632'),
( 29889,'jean3@adventure-works.com','Ms.','Jean','Jordan','440 West Huntington Dr.','Monrovia','California','United States','91016'),
( 29890,'peggy0@adventure-works.com','Ms.','Peggy','Justice','15 East Main','Port Orchard','Washington','United States','98366'),
( 29891,'diane4@adventure-works.com','Ms.','Diane','Krane','46460 West Oaks Drive','Novi','Michigan','United States','48375'),
( 29892,'sandra2@adventure-works.com','Ms.','Sandra','Kitt','258 King Street East','Toronto','Ontario','Canada','M4B 1V7'),
( 29893,'sandeep1@adventure-works.com','Mr.','Sandeep','Kaliyath','630 N. Capitol Ave.','San Jose','California','United States','95112'),
( 29895,'lori2@adventure-works.com','Ms.','Lori','Kane','9693 Louis H Lafontaine','Ville De`anjou','Quebec','Canada','J1G 2R3'),
( 29897,'kay0@adventure-works.com','Ms.','Kay','Krane','Prime Outlets','Phoenix','Arizona','United States','85004'),
( 29898,'sandeep2@adventure-works.com','Mr.','Sandeep','Katyal','765 Delridge Way Sw','Seattle','Washington','United States','98104'),
( 29900,'victor0@adventure-works.com','Mr.','Victor','Kelley','2900 - 25055 Dunning Street','Vancouver','British Columbia','Canada','V7L 4J4'),
( 29901,'john22@adventure-works.com','Mr.','John','Kelly','Pacific West Outlet','Gilroy','California','United States','95020'),
( 29902,'robert7@adventure-works.com','Mr.','Robert','Kelly','6425 Nw Loop 410','San Antonio','Texas','United States','78204'),
( 29903,'kevin4@adventure-works.com','Mr.','Kevin','Kennedy','2550 Ne Sandy Blvd','Portland','Oregon','United States','97205'),
( 29904,'mary8@adventure-works.com','Ms.','Mary','Kesslep','Wharfdale Road','Berkshire','England','United Kingdom','RG11 5TP'),
( 29905,'elizabeth2@adventure-works.com','Ms.','Elizabeth','Keyser','6400, 888 - 3rd Avenue','Calgary','Alberta','Canada','T2P 2G8'),
( 29906,'imtiaz0@adventure-works.com','Mr.','Imtiaz','Khan','25095 W. Florissant','Ferguson','Missouri','United States','63135'),
( 29907,'karan1@adventure-works.com','Ms.','Karan','Khanna','755 W Washington Ave Ste D','Sequim','Washington','United States','98382'),
( 29908,'joe1@adventure-works.com','Mr.','Joe','Kim','308-3250 Casting Road','York','England','United Kingdom','Y024 1GF'),
( 29910,'shane2@adventure-works.com','Mr.','Shane','Kim','No. 25400 10665 Jasper Avenue','Edmonton','Alberta','Canada','T5'),
( 29911,'tim0@adventure-works.com','Mr.','Tim','Kim','25 Danger Street West','Toronto','Ontario','Canada','M4B 1V5'),
( 29913,'anton0@adventure-works.com','Mr.','Anton','Kirilov','2575 Rocky Mountain Ave.','Loveland','Colorado','United States','80537'),
( 29914,'christian1@adventure-works.com','Mr.','Christian','Kleinerman','25150 El Camino Real','San Bruno','California','United States','94066'),
( 29915,'andrew5@adventure-works.com','Mr.','Andrew','Kobylinski','2526a Tri-Lake Blvd Ne','Kirkland','Washington','United States','98033'),
( 29918,'kirk2@adventure-works.com','Mr.','Kirk','King','2521 McPherson Street','Markham','Ontario','Canada','L3S 3K2'),
( 29919,'eugene2@adventure-works.com','Mr.','Eugene','Kogan','6756 Mowry','Newark','California','United States','94560'),
( 29920,'scott6@adventure-works.com','Mr.','Scott','Konersmann','52500 Liberty Way','Fort Worth','Texas','United States','76102'),
( 29921,'joy0@adventure-works.com','Ms.','Joy','Koski','258101 Nw Evergreen Parkway','Beaverton','Oregon','United States','97005'),
( 29922,'pamala0@adventure-works.com','Ms.','Pamala','Kotc','Garamonde Drive, Wymbush','Milton Keynes','England','United Kingdom','MK8 8ZD'),
( 29924,'mitch0@adventure-works.com','Mr.','Mitch','Kennedy','C/O Starpak, Inc.','Greeley','Colorado','United States','80631'),
( 29925,'margaret1@adventure-works.com','Ms.','Margaret','Krupka','Great Northwestern','North Bend','Washington','United States','98045'),
( 29926,'deepak0@adventure-works.com','Mr.','Deepak','Kumar','255 Irving Street','London','England','United Kingdom','C2H 7AU'),
( 29928,'vamsi1@adventure-works.com','Mr.','Vamsi','Kuppa','3255 Front Street West','Toronto','Ontario','Canada','M4B 1V6'),
( 29929,'jeffrey3@adventure-works.com','Mr.','Jeffrey','Kurtz','Receiving','Fullerton','California','United States','92831'),
( 29930,'peter4@adventure-works.com','Mr.','Peter','Kurniawan','63 W Monroe','Chicago','Illinois','United States','60610'),
( 29931,'eric6@adventure-works.com','Mr.','Eric','Lang','25300 Biddle Road','Medford','Oregon','United States','97504'),
( 29932,'rebecca2@adventure-works.com','Ms.','Rebecca','Laszlo','Phoenix Way, Cirencester','Gloucestershire','England','United Kingdom','GL7 1RY'),
( 29934,'david19@adventure-works.com','Mr.','David','Lawrence','2512-4th Ave Sw','Calgary','Alberta','Canada','T2P 2G8'),
( 29935,'elsa0@adventure-works.com','Ms.','Elsa','Leavitt','2575 West 2700 South','Salt Lake City','Utah','United States','84101'),
( 29936,'michael18@adventure-works.com','Mr.','Michael','Lee','25718 Se Sunnyside Rd','Clackamas','Oregon','United States','97015-6403'),
( 29937,'marjorie0@adventure-works.com','Ms.','Marjorie','Lee','2509 W. Frankford','Carrollton','Texas','United States','75006'),
( 29938,'frank4@adventure-works.com','Mr.','Frank','Campbell','251340 E. South St.','Cerritos','California','United States','90703'),
( 29939,'mark5@adventure-works.com','Mr.','Mark','Lee','2512-410th Avenue S.W.','Calgary','Alberta','Canada','T2P 2G8'),
( 29941,'jolie0@adventure-works.com','Ms.','Jolie','Lenehan','Garamonde Drive, Wymbush','Milton Keynes','England','United Kingdom','MK8 8ZD'),
( 29942,'roger1@adventure-works.com','Mr.','Roger','Lengel','490 Ne 4th St','Renton','Washington','United States','98055'),
( 29943,'a0@adventure-works.com',NULL,'A.','Leonetti','5700 Legacy Dr','Plano','Texas','United States','75074'),
( 29944,'bonnie2@adventure-works.com','Ms.','Bonnie','Lepro','25600 E St Andrews Pl','Santa Ana','California','United States','92701'),
( 29946,'linda7@adventure-works.com','Ms.','Linda','Leste','630 University Avenue','Toronto','Ontario','Canada','M4B 1V7'),
( 29948,'elsie0@adventure-works.com','Ms.','Elsie','Lewin','P.O. Box 6256916','Dallas','Texas','United States','75201'),
( 29949,'george3@adventure-works.com','Mr.','George','Li','910 Main Street.','Sparks','Nevada','United States','89431'),
( 29950,'yale0@adventure-works.com','Mr.','Yale','Li','992 St Clair Ave East','Toronto','Ontario','Canada','M4B 1V7'),
( 29952,'yuhong1@adventure-works.com','Ms.','Yuhong','Li','Bradford','W. York','England','United Kingdom','BD1 4SJ'),
( 29953,'joseph2@adventure-works.com','Mr.','Joseph','Lique','257700 Ne 76th Street','Redmond','Washington','United States','98052'),
( 29954,'paulo0@adventure-works.com','Mr.','Paulo','Lisboa','Po Box 8259024','Dallas','Texas','United States','75201'),
( 29955,'david20@adventure-works.com','Mr.','David','Liu','855 East Main Avenue','Zeeland','Michigan','United States','49464'),
( 29956,'jinghao1@adventure-works.com',NULL,'Jinghao','Liu','90025 Sterling St','Irving','Texas','United States','75061'),
( 29957,'kevin5@adventure-works.com','Mr.','Kevin','Liu','9992 Whipple Rd','Union City','California','United States','94587'),
( 29959,'todd0@adventure-works.com','Mr.','Todd','Logan','575 Rue St Amable','Quebec','Quebec','Canada','G1R'),
( 29962,'sharon2@adventure-works.com','Ms.','Sharon','Looney','74400 France Avenue South','Edina','Minnesota','United States','55436'),
( 29964,'anita0@adventure-works.com','Ms.','Anita','Lucerne','6333 Cote Vertu','Montreal','Quebec','Canada','H1Y 2H7'),
( 29967,'judy1@adventure-works.com','Ms.','Judy','Lundahl','25149 Howard Dr','West Chicago','Illinois','United States','60185'),
( 29969,'robert8@adventure-works.com','Mr.','Robert','Lyeba','63 Free St.','Toronto','Ontario','Canada','M4B 1V4'),
( 29971,'robert9@adventure-works.com','Mr.','Robert','Lyon','609 Evans Avenue','Toronto','Ontario','Canada','M4B 1V4'),
( 29973,'denise1@adventure-works.com','Ms.','Denise','Maccietto','Port Huron','Port Huron','Michigan','United States','48060'),
( 29974,'scott7@adventure-works.com','Mr.','Scott','MacDonald','St. Louis Marketplace','Saint Louis','Missouri','United States','63103'),
( 29975,'walter1@adventure-works.com','Mr.','Walter','Mays','Po Box 252525','Santa Ana','California','United States','92701'),
( 29978,'ajay0@adventure-works.com','Mr.','Ajay','Manchepalli','25 Hartfield Road, Wimbledon','London','England','United Kingdom','SW19 3RU'),
( 29980,'tomas0@adventure-works.com','Mr.','Tomas','Manzanares','99 Dean Street, Soho','London','England','United Kingdom','W1V 5RN'),
( 29981,'kathy0@adventure-works.com','Ms.','Kathy','Marcovecchio','9905 Three Rivers Drive','Kelso','Washington','United States','98626'),
( 29982,'melissa0@adventure-works.com','Ms.','Melissa','Marple','603 Gellert Blvd','Daly City','California','United States','94015'),
( 29983,'cecelia0@adventure-works.com','Ms.','Cecelia','Marshall','9984 Wellington Street','Ottawa','Ontario','Canada','K4B 1S2'),
( 29985,'linda8@adventure-works.com','Ms.','Linda','Martin','Park House-4th Floor, 2516 Park St.','London','England','United Kingdom','W1Y 3RA'),
( 29987,'frank5@adventure-works.com','Mr.','Frank','Mart¡nez','870 N. 54th Ave.','Chandler','Arizona','United States','85225'),
( 29988,'steve2@adventure-works.com','Mr.','Steve','Masters','2545 King Street West','Toronto','Ontario','Canada','M4B 1V7'),
( 29990,'jennifer1@adventure-works.com','Ms.','Jennifer','Maxham','Butterfield Hse, 7-251 Chapel St','Lancaster','England','United Kingdom','LA1 1LN'),
( 29991,'chris6@adventure-works.com','Mr.','Chris','Maxwell','3025 E Waterway Blvd','Shelton','Washington','United States','98584'),
( 29992,'sandra4@adventure-works.com','Ms.','Sandra','Maynard','9952 E. Lohman Ave.','Las Cruces','New Mexico','United States','88001'),
( 29994,'robin0@adventure-works.com','Ms.','Robin','McGuigan','2500 University Avenue','Toronto','Ontario','Canada','M4B 1V5'),
( 29997,'lola0@adventure-works.com','Ms.','Lola','McCarthy','1050 Oak Street','Seattle','Washington','United States','98104'),
( 29998,'jane3@adventure-works.com','Ms.','Jane','McCarty','409 Santa Monica Blvd.','Santa Monica','California','United States','90401'),
( 30000,'james12@adventure-works.com','Mr.','James','McCoy','9900-6400 Boul, Taschereau','Brossard','Quebec','Canada','J4Z 1R4'),
( 30003,'yvonne1@adventure-works.com','Ms.','Yvonne','McKay','Horizon Outlet','Woodbury','Minnesota','United States','55125'),
( 30004,'nkenge0@adventure-works.com','Ms.','Nkenge','McLin','Frontier Mall','Cheyenne','Wyoming','United States','82001'),
( 30005,'nancy3@adventure-works.com','Ms.','Nancy','McPhearson','46-44 Albemarle Street','London','England','United Kingdom','W1X3SE'),
( 30007,'raquel0@adventure-works.com','Ms.','Raquel','Mello','No. 2000-25080 Beaver Hall Hill','Quebec','Quebec','Canada','G1R'),
( 30008,'rmorgan0@adventure-works.com','Mr.','R. Morgan','Mendoza','Johnson Creek','Johnson Creek','Wisconsin','United States','53038'),
( 30010,'stephen4@adventure-works.com','Mr.','Stephen','Mew','250 Kingsbridge Garden Circle','Mississauga','Ontario','Canada','L5B 3V4'),
( 30012,'helen2@adventure-works.com','Ms.','Helen','Meyer','7505 Laguna Boulevard','Elk Grove','California','United States','95624'),
( 30016,'thomas2@adventure-works.com','Mr.','Thomas','Michaels','5th Floor, 79 Place D`armes','Kingston','Ontario','Canada','7L'),
( 30018,'virginia0@adventure-works.com','Ms.','Virginia','Miller','25111 228th St Sw','Bothell','Washington','United States','98011'),
( 30019,'matthew5@adventure-works.com','Mr.','Matthew','Miller','Wymbush','Milton Keynes','England','United Kingdom','MK8 8DF'),
( 30021,'ben1@adventure-works.com','Mr.','Ben','Miller','Suite 500 995 W. 11th Avenue','Mississauga','Ontario','Canada','L5A 1H6'),
( 30022,'dylan1@adventure-works.com','Mr.','Dylan','Miller','Parkway Plaza','El Cajon','California','United States','92020'),
( 30023,'frank6@adventure-works.com','Mr.','Frank','Miller','123 W. Lake Ave.','Peoria','Illinois','United States','61606'),
( 30024,'neva0@adventure-works.com','Ms.','Neva','Mitchell','2528 Meridian E','Puyallup','Washington','United States','98371'),
( 30025,'linda9@adventure-works.com','Ms.','Linda','Mitchell','New Millhouse, 2583 Milton Park','Abingdon','England','United Kingdom','OX14 4SE'),
( 30027,'joseph4@adventure-works.com','Mr.','Joseph','Mitzner','123 Camelia Avenue','Oxnard','California','United States','93030'),
( 30028,'laura3@adventure-works.com','Ms.','Laura','Steele','253731 West Bell Road','Surprise','Arizona','United States','85374'),
( 30029,'shanay0@adventure-works.com','Ms.','Shanay','Steelman','5 place Ville-Marie','Montreal','Quebec','Canada','H1Y 2H7'),
( 30030,'stefano0@adventure-works.com','Mr.','Stefano','Stefani','997b Tradescant Road','London','England','United Kingdom','SW8 1XD'),
( 30031,'alan4@adventure-works.com','Mr.','Alan','Steiner','2255 254th Avenue Se','Albany','Oregon','United States','97321'),
( 30032,'derik0@adventure-works.com','Mr.','Derik','Stenerson','Factory Merchants','Branson','Missouri','United States','65616'),
( 30033,'vassar0@adventure-works.com','Mr.','Vassar','Stern','25130 South State Street','Sandy','Utah','United States','84070'),
( 30034,'wathalee0@adventure-works.com','Ms.','Wathalee','Steuber','700 Se Sunnyside Road','Clackamas','Oregon','United States','97015'),
( 30035,'alice4@adventure-works.com','Ms.','Alice','Steiner','Lone Star Factory','La Marque','Texas','United States','77568'),
( 30036,'lizamarie0@adventure-works.com','Ms.','Liza Marie','Stevens','7750 E Marching Rd','Scottsdale','Arizona','United States','85257'),
( 30037,'jim5@adventure-works.com','Mr.','Jim','Stewart','999 West Georgia St.','Vancouver','Ontario','Canada','V5T 1Y9'),
( 30039,'robert12@adventure-works.com','Mr.','Robert','Stotka','Sports Stores @ Tuscola','Tuscola','Illinois','United States','61953'),
( 30040,'kayla0@adventure-works.com','Ms.','Kayla','Stotler','9980 S Alma School Road','Chandler','Arizona','United States','85225'),
( 30042,'rubysue0@adventure-works.com','Ms.','Ruby Sue','Styles','46990 Viking Way','Richmond','British Columbia','Canada','V6B 3P7'),
( 30044,'gary5@adventure-works.com','Mr.','Gary','Suess','725a The Arches','Berks','England','United Kingdom','SL4 1RH'),
( 30045,'ruth2@adventure-works.com','Ms.','Ruth','Suffin','Lancaster Mall','Salem','Oregon','United States','97301'),
( 30046,'elizabeth4@adventure-works.com','Ms.','Elizabeth','Sullivan','Town East Center','Mesquite','Texas','United States','75149'),
( 30047,'michael24@adventure-works.com','Mr.','Michael','Sullivan','5867 Sunrise Boulevard','Citrus Heights','California','United States','95610'),
( 30048,'marcia0@adventure-works.com','Ms.','Marcia','Sultan','251420a 170th Street','Edmonton','Alberta','Canada','T5'),
( 30050,'krishna1@adventure-works.com','Mr.','Krishna','Sunkammurali','Paramount House','London','England','United Kingdom','W1N 9FA'),
( 30051,'brad0@adventure-works.com','Mr.','Brad','Sutton','Three Rivers Mall','Kelso','Washington','United States','98626'),
( 30052,'abraham0@adventure-works.com','Mr.','Abraham','Swearengin','9920 Bridgepointe Parkway','San Mateo','California','United States','94404'),
( 30053,'katherine1@adventure-works.com','Ms.','Katherine','Swan','975 Princess Street','Kingston','Ontario','Canada','7L'),
( 30055,'julie1@adventure-works.com','Ms.','Julie','Taft-Rider','6996 South Lindbergh','Saint Louis','Missouri','United States','63103'),
( 30056,'clarence0@adventure-works.com','Mr.','Clarence','Tatman','San Diego Factory','San Ysidro','California','United States','92173'),
( 30058,'mike6@adventure-works.com','Mr.','Mike','Taylor','750 Philip Street','Waterloo','Ontario','Canada','N2V'),
( 30061,'chad1@adventure-works.com','Mr.','Chad','Tedford','9500b E. Central Texas Expressway','Killeen','Texas','United States','76541'),
( 30063,'vanessa0@adventure-works.com','Ms.','Vanessa','Tench','2500 N Serene Blvd','El Segundo','California','United States','90245'),
( 30064,'judy3@adventure-works.com','Ms.','Judy','Thames','25102 Springwater','Wenatchee','Washington','United States','98801'),
( 30067,'phyllis2@adventure-works.com','Ms.','Phyllis','Thomas','99, Rue Saint-pierre','Pnot-Rouge','Quebec','Canada','J1E 2T7'),
( 30069,'donald1@adventure-works.com','Mr.','Donald','Thompson','25472 Marlay Ave','Fontana','California','United States','92335'),
( 30070,'kendra0@adventure-works.com','Ms.','Kendra','Thompson','22571 South 2500 East','Idaho Falls','Idaho','United States','83402'),
( 30071,'daniel2@adventure-works.com','Mr.','Daniel','Thompson','755 Nw Grandstand','Issaquah','Washington','United States','98027'),
( 30072,'andrea1@adventure-works.com','Ms.','Andrea','Thomsen','251 The Metro Center','Wokingham','England','United Kingdom','RG41 1QW'),
( 30074,'yuping0@adventure-works.com','Ms.','Yuping','Tian','Depot 80','Sillery','Quebec','Canada','G1T'),
( 30076,'diane5@adventure-works.com','Ms.','Diane','Tibbott','8525 South Parker Road','Parker','Colorado','United States','80138'),
( 30080,'delia0@adventure-works.com','Ms.','Delia','Toone','755 Columbia Ctr Blvd','Kennewick','Washington','United States','99337'),
( 30083,'glenn0@adventure-works.com','Mr.','Glenn','Track','55 Standish Court','Mississauga','Ontario','Canada','L5B 3V4'),
( 30087,'billy0@adventure-works.com','Mr.','Billy','Trent','99954 Boul. Laurier, Local 060, Place','Sainte-Foy','Quebec','Canada','G1W'),
( 30089,'michaeljohn0@adventure-works.com','Mr.','Michael John','Troyer','Oxnard Outlet','Oxnard','California','United States','93030'),
( 30090,'christie0@adventure-works.com','Ms.','Christie','Trujillo','One Dancing, Rr No. 25','Round Rock','Texas','United States','78664'),
( 30093,'phyllis3@adventure-works.com','Ms.','Phyllis','Tuffield','9960 King Street E.','Toronto','Ontario','Canada','M4B 1V5'),
( 30094,'sairaj1@adventure-works.com','Mr.','Sairaj','Uddin','Natomas Marketplace','Sacramento','California','United States','95814'),
( 30095,'sunil0@adventure-works.com','Mr.','Sunil','Uppal','25500 Old Spanish Trail','Houston','Texas','United States','77003'),
( 30098,'esther0@adventure-works.com','Ms.','Esther','Valle','600 Boul. Rene-levesque Ouest','Montreal','Quebec','Canada','H1Y 2H7'),
( 30100,'jessie0@adventure-works.com','Mr.','Jessie','Valerio','Mall Of Orange','Orange','California','United States','92867'),
( 30102,'roger2@adventure-works.com','Mr.','Roger','Van Houten','Internet House, 3399 Science Park','Cambridge','England','United Kingdom','CB4 4BZ'),
( 30104,'rose1@adventure-works.com','Ms.','Rose','Vandenouer','7 Garden House Cloisters, 8 Batters','London','England','United Kingdom','SW8 4BG'),
( 30105,'gregory1@adventure-works.com','Mr.','Gregory','Vanderbout','950 Gateway Street','Springfield','Oregon','United States','97477'),
( 30106,'michael25@adventure-works.com','Mr.','Michael','Vanderhyde','Lincoln Square','Arlington','Texas','United States','76010'),
( 30107,'margaret2@adventure-works.com','Ms.','Margaret','Vanderkamp','62500 Neil Road','Reno','Nevada','United States','89502'),
( 30108,'kara0@adventure-works.com','Ms.','Kara','Vanderlinden','2520 Flanders Road','Toronto','Ontario','Canada','M4B 1V4'),
( 30109,'nieves0@adventure-works.com','Mr.','Nieves','Vargas','Kensington Valley Shops','Howell','Michigan','United States','48843'),
( 30110,'gary6@adventure-works.com','Mr.','Gary','Vargas','Stevens Creek Shopping Center','San Jose','California','United States','95112'),
( 30111,'ranjit1@adventure-works.com','Mr.','Ranjit','Varkey Chudukatil','455 256th St.','Moline','Illinois','United States','61265'),
( 30112,'patricia2@adventure-works.com','Ms.','Patricia','Vasquez','409 S. Main Ste. 25','Ellensburg','Washington','United States','98926'),
( 30113,'raja0@adventure-works.com','Mr.','Raja','Venugopal','Burgess Hill','West Sussex','England','United Kingdom','RH15 9UD'),
( 30115,'dora0@adventure-works.com','Ms.','Dora','Verdad','Suite 2502 410 Albert Street','Waterloo','Ontario','Canada','N2V'),
( 30116,'wanda0@adventure-works.com','Ms.','Wanda','Vernon','Ontario Mills','Ontario','California','United States','91764'),
( 30117,'robert13@adventure-works.com','Mr.','Robert','Vessa','72540 Blanco Rd.','San Antonio','Texas','United States','78204'),
( 30118,'caroline0@adventure-works.com','Ms.','Caroline','Vicknair','660 Lindbergh','Saint Louis','Missouri','United States','63103');
GO
IF EXISTS (
SELECT * FROM sys.sysobjects
WHERE name = 'DimDate')
DROP TABLE dbo.DimDate;
GO
CREATE TABLE dbo.DimDate
(
DateKey INT NOT NULL,
DateAltKey DATE NOT NULL,
DayOfWeek INT NOT NULL,
WeekDayName VARCHAR(10),
DayOfMonth INT NOT NULL,
[Month] INT NOT NULL,
MonthName VARCHAR(12),
[Year] INT NOT NULL
);
GO
INSERT INTO dbo.DimDate
VALUES
(20210101,'01/01/2021',6,'Friday',1,1,'January',2021),
(20210102,'01/02/2021',7,'Saturday',2,1,'January',2021),
(20210103,'01/03/2021',1,'Sunday',3,1,'January',2021),
(20210104,'01/04/2021',2,'Monday',4,1,'January',2021),
(20210105,'01/05/2021',3,'Tuesday',5,1,'January',2021),
(20210106,'01/06/2021',4,'Wednesday',6,1,'January',2021),
(20210107,'01/07/2021',5,'Thursday',7,1,'January',2021),
(20210108,'01/08/2021',6,'Friday',8,1,'January',2021),
(20210109,'01/09/2021',7,'Saturday',9,1,'January',2021),
(20210110,'01/10/2021',1,'Sunday',10,1,'January',2021),
(20210111,'01/11/2021',2,'Monday',11,1,'January',2021),
(20210112,'01/12/2021',3,'Tuesday',12,1,'January',2021),
(20210113,'01/13/2021',4,'Wednesday',13,1,'January',2021),
(20210114,'01/14/2021',5,'Thursday',14,1,'January',2021),
(20210115,'01/15/2021',6,'Friday',15,1,'January',2021),
(20210116,'01/16/2021',7,'Saturday',16,1,'January',2021),
(20210117,'01/17/2021',1,'Sunday',17,1,'January',2021),
(20210118,'01/18/2021',2,'Monday',18,1,'January',2021),
(20210119,'01/19/2021',3,'Tuesday',19,1,'January',2021),
(20210120,'01/20/2021',4,'Wednesday',20,1,'January',2021),
(20210121,'01/21/2021',5,'Thursday',21,1,'January',2021),
(20210122,'01/22/2021',6,'Friday',22,1,'January',2021),
(20210123,'01/23/2021',7,'Saturday',23,1,'January',2021),
(20210124,'01/24/2021',1,'Sunday',24,1,'January',2021),
(20210125,'01/25/2021',2,'Monday',25,1,'January',2021),
(20210126,'01/26/2021',3,'Tuesday',26,1,'January',2021),
(20210127,'01/27/2021',4,'Wednesday',27,1,'January',2021),
(20210128,'01/28/2021',5,'Thursday',28,1,'January',2021),
(20210129,'01/29/2021',6,'Friday',29,1,'January',2021),
(20210130,'01/30/2021',7,'Saturday',30,1,'January',2021),
(20210131,'01/31/2021',1,'Sunday',31,1,'January',2021),
(20210201,'02/01/2021',2,'Monday',1,2,'February',2021),
(20210202,'02/02/2021',3,'Tuesday',2,2,'February',2021),
(20210203,'02/03/2021',4,'Wednesday',3,2,'February',2021),
(20210204,'02/04/2021',5,'Thursday',4,2,'February',2021),
(20210205,'02/05/2021',6,'Friday',5,2,'February',2021),
(20210206,'02/06/2021',7,'Saturday',6,2,'February',2021),
(20210207,'02/07/2021',1,'Sunday',7,2,'February',2021),
(20210208,'02/08/2021',2,'Monday',8,2,'February',2021),
(20210209,'02/09/2021',3,'Tuesday',9,2,'February',2021),
(20210210,'02/10/2021',4,'Wednesday',10,2,'February',2021),
(20210211,'02/11/2021',5,'Thursday',11,2,'February',2021),
(20210212,'02/12/2021',6,'Friday',12,2,'February',2021),
(20210213,'02/13/2021',7,'Saturday',13,2,'February',2021),
(20210214,'02/14/2021',1,'Sunday',14,2,'February',2021),
(20210215,'02/15/2021',2,'Monday',15,2,'February',2021),
(20210216,'02/16/2021',3,'Tuesday',16,2,'February',2021),
(20210217,'02/17/2021',4,'Wednesday',17,2,'February',2021),
(20210218,'02/18/2021',5,'Thursday',18,2,'February',2021),
(20210219,'02/19/2021',6,'Friday',19,2,'February',2021),
(20210220,'02/20/2021',7,'Saturday',20,2,'February',2021),
(20210221,'02/21/2021',1,'Sunday',21,2,'February',2021),
(20210222,'02/22/2021',2,'Monday',22,2,'February',2021),
(20210223,'02/23/2021',3,'Tuesday',23,2,'February',2021),
(20210224,'02/24/2021',4,'Wednesday',24,2,'February',2021),
(20210225,'02/25/2021',5,'Thursday',25,2,'February',2021),
(20210226,'02/26/2021',6,'Friday',26,2,'February',2021),
(20210227,'02/27/2021',7,'Saturday',27,2,'February',2021),
(20210228,'02/28/2021',1,'Sunday',28,2,'February',2021),
(20210301,'03/01/2021',2,'Monday',1,3,'March',2021),
(20210302,'03/02/2021',3,'Tuesday',2,3,'March',2021),
(20210303,'03/03/2021',4,'Wednesday',3,3,'March',2021),
(20210304,'03/04/2021',5,'Thursday',4,3,'March',2021),
(20210305,'03/05/2021',6,'Friday',5,3,'March',2021),
(20210306,'03/06/2021',7,'Saturday',6,3,'March',2021),
(20210307,'03/07/2021',1,'Sunday',7,3,'March',2021),
(20210308,'03/08/2021',2,'Monday',8,3,'March',2021),
(20210309,'03/09/2021',3,'Tuesday',9,3,'March',2021),
(20210310,'03/10/2021',4,'Wednesday',10,3,'March',2021),
(20210311,'03/11/2021',5,'Thursday',11,3,'March',2021),
(20210312,'03/12/2021',6,'Friday',12,3,'March',2021),
(20210313,'03/13/2021',7,'Saturday',13,3,'March',2021),
(20210314,'03/14/2021',1,'Sunday',14,3,'March',2021),
(20210315,'03/15/2021',2,'Monday',15,3,'March',2021),
(20210316,'03/16/2021',3,'Tuesday',16,3,'March',2021),
(20210317,'03/17/2021',4,'Wednesday',17,3,'March',2021),
(20210318,'03/18/2021',5,'Thursday',18,3,'March',2021),
(20210319,'03/19/2021',6,'Friday',19,3,'March',2021),
(20210320,'03/20/2021',7,'Saturday',20,3,'March',2021),
(20210321,'03/21/2021',1,'Sunday',21,3,'March',2021),
(20210322,'03/22/2021',2,'Monday',22,3,'March',2021),
(20210323,'03/23/2021',3,'Tuesday',23,3,'March',2021),
(20210324,'03/24/2021',4,'Wednesday',24,3,'March',2021),
(20210325,'03/25/2021',5,'Thursday',25,3,'March',2021),
(20210326,'03/26/2021',6,'Friday',26,3,'March',2021),
(20210327,'03/27/2021',7,'Saturday',27,3,'March',2021),
(20210328,'03/28/2021',1,'Sunday',28,3,'March',2021),
(20210329,'03/29/2021',2,'Monday',29,3,'March',2021),
(20210330,'03/30/2021',3,'Tuesday',30,3,'March',2021),
(20210331,'03/31/2021',4,'Wednesday',31,3,'March',2021),
(20210401,'04/01/2021',5,'Thursday',1,4,'April',2021),
(20210402,'04/02/2021',6,'Friday',2,4,'April',2021),
(20210403,'04/03/2021',7,'Saturday',3,4,'April',2021),
(20210404,'04/04/2021',1,'Sunday',4,4,'April',2021),
(20210405,'04/05/2021',2,'Monday',5,4,'April',2021),
(20210406,'04/06/2021',3,'Tuesday',6,4,'April',2021),
(20210407,'04/07/2021',4,'Wednesday',7,4,'April',2021),
(20210408,'04/08/2021',5,'Thursday',8,4,'April',2021),
(20210409,'04/09/2021',6,'Friday',9,4,'April',2021),
(20210410,'04/10/2021',7,'Saturday',10,4,'April',2021),
(20210411,'04/11/2021',1,'Sunday',11,4,'April',2021),
(20210412,'04/12/2021',2,'Monday',12,4,'April',2021),
(20210413,'04/13/2021',3,'Tuesday',13,4,'April',2021),
(20210414,'04/14/2021',4,'Wednesday',14,4,'April',2021),
(20210415,'04/15/2021',5,'Thursday',15,4,'April',2021),
(20210416,'04/16/2021',6,'Friday',16,4,'April',2021),
(20210417,'04/17/2021',7,'Saturday',17,4,'April',2021),
(20210418,'04/18/2021',1,'Sunday',18,4,'April',2021),
(20210419,'04/19/2021',2,'Monday',19,4,'April',2021),
(20210420,'04/20/2021',3,'Tuesday',20,4,'April',2021),
(20210421,'04/21/2021',4,'Wednesday',21,4,'April',2021),
(20210422,'04/22/2021',5,'Thursday',22,4,'April',2021),
(20210423,'04/23/2021',6,'Friday',23,4,'April',2021),
(20210424,'04/24/2021',7,'Saturday',24,4,'April',2021),
(20210425,'04/25/2021',1,'Sunday',25,4,'April',2021),
(20210426,'04/26/2021',2,'Monday',26,4,'April',2021),
(20210427,'04/27/2021',3,'Tuesday',27,4,'April',2021),
(20210428,'04/28/2021',4,'Wednesday',28,4,'April',2021),
(20210429,'04/29/2021',5,'Thursday',29,4,'April',2021),
(20210430,'04/30/2021',6,'Friday',30,4,'April',2021),
(20210501,'05/01/2021',7,'Saturday',1,5,'May',2021),
(20210502,'05/02/2021',1,'Sunday',2,5,'May',2021),
(20210503,'05/03/2021',2,'Monday',3,5,'May',2021),
(20210504,'05/04/2021',3,'Tuesday',4,5,'May',2021),
(20210505,'05/05/2021',4,'Wednesday',5,5,'May',2021),
(20210506,'05/06/2021',5,'Thursday',6,5,'May',2021),
(20210507,'05/07/2021',6,'Friday',7,5,'May',2021),
(20210508,'05/08/2021',7,'Saturday',8,5,'May',2021),
(20210509,'05/09/2021',1,'Sunday',9,5,'May',2021),
(20210510,'05/10/2021',2,'Monday',10,5,'May',2021),
(20210511,'05/11/2021',3,'Tuesday',11,5,'May',2021),
(20210512,'05/12/2021',4,'Wednesday',12,5,'May',2021),
(20210513,'05/13/2021',5,'Thursday',13,5,'May',2021),
(20210514,'05/14/2021',6,'Friday',14,5,'May',2021),
(20210515,'05/15/2021',7,'Saturday',15,5,'May',2021),
(20210516,'05/16/2021',1,'Sunday',16,5,'May',2021),
(20210517,'05/17/2021',2,'Monday',17,5,'May',2021),
(20210518,'05/18/2021',3,'Tuesday',18,5,'May',2021),
(20210519,'05/19/2021',4,'Wednesday',19,5,'May',2021),
(20210520,'05/20/2021',5,'Thursday',20,5,'May',2021),
(20210521,'05/21/2021',6,'Friday',21,5,'May',2021),
(20210522,'05/22/2021',7,'Saturday',22,5,'May',2021),
(20210523,'05/23/2021',1,'Sunday',23,5,'May',2021),
(20210524,'05/24/2021',2,'Monday',24,5,'May',2021),
(20210525,'05/25/2021',3,'Tuesday',25,5,'May',2021),
(20210526,'05/26/2021',4,'Wednesday',26,5,'May',2021),
(20210527,'05/27/2021',5,'Thursday',27,5,'May',2021),
(20210528,'05/28/2021',6,'Friday',28,5,'May',2021),
(20210529,'05/29/2021',7,'Saturday',29,5,'May',2021),
(20210530,'05/30/2021',1,'Sunday',30,5,'May',2021),
(20210531,'05/31/2021',2,'Monday',31,5,'May',2021),
(20210601,'06/01/2021',3,'Tuesday',1,6,'June',2021),
(20210602,'06/02/2021',4,'Wednesday',2,6,'June',2021),
(20210603,'06/03/2021',5,'Thursday',3,6,'June',2021),
(20210604,'06/04/2021',6,'Friday',4,6,'June',2021),
(20210605,'06/05/2021',7,'Saturday',5,6,'June',2021),
(20210606,'06/06/2021',1,'Sunday',6,6,'June',2021),
(20210607,'06/07/2021',2,'Monday',7,6,'June',2021),
(20210608,'06/08/2021',3,'Tuesday',8,6,'June',2021),
(20210609,'06/09/2021',4,'Wednesday',9,6,'June',2021),
(20210610,'06/10/2021',5,'Thursday',10,6,'June',2021),
(20210611,'06/11/2021',6,'Friday',11,6,'June',2021),
(20210612,'06/12/2021',7,'Saturday',12,6,'June',2021),
(20210613,'06/13/2021',1,'Sunday',13,6,'June',2021),
(20210614,'06/14/2021',2,'Monday',14,6,'June',2021),
(20210615,'06/15/2021',3,'Tuesday',15,6,'June',2021),
(20210616,'06/16/2021',4,'Wednesday',16,6,'June',2021),
(20210617,'06/17/2021',5,'Thursday',17,6,'June',2021),
(20210618,'06/18/2021',6,'Friday',18,6,'June',2021),
(20210619,'06/19/2021',7,'Saturday',19,6,'June',2021),
(20210620,'06/20/2021',1,'Sunday',20,6,'June',2021),
(20210621,'06/21/2021',2,'Monday',21,6,'June',2021),
(20210622,'06/22/2021',3,'Tuesday',22,6,'June',2021),
(20210623,'06/23/2021',4,'Wednesday',23,6,'June',2021),
(20210624,'06/24/2021',5,'Thursday',24,6,'June',2021),
(20210625,'06/25/2021',6,'Friday',25,6,'June',2021),
(20210626,'06/26/2021',7,'Saturday',26,6,'June',2021),
(20210627,'06/27/2021',1,'Sunday',27,6,'June',2021),
(20210628,'06/28/2021',2,'Monday',28,6,'June',2021),
(20210629,'06/29/2021',3,'Tuesday',29,6,'June',2021),
(20210630,'06/30/2021',4,'Wednesday',30,6,'June',2021),
(20210701,'07/01/2021',5,'Thursday',1,7,'July',2021),
(20210702,'07/02/2021',6,'Friday',2,7,'July',2021),
(20210703,'07/03/2021',7,'Saturday',3,7,'July',2021),
(20210704,'07/04/2021',1,'Sunday',4,7,'July',2021),
(20210705,'07/05/2021',2,'Monday',5,7,'July',2021),
(20210706,'07/06/2021',3,'Tuesday',6,7,'July',2021),
(20210707,'07/07/2021',4,'Wednesday',7,7,'July',2021),
(20210708,'07/08/2021',5,'Thursday',8,7,'July',2021),
(20210709,'07/09/2021',6,'Friday',9,7,'July',2021),
(20210710,'07/10/2021',7,'Saturday',10,7,'July',2021),
(20210711,'07/11/2021',1,'Sunday',11,7,'July',2021),
(20210712,'07/12/2021',2,'Monday',12,7,'July',2021),
(20210713,'07/13/2021',3,'Tuesday',13,7,'July',2021),
(20210714,'07/14/2021',4,'Wednesday',14,7,'July',2021),
(20210715,'07/15/2021',5,'Thursday',15,7,'July',2021),
(20210716,'07/16/2021',6,'Friday',16,7,'July',2021),
(20210717,'07/17/2021',7,'Saturday',17,7,'July',2021),
(20210718,'07/18/2021',1,'Sunday',18,7,'July',2021),
(20210719,'07/19/2021',2,'Monday',19,7,'July',2021),
(20210720,'07/20/2021',3,'Tuesday',20,7,'July',2021),
(20210721,'07/21/2021',4,'Wednesday',21,7,'July',2021),
(20210722,'07/22/2021',5,'Thursday',22,7,'July',2021),
(20210723,'07/23/2021',6,'Friday',23,7,'July',2021),
(20210724,'07/24/2021',7,'Saturday',24,7,'July',2021),
(20210725,'07/25/2021',1,'Sunday',25,7,'July',2021),
(20210726,'07/26/2021',2,'Monday',26,7,'July',2021),
(20210727,'07/27/2021',3,'Tuesday',27,7,'July',2021),
(20210728,'07/28/2021',4,'Wednesday',28,7,'July',2021),
(20210729,'07/29/2021',5,'Thursday',29,7,'July',2021),
(20210730,'07/30/2021',6,'Friday',30,7,'July',2021),
(20210731,'07/31/2021',7,'Saturday',31,7,'July',2021),
(20210801,'08/01/2021',1,'Sunday',1,8,'August',2021),
(20210802,'08/02/2021',2,'Monday',2,8,'August',2021),
(20210803,'08/03/2021',3,'Tuesday',3,8,'August',2021),
(20210804,'08/04/2021',4,'Wednesday',4,8,'August',2021),
(20210805,'08/05/2021',5,'Thursday',5,8,'August',2021),
(20210806,'08/06/2021',6,'Friday',6,8,'August',2021),
(20210807,'08/07/2021',7,'Saturday',7,8,'August',2021),
(20210808,'08/08/2021',1,'Sunday',8,8,'August',2021),
(20210809,'08/09/2021',2,'Monday',9,8,'August',2021),
(20210810,'08/10/2021',3,'Tuesday',10,8,'August',2021),
(20210811,'08/11/2021',4,'Wednesday',11,8,'August',2021),
(20210812,'08/12/2021',5,'Thursday',12,8,'August',2021),
(20210813,'08/13/2021',6,'Friday',13,8,'August',2021),
(20210814,'08/14/2021',7,'Saturday',14,8,'August',2021),
(20210815,'08/15/2021',1,'Sunday',15,8,'August',2021),
(20210816,'08/16/2021',2,'Monday',16,8,'August',2021),
(20210817,'08/17/2021',3,'Tuesday',17,8,'August',2021),
(20210818,'08/18/2021',4,'Wednesday',18,8,'August',2021),
(20210819,'08/19/2021',5,'Thursday',19,8,'August',2021),