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,'[email protected]','Ms.','Catherine','Abel','57251 Serene Blvd','Van Nuys','California','United States','91411'),
( 29486,'[email protected]','Ms.','Kim','Abercrombie','Tanger Factory','Branch','Minnesota','United States','55056'),
( 29489,'[email protected]','Ms.','Frances','Adams','6900 Sisk Road','Modesto','California','United States','95354'),
( 29490,'[email protected]','Ms.','Margaret','Smith','Lewiston Mall','Lewiston','Idaho','United States','83501'),
( 29492,'[email protected]','Mr.','Jay','Adams','Blue Ridge Mall','Kansas City','Missouri','United States','64106'),
( 29494,'[email protected]','Mr.','Samuel','Agcaoili','No. 25800-130 King Street West','Toronto','Ontario','Canada','M4B 1V5'),
( 29496,'[email protected]','Mr.','Robert','Ahlering','6500 East Grant Road','Tucson','Arizona','United States','85701'),
( 29497,'franç[email protected]','Mr.','François','Ferrier','Eastridge Mall','Casper','Wyoming','United States','82601'),
( 29499,'[email protected]','Ms.','Amy','Alberts','252851 Rowan Place','Richmond','British Columbia','Canada','V6B 3P7'),
( 29502,'[email protected]','Mr.','Paul','Alcorn','White Mountain Mall','Rock Springs','Wyoming','United States','82901'),
( 29503,'[email protected]','Mr.','Gregory','Alderson','25981 College Street','Montreal','Quebec','Canada','H1Y 2H5'),
( 29505,'[email protected]','Ms.','Michelle','Alexander','22589 West Craig Road','North Las Vegas','Nevada','United States','89030'),
( 29506,'[email protected]','Mr.','Sean','Jacobson','2551 East Warner Road','Gilbert','Arizona','United States','85233'),
( 29508,'[email protected]','Mr.','Marvin','Allen','First Colony Mall','Sugar Land','Texas','United States','77478'),
( 29510,'[email protected]','Mr.','Cecil','Allison','254 Colonnade Road','Nepean','Ontario','Canada','K2J 2W5'),
( 29511,'[email protected]','Mr.','Oscar','Alpuerto','Rocky Mountain Pines Outlet','Loveland','Colorado','United States','80537'),
( 29515,'[email protected]','Mr.','Maxwell','Amland','Suite 99320 255 - 510th Avenue S.W.','Calgary','Alberta','Canada','T2P 2G8'),
( 29517,'[email protected]','Ms.','Ramona','Antrim','998 Forest Road','Saginaw','Michigan','United States','48601'),
( 29521,'[email protected]','Mr.','Tom','Johnston','Belz Factory Outlet','Las Vegas','Nevada','United States','89106'),
( 29522,'[email protected]','Mr.','Thomas','Armstrong','Fox Hills','Culver City','California','United States','90232'),
( 29523,'[email protected]','Mr.','John','Arthur','2345 North Freeway','Houston','Texas','United States','77003'),
( 29524,'[email protected]','Mr.','Chris','Ashton','70 N.W. Plaza','Saint Ann','Missouri','United States','63074'),
( 29525,'[email protected]','Ms.','Teresa','Atkinson','The Citadel Commerce Plaza','City Of Commerce','California','United States','90040'),
( 29527,'[email protected]','Mr.','Robert','Avalos','700 Bureau Road','Montreal','Quebec','Canada','H1Y 2H7'),
( 29528,'[email protected]','Mr.','Stephen','Ayers','2533 Eureka Rd.','Southgate','Michigan','United States','48195'),
( 29530,'[email protected]','Mr.','Daniel','Blanco','Suite 800 2530 Slater Street','Ottawa','Ontario','Canada','K4B 1T7'),
( 29531,'[email protected]','Mr.','Cory','Booth','Eastern Beltway Center','Las Vegas','Nevada','United States','89106'),
( 29532,'[email protected]','Mr.','James','Bailey','Southgate Mall','Missoula','Montana','United States','59801'),
( 29533,'[email protected]','Mr.','Douglas','Baldwin','Horizon Outlet Center','Holland','Michigan','United States','49423'),
( 29535,'[email protected]','Mr.','Wayne','Banack','48255 I-10 E. @ Eastpoint Blvd.','Baytown','Texas','United States','77520'),
( 29536,'[email protected]','Mr.','Robert','Barker','6789 Warren Road','Westland','Michigan','United States','48185'),
( 29539,'[email protected]','Mr.','Josh','Barnhill','25 First Canadian Place','Toronto','Ontario','Canada','M4B 1V5'),
( 29541,'[email protected]',NULL,'Gytis','Barzdukas','25900-700-9th Ave S.W.','Calgary','Alberta','Canada','T2P 2G8'),
( 29544,'[email protected]','Mr.','Shaun','Beasley','2500-622 5th Ave Sw','Calgary','Alberta','Canada','T2P 2G8'),
( 29545,'[email protected]','Mr.','John','Beaver','1318 Lasalle Street','Bothell','Washington','United States','98011'),
( 29546,'[email protected]','Mr.','Christopher','Beck','93-2501, Blackfriars Road,','London','England','United Kingdom','SE1 8HL'),
( 29548,'[email protected]','Ms.','Ann','Beebe','25537 Hillside Avenue','Victoria','British Columbia','Canada','V8V'),
( 29550,'[email protected]','Mr.','Stanley','Alan','567 Sw Mcloughlin Blvd','Milwaukie','Oregon','United States','97222'),
( 29553,'[email protected]','Ms.','Edna','Benson','Po Box 8035996','Dallas','Texas','United States','75201'),
( 29554,'[email protected]','Mr.','Payton','Benson','997000 Telegraph Rd.','Southfield','Michigan','United States','48034'),
( 29557,'[email protected]','Mr.','Alexander','Berger','253711 Mayfield Place, Unit 150','Richmond','British Columbia','Canada','V6B 3P7'),
( 29558,'[email protected]','Mr.','John','Berger','5700 Explorer Drive','Mississauga','Ontario','Canada','L4W 5J3'),
( 29559,'[email protected]','Mr.','Robert','Bernacchi','2681 Eagle Peak','Bellevue','Washington','United States','98004'),
( 29560,'[email protected]','Mr.','Matthias','Berndt','Escondido','Escondido','California','United States','92025'),
( 29562,'[email protected]','Mr.','Steven','Brown','5500 Grossmont Center Drive','La Mesa','California','United States','91941'),
( 29565,'[email protected]','Mr.','Jimmy','Bischoff','3065 Santa Margarita Parkway','Trabuco Canyon','California','United States','92679'),
( 29566,'[email protected]','Ms.','Mae','Black','Redford Plaza','Redford','Michigan','United States','48239'),
( 29567,'[email protected]','Ms.','Jackie','Blackwell','2575 Bloor Street East','Toronto','Ontario','Canada','M4B 1V6'),
( 29568,'[email protected]','Mr.','Donald','Blanton','Corporate Office','El Segundo','California','United States','90245'),
( 29569,'[email protected]','Ms.','Linda','Burnett','2505 Gateway Drive','North Sioux City','South Dakota','United States','57049'),
( 29570,'[email protected]','Mr.','Michael','Blythe','9903 Highway 6 South','Houston','Texas','United States','77003'),
( 29571,'[email protected]','Ms.','Gabriel','Bockenkamp','67 Rainer Ave S','Renton','Washington','United States','98055'),
( 29573,'[email protected]','Sr.','Luis','Bonifaz','72502 Eastern Ave.','Bell Gardens','California','United States','90201'),
( 29574,'[email protected]','Mr.','Randall','Boseman','2500 North Stemmons Freeway','Dallas','Texas','United States','75201'),
( 29576,'[email protected]','Mr.','Eli','Bowen','63 West Beaver Creek','Richmond Hill','Ontario','Canada','L4E 3M5'),
( 29577,'[email protected]','Mr.','Lester','Bowman','770 Notre Datme Quest Bureau 800','Montreal','Quebec','Canada','H1Y 2H7'),
( 29579,'[email protected]','Mr.','Cornelius','Brandon','789 West Alameda','Westminster','Colorado','United States','80030'),
( 29580,'[email protected]','Mr.','Richard','Bready','4251 First Avenue','Seattle','Washington','United States','98104'),
( 29582,'[email protected]','Mr.','Ted','Bremer','Bldg. 9n/99298','Redmond','Washington','United States','98052'),
( 29583,'[email protected]','Mr.','Alan','Brewer','4255 East Lies Road','Carol Stream','Illinois','United States','60188'),
( 29584,'[email protected]','Mr.','Walter','Brian','25136 Jefferson Blvd.','Culver City','California','United States','90232'),
( 29585,'[email protected]','Mr.','Christopher','Bright','Washington Square','Portland','Oregon','United States','97205'),
( 29587,'[email protected]','Mr.','John','Brooks','99-3 Forest Works','London','England','United Kingdom','E17 6JF'),
( 29588,'[email protected]','Mr.','Willie','Brooks','Holiday Village Mall','Great Falls','Montana','United States','59401'),
( 29590,'[email protected]','Mr.','Jo','Brown','250000 Eight Mile Road','Detroit','Michigan','United States','48226'),
( 29591,'[email protected]','Mr.','Robert','Brown','250880 Baur Blvd','Saint Louis','Missouri','United States','63103'),
( 29593,'[email protected]','Ms.','Mary','Browning','Noah Lane','Chicago','Illinois','United States','60610'),
( 29596,'[email protected]','Mr.','Eric','Brumfield','600 Slater Street','Ottawa','Ontario','Canada','K4B 1S2'),
( 29598,'[email protected]','Mr.','Michael','Brundage','22555 Paseo De Las Americas','San Diego','California','United States','92102'),
( 29599,'[email protected]','Ms.','Shirley','Bruner','4781 Highway 95','Sandpoint','Idaho','United States','83864'),
( 29600,'[email protected]','Ms.','June','Brunner','678 Eastman Ave.','Midland','Michigan','United States','48640'),
( 29601,'[email protected]','Mr.','Dirk','Bruno','251 Indell Lane','Brampton','Ontario','Canada','L6W 2T7'),
( 29603,'[email protected]','Sra.','Janaina Barreiro Gambaro','Bueno','995 Crescent','Richmond Hill','Ontario','Canada','L4E 3M5'),
( 29605,'[email protected]','Ms.','Megan','Burke','Arcadia Crossing','Phoenix','Arizona','United States','85004'),
( 29606,'[email protected]','Ms.','Karren','Burkhardt','2502 Evergreen Ste E','Everett','Washington','United States','98201'),
( 29608,'[email protected]','Mr.','Timothy','Burnett','45259 Canada Way','Burnaby','British Columbia','Canada','V5G 4S4'),
( 29611,'[email protected]','Mr.','Jared','Bustamante','3307 Evergreen Blvd','Washougal','Washington','United States','98671'),
( 29612,'[email protected]','Mr.','Richard','Byham','Knaves Beech Ind.','High Wycombe','England','United Kingdom','HP10 9QY'),
( 29614,'[email protected]','Mr.','Ryan','Calafato','254480 River Rd','Richmond','British Columbia','Canada','V6B 3P7'),
( 29615,'[email protected]','Ms.','Mari','Caldwell','2524 Barlby Road','London','England','United Kingdom','W10 6BL'),
( 29616,'[email protected]','Ms.','Barbara','Calone','25306 Harvey Rd.','College Station','Texas','United States','77840'),
( 29617,'[email protected]','Ms.','Lindsey','Camacho','S Sound Ctr Suite 25300','Lacey','Washington','United States','98503'),
( 29618,'[email protected]','Sr.','Gustavo','Camargo','Ellesfield Ave','Bracknell','England','United Kingdom','RG12 8TB'),
( 29620,'[email protected]','Ms.','Joan','Campbell','P.O. Box 44000','Winnipeg','Manitoba','Canada','R3'),
( 29622,'[email protected]','Mr.','Henry','Campen','2507 Pacific Ave S','Tacoma','Washington','United States','98403'),
( 29623,'[email protected]','Mr.','Chris','Cannon','Lakewood Mall','Lakewood','California','United States','90712'),
( 29625,'[email protected]','Ms.','Suzana De Abreu','Canuto','20225 Lansing Ave','Montreal','Quebec','Canada','H1Y 2H7'),
( 29627,'[email protected]','Mr.','Johnny','Caprio','22580 Free Street','Toronto','Ontario','Canada','M4B 1V7'),
( 29629,'[email protected]','Mr.','Carlton','Carlisle','400-25155 West Pender St','Vancouver','British Columbia','Canada','V7L 4J4'),
( 29631,'[email protected]','Ms.','Jane','Carmichael','5967 W Las Positas Blvd','Pleasanton','California','United States','94566'),
( 29632,'[email protected]','Ms.','Jovita','Carmody','253950 N.E. 178th Place','Woodinville','Washington','United States','98072'),
( 29635,'[email protected]','Mr.','Rob','Caron','Ward Parkway Center','Kansas City','Missouri','United States','64106'),
( 29636,'[email protected]','Mr.','Andy','Carothers','566 S. Main','Cedar City','Utah','United States','84720'),
( 29637,'[email protected]','Ms.','Donna','Carreras','12345 Sterling Avenue','Irving','Texas','United States','75061'),
( 29638,'[email protected]','Ms.','Rosmarie','Carroll','39933 Mission Oaks Blvd','Camarillo','California','United States','93010'),
( 29639,'[email protected]','Mr.','Joseph','Castellucio','2511 Baker Road','Toronto','Ontario','Canada','M4B 1V7'),
( 29641,'[email protected]','Mr.','Raul','Casts','99040 California Avenue','Sand City','California','United States','93955'),
( 29643,'[email protected]','Mr.','Matthew','Cavallari','North 93270 Newport Highway','Spokane','Washington','United States','99202'),
( 29644,'[email protected]','Ms.','Brigid','Cavendish','Banbury','Oxon','England','United Kingdom','OX16 8RS'),
( 29645,'[email protected]','Mr.','Andrew','Cencini','558 S 6th St','Klamath Falls','Oregon','United States','97601'),
( 29646,'[email protected]','Ms.','Stacey','Cereghino','220 Mercy Drive','Garland','Texas','United States','75040'),
( 29649,'[email protected]','Mr.','Pat','Chambers','30025 Wayburne Drive, Suite 275','Burnaby','British Columbia','Canada','V5G 4W1'),
( 29650,'[email protected]','Mr.','Forrest','Chandler','The Quad @ WestView','Whittier','California','United States','90605'),
( 29651,'[email protected]','Mr.','Lee','Chapla','99433 S. Greenbay Rd.','Racine','Wisconsin','United States','53182'),
( 29653,'[email protected]','Mr.','Pei','Chow','4660 Rodeo Road','Santa Fe','New Mexico','United States','87501'),
( 29654,'[email protected]','Mr.','Yao-Qiang','Cheng','25 N State St','Chicago','Illinois','United States','60610'),
( 29655,'[email protected]','Ms.','Nicky','Chesnut','9920 North Telegraph Rd.','Pontiac','Michigan','United States','48342'),
( 29659,'[email protected]','Ms.','Ruth','Choin','7760 N. Pan Am Expwy','San Antonio','Texas','United States','78204'),
( 29660,'[email protected]','Mr.','Anthony','Chor','Riverside','Sherman Oaks','California','United States','91403'),
( 29662,'[email protected]','Ms.','Jill','Christie','54254 Pacific Ave.','Stockton','California','United States','95202'),
( 29663,'[email protected]','Ms.','Alice','Clark','42500 W 76th St','Chicago','Illinois','United States','60610'),
( 29666,'[email protected]','Ms.','Jane','Clayton','Po Box 83270','Vancouver','British Columbia','Canada','V7L 4J4'),
( 29668,'[email protected]','Ms.','Connie','Coffman','25269 Wood Dale Rd.','Wood Dale','Illinois','United States','60191'),
( 29671,'[email protected]','Mr.','Pat','Coleman','25245 Rue Sherbrooke Ouest','Montreal','Quebec','Canada','H1Y 2H5'),
( 29673,'[email protected]','Mr.','John','Colon','77 Beale Street','San Francisco','California','United States','94109'),
( 29674,'[email protected]','Mr.','Scott','Colvin','25550 Executive Dr','Elgin','Illinois','United States','60120'),
( 29677,'[email protected]','Mr.','William','Conner','2560 Bay Street','Toronto','Ontario','Canada','M4B 1V7'),
( 29680,'[email protected]','Ms.','Dorothy','Contreras','Suite 25800 3401 - 10810th Avenue','Surrey','British Columbia','Canada','V3T 4W3'),
( 29682,'[email protected]','Mr.','Scott','Cooper','Pavillion @ Redlands','Redlands','California','United States','92373'),
( 29683,'[email protected]','Ms.','Eva','Corets','2540 Dell Range Blvd','Cheyenne','Wyoming','United States','82001'),
( 29684,'[email protected]','Mr.','Marlin','Coriell','99800 Tittabawasee Rd.','Saginaw','Michigan','United States','48601'),
( 29686,'[email protected]','Mr.','Jack','Creasey','Factory Merchants','Barstow','California','United States','92311'),
( 29688,'[email protected]','Mr.','Grant','Culbertson','399700 John R. Rd.','Madison Heights','Michigan','United States','48071'),
( 29689,'[email protected]','Mr.','Scott','Culp','750 Lakeway Dr','Bellingham','Washington','United States','98225'),
( 29690,'[email protected]','Mr.','Conor','Cunningham','Sports Store At Park City','Park City','Utah','United States','84098'),
( 29692,'[email protected]','Mr.','Thierry','D`Hers','Box 99354 300 Union Street','Saint John','Brunswick','Canada','E2P 1E3'),
( 29695,'[email protected]','Ms.','Megan','Davis','48995 Evergreen Wy.','Everett','Washington','United States','98201'),
( 29696,'[email protected]','Sr.','Alvaro','De Matos Miranda Filho','Mountain Square','Upland','California','United States','91786'),
( 29698,'[email protected]','Mr.','Jacob','Dean','#9900 2700 Production Way','Burnaby','British Columbia','Canada','V5A 4X1'),
( 29699,'[email protected]','Mr.','Alexander','Deborde','6777 Kingsway','Burnaby','British Columbia','Canada','V5H 3Z7'),
( 29702,'[email protected]','Ms.','Aidan','Delaney','Corporate Office','Garland','Texas','United States','75040'),
( 29703,'[email protected]','Mr.','Stefan','Delmarco','Incom Sports Center','Ontario','California','United States','91764'),
( 29705,'[email protected]','Ms.','Della','Demott Jr','25575 The Queensway','Etobicoke','Ontario','Canada','M9W 3P3'),
( 29708,'[email protected]','Mr.','Prashanth','Desai','Sapp Road West','Round Rock','Texas','United States','78664'),
( 29709,'[email protected]','Ms.','Bev','Desalvo','7009 Sw Hall Blvd.','Tigard','Oregon','United States','97223'),
( 29710,'[email protected]','Ms.','Brenda','Diaz','2560 E. Newlands Dr','Fernley','Nevada','United States','89408'),
( 29711,'[email protected]','Ms.','Gabriele','Dickmann','250551 Shellbridge Way','Richmond','British Columbia','Canada','V6B 3P7'),
( 29713,'[email protected]','Mr.','Dick','Dievendorff','Bradford','W. York','England','United Kingdom','BD1 4SJ'),
( 29714,'[email protected]','Mr.','Rudolph','Dillon','595 Burning Street','Vancouver','British Columbia','Canada','V7L 4J4'),
( 29716,'[email protected]','Mr.','Blaine','Dockter','99000 S. Avalon Blvd. Suite 750','Carson','California','United States','90746'),
( 29717,'[email protected]','Ms.','Cindy','Dodd','994 Sw Cherry Park Rd','Troutdale','Oregon','United States','97060'),
( 29719,'[email protected]','Ms.','Patricia','Doyle','225 South 314th Street','Federal Way','Washington','United States','98003'),
( 29720,'[email protected]','Mr.','Gerald','Drury','4635 S. Harrison Blvd.','Ogden','Utah','United States','84401'),
( 29722,'[email protected]','Mr.','Reuben','D`sa','9950 Ferrand Drive, 9th Floor','Toronto','Ontario','Canada','M4B 1V4'),
( 29727,'[email protected]','Mr.','Bart','Duncan','99295 S.e. Tualatin Valley_hwy.','Hillsboro','Oregon','United States','97123'),
( 29728,'[email protected]','Mr.','Maciej','Dusza','2564 S. Redwood Rd.','Riverton','Utah','United States','84065'),
( 29730,'[email protected]','Ms.','Linda','Ecoffey','67255 - 8th Street N.E., Suite 350','Calgary','Alberta','Canada','T2P 2G8'),
( 29732,'[email protected]','Ms.','Carol','Elliott','25220 Airline Road','Corpus Christi','Texas','United States','78404'),
( 29733,'[email protected]','Ms.','Shannon','Elliott','Factory Stores/tucson','Tucson','Arizona','United States','85701'),
( 29734,'[email protected]','Ms.','Jauna','Elson','2573 Dufferin Street','Toronto','Ontario','Canada','M4B 1V5'),
( 29736,'[email protected]','Mr.','Terry','Eminhizer','Warrington Ldc Unit 25/2','Woolston','England','United Kingdom','WA1 4SY'),
( 29737,'[email protected]','Mr.','John','Emory','Medford','Medford','Oregon','United States','97504'),
( 29738,'[email protected]','Ms.','Gail','Erickson','44025 W. Empire','Denby','South Dakota','United States','57716'),
( 29739,'[email protected]','Mr.','Mark','Erickson','Factory Stores Of America','Mesa','Arizona','United States','85201'),
( 29740,'[email protected]','Ms.','Martha','Espinoza','6700 Boul Taschereau','Brossard','Quebec','Canada','J4Z 1C5'),
( 29741,'[email protected]','Sra.','Janeth','Esteves','6 The Farm, Liberty Road','Maidenhead','England','United Kingdom','SL67RJ'),
( 29742,'[email protected]','Ms.','Twanna','Evans','Lewis County Mall','Chehalis','Washington','United States','98532'),
( 29743,'[email protected]','Ms.','Ann','Evans','Ring Plaza','Norridge','Illinois','United States','60706'),
( 29744,'[email protected]','Mr.','John','Evans','7709 West Virginia Avenue','Phoenix','Arizona','United States','85004'),
( 29747,'[email protected]','Ms.','Carolyn','Farino','3250 South Meridian','Puyallup','Washington','United States','98371'),
( 29748,'[email protected]','Ms.','Geri','Farrell','49925 Crestview Drive N.E.','Rio Rancho','New Mexico','United States','87124'),
( 29750,'[email protected]','Ms.','Rhoda','Finley','6030 Conroy Road','Ottawa','Ontario','Canada','K4B 1S3'),
( 29753,'[email protected]','Ms.','Kathie','Flood','705 SE Mall Parkway','Everett','Washington','United States','98201'),
( 29755,'[email protected]','Ms.','Kelly','Focht','5990 Avebury Road','Mississauga','Ontario','Canada','L5B 3V4'),
( 29757,'[email protected]','Mr.','Garth','Fort','3250 Baldwin Park Blvd','Baldwin Park','California','United States','91706'),
( 29758,'[email protected]','Ms.','Dorothy','Fox','Lakeline Mall','Cedar Park','Texas','United States','78613'),
( 29761,'[email protected]','Ms.','Susan','French','69251 Creditview Road','Mississauga','Ontario','Canada','L5B 3V4'),
( 29763,'[email protected]','Mr.','Mihail','Frintu','Bayshore Mall','Eureka','California','United States','95501'),
( 29764,'[email protected]','Mr.','John','Ford','23025 S.W. Military Rd.','San Antonio','Texas','United States','78204'),
( 29765,'[email protected]','Mr.','Paul','Fulton','Horizon Outlet Center','Monroe','Michigan','United States','98272'),
( 29766,'[email protected]','Mr.','Bob','Gage','43251 Viking Way, Unit 130','Richmond','British Columbia','Canada','V6B 3P7'),
( 29768,'[email protected]','Mr.','Michael','Galos','West Park Plaza','Irvine','California','United States','92614'),
( 29769,'[email protected]','Mr.','Jon','Ganio','3900 S. 997th St.','Milwaukee','Wisconsin','United States','53202'),
( 29770,'[email protected]','Ms.','Kathleen','Garza','6388 Lake City Way','Burnaby','British Columbia','Canada','V5A 3A6'),
( 29771,'[email protected]','Mr.','Dominic','Gash','5420 West 22500 South','Salt Lake City','Utah','United States','84101'),
( 29772,'[email protected]','Ms.','Janet','Gates','165 North Main','Austin','Texas','United States','78701'),
( 29773,'[email protected]','Mr.','Orlando','Gee','2251 Elliot Avenue','Seattle','Washington','United States','98104'),
( 29774,'[email protected]','Mr.','Darren','Gehring','509 Nafta Boulevard','Laredo','Texas','United States','78040'),
( 29775,'[email protected]','Mr.','Jim','Geist','35525-9th Street Sw','Puyallup','Washington','United States','98371'),
( 29776,'[email protected]','Ms.','Barbara','German','Science Park South, Birchwood','Warrington','England','United Kingdom','WA3 7BH'),
( 29778,'[email protected]','Mr.','Leo','Giakoumakis','Elmhurst Road, Goring','Reading','England','United Kingdom','RG7 5H7'),
( 29780,'[email protected]','Mr.','Frances','Giglio','9979 Bayview Drive','Barrie','Ontario','Canada','L4N'),
( 29781,'[email protected]','Mr.','Guy','Gilbert','Vista Marketplace','Alhambra','California','United States','91801'),
( 29782,'[email protected]','Ms.','Janet','Gilliat','9995 West Central Entrance','Duluth','Minnesota','United States','55802'),
( 29783,'[email protected]','Ms.','Mary','Gimmi','5525 South Hover Road','Longmont','Colorado','United States','80501'),
( 29784,'[email protected]','Ms.','Jeanie','Glenn','9909 W. Ventura Boulevard','Camarillo','California','United States','93010'),
( 29785,'[email protected]','Ms.','Diane','Glimp','4400 March Road','Kanata','Ontario','Canada','K2L 1H5'),
( 29787,'[email protected]','Mr.','Scott','Gode','2583 Se 272nd St','Kent','Washington','United States','98031'),
( 29788,'[email protected]','Mr.','Mete','Goktepe','Hanford Mall','Hanford','California','United States','93230'),
( 29789,'[email protected]','Mr.','Brian','Goldstein','965 De La Gauchetiere West','Montreal','Quebec','Canada','H1Y 2H8'),
( 29792,'[email protected]','Ms.','Abigail','Gonzalez','99450 Highway 59 North','Humble','Texas','United States','77338'),
( 29793,'[email protected]','Mr.','Michael','Graff','9700 Sisk Road','Modesto','California','United States','95354'),
( 29794,'[email protected]','Mr.','Derek','Graham','655-4th Ave S.W.','Calgary','Alberta','Canada','T2P 2G8'),
( 29796,'[email protected]','Mr.','Jon','Grande','Galashiels','Liverpool','England','United Kingdom','L4 4HB'),
( 29797,'[email protected]','Ms.','Jane','Greer','2550 Signet Drive','Weston','Ontario','Canada','M9V 4W3'),
( 29799,'[email protected]','Mr.','Douglas','Groncki','70259 West Sunnyview Ave','Visalia','California','United States','93291'),
( 29800,'[email protected]','Mr.','Brian','Groth','Gateway','Portland','Oregon','United States','97205'),
( 29803,'[email protected]','Ms.','Hattie','Haemon','55 Lakeshore Blvd East','Toronto','Ontario','Canada','M4B 1V6'),
( 29805,'[email protected]','Ms.','Erin','Hagens','25001 Montague Expressway','Milpitas','California','United States','95035'),
( 29806,'[email protected]','Ms.','Betty','Haines','640 South 994th St. W.','Billings','Montana','United States','59101'),
( 29807,'[email protected]','Mr.','Bryan','Hamilton','Station E','Chalk Riber','Ontario','Canada','K0J 1J0'),
( 29809,'[email protected]','Mr.','Kerim','Hanif','60025 Bollinger Canyon Road','San Ramon','California','United States','94583'),
( 29810,'[email protected]','Ms.','Jean','Handley','259826 Russell Rd. South','Kent','Washington','United States','98031'),
( 29813,'[email protected]','Ms.','Katherine','Harding','52560 Free Street','Toronto','Ontario','Canada','M4B 1V7'),
( 29815,'[email protected]','Mr.','Lucy','Harrington','482505 Warm Springs Blvd.','Fremont','California','United States','94536'),
( 29816,'[email protected]','Mr.','Keith','Harris','7943 Walnut Ave','Renton','Washington','United States','98055'),
( 29818,'[email protected]','Mr.','Roger','Harui','9927 N. Main St.','Tooele','Utah','United States','84074'),
( 29819,'[email protected]','Ms.','Ann','Hass','Medford Outlet Center','Medford','Minnesota','United States','55049'),
( 29822,'[email protected]','Mr.','James','Haugh','660 Saint-Jacques, Bureau 400','Montreal','Quebec','Canada','H1Y 2H8'),
( 29824,'[email protected]','Ms.','Brenda','Heaney','990th Floor 700 De La GauchetiSre Ou','Montreal','Quebec','Canada','H1Y 2H3'),
( 29826,'[email protected]','Mr.','John','Hanson','825 W 500 S','Bountiful','Utah','United States','84010'),
( 29827,'[email protected]','Ms.','Valerie','Hendricks','Kansas City Factory Outlet','Odessa','Missouri','United States','64076'),
( 29830,'[email protected]','Mr.','Kari','Hensien','253131 Lake Frasier Drive, Office No. 2','Calgary','Alberta','Canada','T2P 2G8'),
( 29831,'[email protected]','Ms.','Irene','Hernandez','25730, boul. St-Régis','Dorval','Quebec','Canada','H9P 1H1'),
( 29832,'jé[email protected]','Mr.','Jésus','Hernandez','32605 West 252 Mile Road, Suite 250','Aurora','Ontario','Canada','L4G 7N6'),
( 29834,'[email protected]','Ms.','Cheryl','Herring','Corp Ofc Accts Payable','El Segundo','California','United States','90245'),
( 29835,'[email protected]','Mr.','Ronald','Heymsfield','250775 SW Hillsdale Hwy','Beaverton','Oregon','United States','97005'),
( 29840,'[email protected]','Mr.','Andrew','Hill','7000 Victoria Park Avenue','Toronto','Ontario','Canada','M4B 1V4'),
( 29842,'[email protected]','Mr.','Mike','Hines','25250 N 90th St','Scottsdale','Arizona','United States','85257'),
( 29843,'[email protected]','Mr.','Matthew','Hink','No. 60 Bellis Fair Parkway','Bellingham','Washington','United States','98225'),
( 29847,'[email protected]','Mr.','David','Hodgson','99700 Bell Road','Auburn','California','United States','95603'),
( 29848,'[email protected]','Ms.','Helge','Hoeing','Cedar Creek Stores','Mosinee','Wisconsin','United States','54455'),
( 29850,'[email protected]','Mr.','Bob','Hodges','Ohms Road','Houston','Texas','United States','77003'),
( 29851,'[email protected]','Ms.','Jean','Holloway','Unit 99a Battery Retail Pk','Birmingham','England','United Kingdom','B29 6SL'),
( 29852,'[email protected]','Mr.','Eddie','Holmes','Bureau 9900 825, Avenue Querbes','Outremont','Quebec','Canada','H1Y 2G5'),
( 29853,'[email protected]','Ms.','Juanita','Holman','Lake Elisnor Place','Lake Elsinore','California','United States','92530'),
( 29854,'[email protected]','Mr.','Peter','Houston','1200 First Ave.','Joliet','Illinois','United States','60433'),
( 29855,'[email protected]','Mr.','Curtis','Howard','6th Floor, 25st Canadian Place','Toronto','Ontario','Canada','M4B 1V5'),
( 29857,'[email protected]','Ms.','Janice','Hows','399 Clearing Green','London','England','United Kingdom','EC1R 0DU'),
( 29858,'[email protected]','Mr.','George','Huckaby','3390 South 23rd St.','Tacoma','Washington','United States','98403'),
( 29859,'[email protected]','Mr.','Joshua','Huff','Management Mall','San Antonio','Texas','United States','78204'),
( 29860,'[email protected]','Ms.','Arlene','Huff','2574 Milton Park','Oxford','England','United Kingdom','OX14 4SE'),
( 29861,'[email protected]','Ms.','Phyllis','Huntsman','City Center','Minneapolis','Minnesota','United States','55402'),
( 29862,'[email protected]','Mr.','Lawrence','Hurkett','6753 Howard Hughes Parkway','Las Vegas','Nevada','United States','89106'),
( 29863,'[email protected]','Mr.','Ryan','Ihrig','250333 Southport Road, S.W.','Calgary','Alberta','Canada','T2P 2G8'),
( 29864,'[email protected]','Ms.','Beth','Inghram','9259 - 1110th Avenue Sw','Calgary','Alberta','Canada','T2P 2G8'),
( 29865,'[email protected]','Mr.','Lucio','Iallo','Simi @ The Plaza','Simi Valley','California','United States','93065'),
( 29866,'[email protected]','Mr.','Richard','Irwin','99828 Routh Street, Suite 825','Dallas','Texas','United States','75201'),
( 29867,'[email protected]','Mr.','Erik','Ismert','4927 S Meridian Ave Ste D','Puyallup','Washington','United States','98371'),
( 29868,'[email protected]','Ms.','Denean','Ison','586 Fulham Road,','London','England','United Kingdom','SW6 SBY'),
( 29870,'[email protected]','Mr.','Bronson','Jacobs','2510 Crew Court','Montreal','Quebec','Canada','H1Y 2H8'),
( 29871,'[email protected]','Mr.','Eric','Jacobsen','Topanga Plaza','Canoga Park','California','United States','91303'),
( 29872,'[email protected]','Ms.','Jodan','Jacobson','6030 Robinson Road','Jefferson City','Missouri','United States','65101'),
( 29873,'[email protected]','Ms.','Mary','Alexander','2345 West Spencer Road','Lynnwood','Washington','United States','98036'),
( 29874,'[email protected]','Mr.','David','Jaffe','Wade Road','Basingstoke Hants','England','United Kingdom','RG24 8PL'),
( 29876,'[email protected]','Ms.','Vance','Johns','65 Gamelin Street','Hull','Quebec','Canada','8Y'),
( 29877,'[email protected]','Ms.','Joyce','Jarvis','955 E. County Line Rd.','Englewood','Colorado','United States','80110'),
( 29879,'[email protected]','Mr.','Stephen','Jiang','9900 Ronson Drive','Etobicoke','Ontario','Canada','M9W 3P3'),
( 29881,'[email protected]','Ms.','Danielle','Johnson','955 Green Valley Crescent','Ottawa','Ontario','Canada','K4B 1S1'),
( 29883,'[email protected]','Mr.','Barry','Johnson','2000 300th Street','Denver','Colorado','United States','80203'),
( 29884,'[email protected]','Mr.','Brian','Johnson','625 W Jackson Blvd. Unit 2502','Chicago','Illinois','United States','60610'),
( 29885,'[email protected]','Mr.','David','Johnson','7990 Ocean Beach Hwy.','Longview','Washington','United States','98632'),
( 29889,'[email protected]','Ms.','Jean','Jordan','440 West Huntington Dr.','Monrovia','California','United States','91016'),
( 29890,'[email protected]','Ms.','Peggy','Justice','15 East Main','Port Orchard','Washington','United States','98366'),
( 29891,'[email protected]','Ms.','Diane','Krane','46460 West Oaks Drive','Novi','Michigan','United States','48375'),
( 29892,'[email protected]','Ms.','Sandra','Kitt','258 King Street East','Toronto','Ontario','Canada','M4B 1V7'),
( 29893,'[email protected]','Mr.','Sandeep','Kaliyath','630 N. Capitol Ave.','San Jose','California','United States','95112'),
( 29895,'[email protected]','Ms.','Lori','Kane','9693 Louis H Lafontaine','Ville De`anjou','Quebec','Canada','J1G 2R3'),
( 29897,'[email protected]','Ms.','Kay','Krane','Prime Outlets','Phoenix','Arizona','United States','85004'),
( 29898,'[email protected]','Mr.','Sandeep','Katyal','765 Delridge Way Sw','Seattle','Washington','United States','98104'),
( 29900,'[email protected]','Mr.','Victor','Kelley','2900 - 25055 Dunning Street','Vancouver','British Columbia','Canada','V7L 4J4'),
( 29901,'[email protected]','Mr.','John','Kelly','Pacific West Outlet','Gilroy','California','United States','95020'),
( 29902,'[email protected]','Mr.','Robert','Kelly','6425 Nw Loop 410','San Antonio','Texas','United States','78204'),
( 29903,'[email protected]','Mr.','Kevin','Kennedy','2550 Ne Sandy Blvd','Portland','Oregon','United States','97205'),
( 29904,'[email protected]','Ms.','Mary','Kesslep','Wharfdale Road','Berkshire','England','United Kingdom','RG11 5TP'),
( 29905,'[email protected]','Ms.','Elizabeth','Keyser','6400, 888 - 3rd Avenue','Calgary','Alberta','Canada','T2P 2G8'),
( 29906,'[email protected]','Mr.','Imtiaz','Khan','25095 W. Florissant','Ferguson','Missouri','United States','63135'),
( 29907,'[email protected]','Ms.','Karan','Khanna','755 W Washington Ave Ste D','Sequim','Washington','United States','98382'),
( 29908,'[email protected]','Mr.','Joe','Kim','308-3250 Casting Road','York','England','United Kingdom','Y024 1GF'),
( 29910,'[email protected]','Mr.','Shane','Kim','No. 25400 10665 Jasper Avenue','Edmonton','Alberta','Canada','T5'),
( 29911,'[email protected]','Mr.','Tim','Kim','25 Danger Street West','Toronto','Ontario','Canada','M4B 1V5'),
( 29913,'[email protected]','Mr.','Anton','Kirilov','2575 Rocky Mountain Ave.','Loveland','Colorado','United States','80537'),
( 29914,'[email protected]','Mr.','Christian','Kleinerman','25150 El Camino Real','San Bruno','California','United States','94066'),
( 29915,'[email protected]','Mr.','Andrew','Kobylinski','2526a Tri-Lake Blvd Ne','Kirkland','Washington','United States','98033'),
( 29918,'[email protected]','Mr.','Kirk','King','2521 McPherson Street','Markham','Ontario','Canada','L3S 3K2'),
( 29919,'[email protected]','Mr.','Eugene','Kogan','6756 Mowry','Newark','California','United States','94560'),
( 29920,'[email protected]','Mr.','Scott','Konersmann','52500 Liberty Way','Fort Worth','Texas','United States','76102'),
( 29921,'[email protected]','Ms.','Joy','Koski','258101 Nw Evergreen Parkway','Beaverton','Oregon','United States','97005'),
( 29922,'[email protected]','Ms.','Pamala','Kotc','Garamonde Drive, Wymbush','Milton Keynes','England','United Kingdom','MK8 8ZD'),
( 29924,'[email protected]','Mr.','Mitch','Kennedy','C/O Starpak, Inc.','Greeley','Colorado','United States','80631'),
( 29925,'[email protected]','Ms.','Margaret','Krupka','Great Northwestern','North Bend','Washington','United States','98045'),
( 29926,'[email protected]','Mr.','Deepak','Kumar','255 Irving Street','London','England','United Kingdom','C2H 7AU'),
( 29928,'[email protected]','Mr.','Vamsi','Kuppa','3255 Front Street West','Toronto','Ontario','Canada','M4B 1V6'),
( 29929,'[email protected]','Mr.','Jeffrey','Kurtz','Receiving','Fullerton','California','United States','92831'),
( 29930,'[email protected]','Mr.','Peter','Kurniawan','63 W Monroe','Chicago','Illinois','United States','60610'),
( 29931,'[email protected]','Mr.','Eric','Lang','25300 Biddle Road','Medford','Oregon','United States','97504'),
( 29932,'[email protected]','Ms.','Rebecca','Laszlo','Phoenix Way, Cirencester','Gloucestershire','England','United Kingdom','GL7 1RY'),
( 29934,'[email protected]','Mr.','David','Lawrence','2512-4th Ave Sw','Calgary','Alberta','Canada','T2P 2G8'),
( 29935,'[email protected]','Ms.','Elsa','Leavitt','2575 West 2700 South','Salt Lake City','Utah','United States','84101'),
( 29936,'[email protected]','Mr.','Michael','Lee','25718 Se Sunnyside Rd','Clackamas','Oregon','United States','97015-6403'),
( 29937,'[email protected]','Ms.','Marjorie','Lee','2509 W. Frankford','Carrollton','Texas','United States','75006'),
( 29938,'[email protected]','Mr.','Frank','Campbell','251340 E. South St.','Cerritos','California','United States','90703'),
( 29939,'[email protected]','Mr.','Mark','Lee','2512-410th Avenue S.W.','Calgary','Alberta','Canada','T2P 2G8'),
( 29941,'[email protected]','Ms.','Jolie','Lenehan','Garamonde Drive, Wymbush','Milton Keynes','England','United Kingdom','MK8 8ZD'),
( 29942,'[email protected]','Mr.','Roger','Lengel','490 Ne 4th St','Renton','Washington','United States','98055'),
( 29943,'[email protected]',NULL,'A.','Leonetti','5700 Legacy Dr','Plano','Texas','United States','75074'),
( 29944,'[email protected]','Ms.','Bonnie','Lepro','25600 E St Andrews Pl','Santa Ana','California','United States','92701'),
( 29946,'[email protected]','Ms.','Linda','Leste','630 University Avenue','Toronto','Ontario','Canada','M4B 1V7'),
( 29948,'[email protected]','Ms.','Elsie','Lewin','P.O. Box 6256916','Dallas','Texas','United States','75201'),
( 29949,'[email protected]','Mr.','George','Li','910 Main Street.','Sparks','Nevada','United States','89431'),
( 29950,'[email protected]','Mr.','Yale','Li','992 St Clair Ave East','Toronto','Ontario','Canada','M4B 1V7'),
( 29952,'[email protected]','Ms.','Yuhong','Li','Bradford','W. York','England','United Kingdom','BD1 4SJ'),
( 29953,'[email protected]','Mr.','Joseph','Lique','257700 Ne 76th Street','Redmond','Washington','United States','98052'),
( 29954,'[email protected]','Mr.','Paulo','Lisboa','Po Box 8259024','Dallas','Texas','United States','75201'),
( 29955,'[email protected]','Mr.','David','Liu','855 East Main Avenue','Zeeland','Michigan','United States','49464'),
( 29956,'[email protected]',NULL,'Jinghao','Liu','90025 Sterling St','Irving','Texas','United States','75061'),
( 29957,'[email protected]','Mr.','Kevin','Liu','9992 Whipple Rd','Union City','California','United States','94587'),
( 29959,'[email protected]','Mr.','Todd','Logan','575 Rue St Amable','Quebec','Quebec','Canada','G1R'),
( 29962,'[email protected]','Ms.','Sharon','Looney','74400 France Avenue South','Edina','Minnesota','United States','55436'),
( 29964,'[email protected]','Ms.','Anita','Lucerne','6333 Cote Vertu','Montreal','Quebec','Canada','H1Y 2H7'),
( 29967,'[email protected]','Ms.','Judy','Lundahl','25149 Howard Dr','West Chicago','Illinois','United States','60185'),
( 29969,'[email protected]','Mr.','Robert','Lyeba','63 Free St.','Toronto','Ontario','Canada','M4B 1V4'),
( 29971,'[email protected]','Mr.','Robert','Lyon','609 Evans Avenue','Toronto','Ontario','Canada','M4B 1V4'),
( 29973,'[email protected]','Ms.','Denise','Maccietto','Port Huron','Port Huron','Michigan','United States','48060'),
( 29974,'[email protected]','Mr.','Scott','MacDonald','St. Louis Marketplace','Saint Louis','Missouri','United States','63103'),
( 29975,'[email protected]','Mr.','Walter','Mays','Po Box 252525','Santa Ana','California','United States','92701'),
( 29978,'[email protected]','Mr.','Ajay','Manchepalli','25 Hartfield Road, Wimbledon','London','England','United Kingdom','SW19 3RU'),
( 29980,'[email protected]','Mr.','Tomas','Manzanares','99 Dean Street, Soho','London','England','United Kingdom','W1V 5RN'),
( 29981,'[email protected]','Ms.','Kathy','Marcovecchio','9905 Three Rivers Drive','Kelso','Washington','United States','98626'),
( 29982,'[email protected]','Ms.','Melissa','Marple','603 Gellert Blvd','Daly City','California','United States','94015'),
( 29983,'[email protected]','Ms.','Cecelia','Marshall','9984 Wellington Street','Ottawa','Ontario','Canada','K4B 1S2'),
( 29985,'[email protected]','Ms.','Linda','Martin','Park House-4th Floor, 2516 Park St.','London','England','United Kingdom','W1Y 3RA'),
( 29987,'[email protected]','Mr.','Frank','Mart¡nez','870 N. 54th Ave.','Chandler','Arizona','United States','85225'),
( 29988,'[email protected]','Mr.','Steve','Masters','2545 King Street West','Toronto','Ontario','Canada','M4B 1V7'),
( 29990,'[email protected]','Ms.','Jennifer','Maxham','Butterfield Hse, 7-251 Chapel St','Lancaster','England','United Kingdom','LA1 1LN'),
( 29991,'[email protected]','Mr.','Chris','Maxwell','3025 E Waterway Blvd','Shelton','Washington','United States','98584'),
( 29992,'[email protected]','Ms.','Sandra','Maynard','9952 E. Lohman Ave.','Las Cruces','New Mexico','United States','88001'),
( 29994,'[email protected]','Ms.','Robin','McGuigan','2500 University Avenue','Toronto','Ontario','Canada','M4B 1V5'),
( 29997,'[email protected]','Ms.','Lola','McCarthy','1050 Oak Street','Seattle','Washington','United States','98104'),
( 29998,'[email protected]','Ms.','Jane','McCarty','409 Santa Monica Blvd.','Santa Monica','California','United States','90401'),
( 30000,'[email protected]','Mr.','James','McCoy','9900-6400 Boul, Taschereau','Brossard','Quebec','Canada','J4Z 1R4'),
( 30003,'[email protected]','Ms.','Yvonne','McKay','Horizon Outlet','Woodbury','Minnesota','United States','55125'),
( 30004,'[email protected]','Ms.','Nkenge','McLin','Frontier Mall','Cheyenne','Wyoming','United States','82001'),
( 30005,'[email protected]','Ms.','Nancy','McPhearson','46-44 Albemarle Street','London','England','United Kingdom','W1X3SE'),
( 30007,'[email protected]','Ms.','Raquel','Mello','No. 2000-25080 Beaver Hall Hill','Quebec','Quebec','Canada','G1R'),
( 30008,'[email protected]','Mr.','R. Morgan','Mendoza','Johnson Creek','Johnson Creek','Wisconsin','United States','53038'),
( 30010,'[email protected]','Mr.','Stephen','Mew','250 Kingsbridge Garden Circle','Mississauga','Ontario','Canada','L5B 3V4'),
( 30012,'[email protected]','Ms.','Helen','Meyer','7505 Laguna Boulevard','Elk Grove','California','United States','95624'),
( 30016,'[email protected]','Mr.','Thomas','Michaels','5th Floor, 79 Place D`armes','Kingston','Ontario','Canada','7L'),
( 30018,'[email protected]','Ms.','Virginia','Miller','25111 228th St Sw','Bothell','Washington','United States','98011'),
( 30019,'[email protected]','Mr.','Matthew','Miller','Wymbush','Milton Keynes','England','United Kingdom','MK8 8DF'),
( 30021,'[email protected]','Mr.','Ben','Miller','Suite 500 995 W. 11th Avenue','Mississauga','Ontario','Canada','L5A 1H6'),
( 30022,'[email protected]','Mr.','Dylan','Miller','Parkway Plaza','El Cajon','California','United States','92020'),
( 30023,'[email protected]','Mr.','Frank','Miller','123 W. Lake Ave.','Peoria','Illinois','United States','61606'),
( 30024,'[email protected]','Ms.','Neva','Mitchell','2528 Meridian E','Puyallup','Washington','United States','98371'),
( 30025,'[email protected]','Ms.','Linda','Mitchell','New Millhouse, 2583 Milton Park','Abingdon','England','United Kingdom','OX14 4SE'),
( 30027,'[email protected]','Mr.','Joseph','Mitzner','123 Camelia Avenue','Oxnard','California','United States','93030'),
( 30028,'[email protected]','Ms.','Laura','Steele','253731 West Bell Road','Surprise','Arizona','United States','85374'),
( 30029,'[email protected]','Ms.','Shanay','Steelman','5 place Ville-Marie','Montreal','Quebec','Canada','H1Y 2H7'),
( 30030,'[email protected]','Mr.','Stefano','Stefani','997b Tradescant Road','London','England','United Kingdom','SW8 1XD'),
( 30031,'[email protected]','Mr.','Alan','Steiner','2255 254th Avenue Se','Albany','Oregon','United States','97321'),
( 30032,'[email protected]','Mr.','Derik','Stenerson','Factory Merchants','Branson','Missouri','United States','65616'),
( 30033,'[email protected]','Mr.','Vassar','Stern','25130 South State Street','Sandy','Utah','United States','84070'),
( 30034,'[email protected]','Ms.','Wathalee','Steuber','700 Se Sunnyside Road','Clackamas','Oregon','United States','97015'),
( 30035,'[email protected]','Ms.','Alice','Steiner','Lone Star Factory','La Marque','Texas','United States','77568'),
( 30036,'[email protected]','Ms.','Liza Marie','Stevens','7750 E Marching Rd','Scottsdale','Arizona','United States','85257'),
( 30037,'[email protected]','Mr.','Jim','Stewart','999 West Georgia St.','Vancouver','Ontario','Canada','V5T 1Y9'),
( 30039,'[email protected]','Mr.','Robert','Stotka','Sports Stores @ Tuscola','Tuscola','Illinois','United States','61953'),
( 30040,'[email protected]','Ms.','Kayla','Stotler','9980 S Alma School Road','Chandler','Arizona','United States','85225'),
( 30042,'[email protected]','Ms.','Ruby Sue','Styles','46990 Viking Way','Richmond','British Columbia','Canada','V6B 3P7'),
( 30044,'[email protected]','Mr.','Gary','Suess','725a The Arches','Berks','England','United Kingdom','SL4 1RH'),
( 30045,'[email protected]','Ms.','Ruth','Suffin','Lancaster Mall','Salem','Oregon','United States','97301'),
( 30046,'[email protected]','Ms.','Elizabeth','Sullivan','Town East Center','Mesquite','Texas','United States','75149'),
( 30047,'[email protected]','Mr.','Michael','Sullivan','5867 Sunrise Boulevard','Citrus Heights','California','United States','95610'),
( 30048,'[email protected]','Ms.','Marcia','Sultan','251420a 170th Street','Edmonton','Alberta','Canada','T5'),
( 30050,'[email protected]','Mr.','Krishna','Sunkammurali','Paramount House','London','England','United Kingdom','W1N 9FA'),
( 30051,'[email protected]','Mr.','Brad','Sutton','Three Rivers Mall','Kelso','Washington','United States','98626'),
( 30052,'[email protected]','Mr.','Abraham','Swearengin','9920 Bridgepointe Parkway','San Mateo','California','United States','94404'),
( 30053,'[email protected]','Ms.','Katherine','Swan','975 Princess Street','Kingston','Ontario','Canada','7L'),
( 30055,'[email protected]','Ms.','Julie','Taft-Rider','6996 South Lindbergh','Saint Louis','Missouri','United States','63103'),
( 30056,'[email protected]','Mr.','Clarence','Tatman','San Diego Factory','San Ysidro','California','United States','92173'),
( 30058,'[email protected]','Mr.','Mike','Taylor','750 Philip Street','Waterloo','Ontario','Canada','N2V'),
( 30061,'[email protected]','Mr.','Chad','Tedford','9500b E. Central Texas Expressway','Killeen','Texas','United States','76541'),
( 30063,'[email protected]','Ms.','Vanessa','Tench','2500 N Serene Blvd','El Segundo','California','United States','90245'),
( 30064,'[email protected]','Ms.','Judy','Thames','25102 Springwater','Wenatchee','Washington','United States','98801'),
( 30067,'[email protected]','Ms.','Phyllis','Thomas','99, Rue Saint-pierre','Pnot-Rouge','Quebec','Canada','J1E 2T7'),
( 30069,'[email protected]','Mr.','Donald','Thompson','25472 Marlay Ave','Fontana','California','United States','92335'),
( 30070,'[email protected]','Ms.','Kendra','Thompson','22571 South 2500 East','Idaho Falls','Idaho','United States','83402'),
( 30071,'[email protected]','Mr.','Daniel','Thompson','755 Nw Grandstand','Issaquah','Washington','United States','98027'),
( 30072,'[email protected]','Ms.','Andrea','Thomsen','251 The Metro Center','Wokingham','England','United Kingdom','RG41 1QW'),
( 30074,'[email protected]','Ms.','Yuping','Tian','Depot 80','Sillery','Quebec','Canada','G1T'),
( 30076,'[email protected]','Ms.','Diane','Tibbott','8525 South Parker Road','Parker','Colorado','United States','80138'),
( 30080,'[email protected]','Ms.','Delia','Toone','755 Columbia Ctr Blvd','Kennewick','Washington','United States','99337'),
( 30083,'[email protected]','Mr.','Glenn','Track','55 Standish Court','Mississauga','Ontario','Canada','L5B 3V4'),
( 30087,'[email protected]','Mr.','Billy','Trent','99954 Boul. Laurier, Local 060, Place','Sainte-Foy','Quebec','Canada','G1W'),
( 30089,'[email protected]','Mr.','Michael John','Troyer','Oxnard Outlet','Oxnard','California','United States','93030'),
( 30090,'[email protected]','Ms.','Christie','Trujillo','One Dancing, Rr No. 25','Round Rock','Texas','United States','78664'),
( 30093,'[email protected]','Ms.','Phyllis','Tuffield','9960 King Street E.','Toronto','Ontario','Canada','M4B 1V5'),
( 30094,'[email protected]','Mr.','Sairaj','Uddin','Natomas Marketplace','Sacramento','California','United States','95814'),
( 30095,'[email protected]','Mr.','Sunil','Uppal','25500 Old Spanish Trail','Houston','Texas','United States','77003'),
( 30098,'[email protected]','Ms.','Esther','Valle','600 Boul. Rene-levesque Ouest','Montreal','Quebec','Canada','H1Y 2H7'),
( 30100,'[email protected]','Mr.','Jessie','Valerio','Mall Of Orange','Orange','California','United States','92867'),
( 30102,'[email protected]','Mr.','Roger','Van Houten','Internet House, 3399 Science Park','Cambridge','England','United Kingdom','CB4 4BZ'),
( 30104,'[email protected]','Ms.','Rose','Vandenouer','7 Garden House Cloisters, 8 Batters','London','England','United Kingdom','SW8 4BG'),
( 30105,'[email protected]','Mr.','Gregory','Vanderbout','950 Gateway Street','Springfield','Oregon','United States','97477'),
( 30106,'[email protected]','Mr.','Michael','Vanderhyde','Lincoln Square','Arlington','Texas','United States','76010'),
( 30107,'[email protected]','Ms.','Margaret','Vanderkamp','62500 Neil Road','Reno','Nevada','United States','89502'),
( 30108,'[email protected]','Ms.','Kara','Vanderlinden','2520 Flanders Road','Toronto','Ontario','Canada','M4B 1V4'),
( 30109,'[email protected]','Mr.','Nieves','Vargas','Kensington Valley Shops','Howell','Michigan','United States','48843'),
( 30110,'[email protected]','Mr.','Gary','Vargas','Stevens Creek Shopping Center','San Jose','California','United States','95112'),
( 30111,'[email protected]','Mr.','Ranjit','Varkey Chudukatil','455 256th St.','Moline','Illinois','United States','61265'),
( 30112,'[email protected]','Ms.','Patricia','Vasquez','409 S. Main Ste. 25','Ellensburg','Washington','United States','98926'),
( 30113,'[email protected]','Mr.','Raja','Venugopal','Burgess Hill','West Sussex','England','United Kingdom','RH15 9UD'),
( 30115,'[email protected]','Ms.','Dora','Verdad','Suite 2502 410 Albert Street','Waterloo','Ontario','Canada','N2V'),
( 30116,'[email protected]','Ms.','Wanda','Vernon','Ontario Mills','Ontario','California','United States','91764'),
( 30117,'[email protected]','Mr.','Robert','Vessa','72540 Blanco Rd.','San Antonio','Texas','United States','78204'),
( 30118,'[email protected]','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),