-- Ensure you've run Listing 9.020.sql to create the Item56Example database

USE Item56Example;

-- Listing 9.21 Table creation DDL for a Date table
CREATE TABLE DimDate (
  DateKey int PRIMARY KEY ,
  FullDate date NOT NULL 
);

CREATE INDEX iFullDate
  ON DimDate (FullDate);

INSERT INTO DimDate (DateKey, FullDate) VALUES (20170101, '2017-01-01');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170102, '2017-01-02');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170103, '2017-01-03');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170104, '2017-01-04');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170105, '2017-01-05');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170106, '2017-01-06');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170107, '2017-01-07');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170108, '2017-01-08');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170109, '2017-01-09');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170110, '2017-01-10');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170111, '2017-01-11');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170112, '2017-01-12');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170113, '2017-01-13');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170114, '2017-01-14');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170115, '2017-01-15');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170116, '2017-01-16');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170117, '2017-01-17');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170118, '2017-01-18');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170119, '2017-01-19');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170120, '2017-01-20');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170121, '2017-01-21');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170122, '2017-01-22');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170123, '2017-01-23');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170124, '2017-01-24');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170125, '2017-01-25');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170126, '2017-01-26');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170127, '2017-01-27');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170128, '2017-01-28');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170129, '2017-01-29');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170130, '2017-01-30');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170131, '2017-01-31');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170201, '2017-02-01');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170202, '2017-02-02');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170203, '2017-02-03');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170204, '2017-02-04');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170205, '2017-02-05');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170206, '2017-02-06');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170207, '2017-02-07');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170208, '2017-02-08');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170209, '2017-02-09');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170210, '2017-02-10');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170211, '2017-02-11');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170212, '2017-02-12');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170213, '2017-02-13');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170214, '2017-02-14');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170215, '2017-02-15');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170216, '2017-02-16');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170217, '2017-02-17');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170218, '2017-02-18');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170219, '2017-02-19');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170220, '2017-02-20');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170221, '2017-02-21');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170222, '2017-02-22');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170223, '2017-02-23');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170224, '2017-02-24');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170225, '2017-02-25');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170226, '2017-02-26');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170227, '2017-02-27');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170228, '2017-02-28');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170301, '2017-03-01');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170302, '2017-03-02');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170303, '2017-03-03');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170304, '2017-03-04');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170305, '2017-03-05');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170306, '2017-03-06');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170307, '2017-03-07');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170308, '2017-03-08');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170309, '2017-03-09');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170310, '2017-03-10');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170311, '2017-03-11');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170312, '2017-03-12');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170313, '2017-03-13');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170314, '2017-03-14');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170315, '2017-03-15');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170316, '2017-03-16');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170317, '2017-03-17');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170318, '2017-03-18');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170319, '2017-03-19');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170320, '2017-03-20');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170321, '2017-03-21');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170322, '2017-03-22');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170323, '2017-03-23');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170324, '2017-03-24');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170325, '2017-03-25');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170326, '2017-03-26');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170327, '2017-03-27');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170328, '2017-03-28');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170329, '2017-03-29');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170330, '2017-03-30');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170331, '2017-03-31');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170401, '2017-04-01');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170402, '2017-04-02');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170403, '2017-04-03');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170404, '2017-04-04');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170405, '2017-04-05');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170406, '2017-04-06');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170407, '2017-04-07');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170408, '2017-04-08');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170409, '2017-04-09');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170410, '2017-04-10');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170411, '2017-04-11');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170412, '2017-04-12');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170413, '2017-04-13');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170414, '2017-04-14');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170415, '2017-04-15');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170416, '2017-04-16');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170417, '2017-04-17');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170418, '2017-04-18');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170419, '2017-04-19');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170420, '2017-04-20');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170421, '2017-04-21');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170422, '2017-04-22');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170423, '2017-04-23');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170424, '2017-04-24');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170425, '2017-04-25');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170426, '2017-04-26');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170427, '2017-04-27');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170428, '2017-04-28');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170429, '2017-04-29');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170430, '2017-04-30');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170501, '2017-05-01');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170502, '2017-05-02');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170503, '2017-05-03');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170504, '2017-05-04');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170505, '2017-05-05');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170506, '2017-05-06');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170507, '2017-05-07');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170508, '2017-05-08');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170509, '2017-05-09');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170510, '2017-05-10');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170511, '2017-05-11');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170512, '2017-05-12');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170513, '2017-05-13');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170514, '2017-05-14');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170515, '2017-05-15');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170516, '2017-05-16');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170517, '2017-05-17');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170518, '2017-05-18');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170519, '2017-05-19');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170520, '2017-05-20');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170521, '2017-05-21');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170522, '2017-05-22');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170523, '2017-05-23');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170524, '2017-05-24');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170525, '2017-05-25');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170526, '2017-05-26');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170527, '2017-05-27');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170528, '2017-05-28');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170529, '2017-05-29');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170530, '2017-05-30');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170531, '2017-05-31');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170601, '2017-06-01');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170602, '2017-06-02');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170603, '2017-06-03');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170604, '2017-06-04');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170605, '2017-06-05');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170606, '2017-06-06');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170607, '2017-06-07');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170608, '2017-06-08');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170609, '2017-06-09');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170610, '2017-06-10');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170611, '2017-06-11');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170612, '2017-06-12');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170613, '2017-06-13');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170614, '2017-06-14');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170615, '2017-06-15');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170616, '2017-06-16');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170617, '2017-06-17');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170618, '2017-06-18');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170619, '2017-06-19');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170620, '2017-06-20');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170621, '2017-06-21');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170622, '2017-06-22');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170623, '2017-06-23');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170624, '2017-06-24');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170625, '2017-06-25');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170626, '2017-06-26');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170627, '2017-06-27');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170628, '2017-06-28');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170629, '2017-06-29');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170630, '2017-06-30');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170701, '2017-07-01');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170702, '2017-07-02');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170703, '2017-07-03');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170704, '2017-07-04');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170705, '2017-07-05');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170706, '2017-07-06');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170707, '2017-07-07');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170708, '2017-07-08');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170709, '2017-07-09');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170710, '2017-07-10');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170711, '2017-07-11');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170712, '2017-07-12');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170713, '2017-07-13');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170714, '2017-07-14');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170715, '2017-07-15');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170716, '2017-07-16');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170717, '2017-07-17');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170718, '2017-07-18');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170719, '2017-07-19');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170720, '2017-07-20');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170721, '2017-07-21');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170722, '2017-07-22');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170723, '2017-07-23');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170724, '2017-07-24');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170725, '2017-07-25');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170726, '2017-07-26');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170727, '2017-07-27');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170728, '2017-07-28');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170729, '2017-07-29');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170730, '2017-07-30');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170731, '2017-07-31');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170801, '2017-08-01');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170802, '2017-08-02');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170803, '2017-08-03');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170804, '2017-08-04');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170805, '2017-08-05');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170806, '2017-08-06');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170807, '2017-08-07');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170808, '2017-08-08');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170809, '2017-08-09');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170810, '2017-08-10');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170811, '2017-08-11');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170812, '2017-08-12');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170813, '2017-08-13');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170814, '2017-08-14');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170815, '2017-08-15');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170816, '2017-08-16');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170817, '2017-08-17');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170818, '2017-08-18');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170819, '2017-08-19');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170820, '2017-08-20');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170821, '2017-08-21');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170822, '2017-08-22');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170823, '2017-08-23');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170824, '2017-08-24');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170825, '2017-08-25');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170826, '2017-08-26');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170827, '2017-08-27');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170828, '2017-08-28');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170829, '2017-08-29');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170830, '2017-08-30');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170831, '2017-08-31');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170901, '2017-09-01');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170902, '2017-09-02');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170903, '2017-09-03');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170904, '2017-09-04');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170905, '2017-09-05');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170906, '2017-09-06');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170907, '2017-09-07');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170908, '2017-09-08');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170909, '2017-09-09');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170910, '2017-09-10');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170911, '2017-09-11');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170912, '2017-09-12');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170913, '2017-09-13');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170914, '2017-09-14');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170915, '2017-09-15');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170916, '2017-09-16');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170917, '2017-09-17');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170918, '2017-09-18');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170919, '2017-09-19');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170920, '2017-09-20');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170921, '2017-09-21');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170922, '2017-09-22');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170923, '2017-09-23');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170924, '2017-09-24');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170925, '2017-09-25');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170926, '2017-09-26');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170927, '2017-09-27');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170928, '2017-09-28');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170929, '2017-09-29');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20170930, '2017-09-30');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171001, '2017-10-01');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171002, '2017-10-02');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171003, '2017-10-03');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171004, '2017-10-04');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171005, '2017-10-05');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171006, '2017-10-06');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171007, '2017-10-07');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171008, '2017-10-08');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171009, '2017-10-09');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171010, '2017-10-10');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171011, '2017-10-11');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171012, '2017-10-12');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171013, '2017-10-13');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171014, '2017-10-14');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171015, '2017-10-15');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171016, '2017-10-16');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171017, '2017-10-17');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171018, '2017-10-18');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171019, '2017-10-19');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171020, '2017-10-20');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171021, '2017-10-21');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171022, '2017-10-22');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171023, '2017-10-23');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171024, '2017-10-24');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171025, '2017-10-25');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171026, '2017-10-26');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171027, '2017-10-27');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171028, '2017-10-28');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171029, '2017-10-29');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171030, '2017-10-30');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171031, '2017-10-31');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171101, '2017-11-01');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171102, '2017-11-02');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171103, '2017-11-03');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171104, '2017-11-04');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171105, '2017-11-05');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171106, '2017-11-06');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171107, '2017-11-07');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171108, '2017-11-08');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171109, '2017-11-09');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171110, '2017-11-10');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171111, '2017-11-11');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171112, '2017-11-12');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171113, '2017-11-13');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171114, '2017-11-14');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171115, '2017-11-15');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171116, '2017-11-16');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171117, '2017-11-17');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171118, '2017-11-18');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171119, '2017-11-19');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171120, '2017-11-20');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171121, '2017-11-21');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171122, '2017-11-22');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171123, '2017-11-23');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171124, '2017-11-24');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171125, '2017-11-25');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171126, '2017-11-26');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171127, '2017-11-27');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171128, '2017-11-28');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171129, '2017-11-29');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171130, '2017-11-30');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171201, '2017-12-01');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171202, '2017-12-02');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171203, '2017-12-03');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171204, '2017-12-04');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171205, '2017-12-05');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171206, '2017-12-06');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171207, '2017-12-07');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171208, '2017-12-08');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171209, '2017-12-09');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171210, '2017-12-10');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171211, '2017-12-11');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171212, '2017-12-12');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171213, '2017-12-13');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171214, '2017-12-14');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171215, '2017-12-15');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171216, '2017-12-16');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171217, '2017-12-17');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171218, '2017-12-18');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171219, '2017-12-19');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171220, '2017-12-20');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171221, '2017-12-21');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171222, '2017-12-22');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171223, '2017-12-23');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171224, '2017-12-24');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171225, '2017-12-25');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171226, '2017-12-26');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171227, '2017-12-27');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171228, '2017-12-28');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171229, '2017-12-29');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171230, '2017-12-30');
INSERT INTO DimDate (DateKey, FullDate) VALUES (20171231, '2017-12-31');
