/****************************************************************************************/
/*																						*/
/*	Kroenke, Auer, Vandenberg, and Yoder - Database Concepts (8th Edition) Chapter 08	*/
/*																						*/
/*	Heather Sweeney Designs Data Warehouse Database Load Tables							*/
/*																						*/
/*	These are the Microsoft SQL Server 2016 code solutions								*/
/*																						*/
/****************************************************************************************/
INSERT INTO TIMELINE VALUES (42658, '15-OCT-2016', 10, 'October', 3, 'Qtr3', 2016);
INSERT INTO TIMELINE VALUES (42668, '25-OCT-2016', 10, 'October', 3, 'Qtr3', 2016);
INSERT INTO TIMELINE VALUES (42724, '20-DEC-2016', 12, 'December', 3, 'Qtr3', 2016);
INSERT INTO TIMELINE VALUES (42819, '25-MAR-2017', 3, 'March', 1, 'Qtr1', 2017);
INSERT INTO TIMELINE VALUES (42821, '27-MAR-2017', 3, 'March', 1, 'Qtr1', 2017);
INSERT INTO TIMELINE VALUES (42825, '31-MAR-2017', 3, 'March', 1, 'Qtr1', 2017);
INSERT INTO TIMELINE VALUES (42828, '03-APR-2017', 4, 'April', 2, 'Qtr2', 2017);
INSERT INTO TIMELINE VALUES (42833, '08-APR-2017', 4, 'April', 2, 'Qtr2', 2017);
INSERT INTO TIMELINE VALUES (42848, '23-APR-2017', 4, 'April', 2, 'Qtr2', 2017);
INSERT INTO TIMELINE VALUES (42862, '07-MAY-2017', 5, 'May', 2, 'Qtr2', 2017);
INSERT INTO TIMELINE VALUES (42876, '21-MAY-2017', 5, 'May', 2, 'Qtr2', 2017);
INSERT INTO TIMELINE VALUES (42891, '05-JUN-2017', 6, 'June', 2, 'Qtr2', 2017)

INSERT INTO CUSTOMER VALUES (1, 'Jacobs, Nancy', 'somewhere.com', '817', 'Fort Worth', 'TX', '76110');
INSERT INTO CUSTOMER VALUES (2, 'Jacobs, Chantel', 'somewhere.com', '817', 'Fort Worth', 'TX', '76112');
INSERT INTO CUSTOMER VALUES (3, 'Able, Ralph', 'somewhere.com', '210', 'San Antonio', 'TX', '78214');
INSERT INTO CUSTOMER VALUES (4, 'Baker, Susan', 'elsewhere.com', '210', 'San Antonio', 'TX', '78216');
INSERT INTO CUSTOMER VALUES (5, 'Eagleton, Sam', 'elsewhere.com', '210', 'San Antonio', 'TX', '78218');
INSERT INTO CUSTOMER VALUES (6, 'Foxtrot, Kathy', 'somewhere.com', '972', 'Dallas', 'TX', '75220');
INSERT INTO CUSTOMER VALUES (7, 'George, Sally', 'somewhere.com', '972', 'Dallas', 'TX', '75223');
INSERT INTO CUSTOMER VALUES (8, 'Hullett, Shawn', 'elsewhere.com', '972', 'Dallas', 'TX', '75224');
INSERT INTO CUSTOMER VALUES (9, 'Pearson, Bobbi', 'elsewhere.com', '512', 'Austin', 'TX', '78710');
INSERT INTO CUSTOMER VALUES (10, 'Ranger, Terry', 'somewhere.com', '512', 'Austin', 'TX', '78712');
INSERT INTO CUSTOMER VALUES (11, 'Tyler, Jenny', 'somewhere.com', '972', 'Dallas', 'TX', '75225');
INSERT INTO CUSTOMER VALUES (12, 'Wayne, Joan', 'elsewhere.com', '817', 'Fort Worth', 'TX', '76115');

INSERT INTO PRODUCT VALUES ('BK001', 'Book', 'Kitchen Remodeling Basics For Everyone');
INSERT INTO PRODUCT VALUES ('BK002', 'Book', 'Advanced Kitchen Remodeling For Everyone');
INSERT INTO PRODUCT VALUES ('BK003', 'Book', 'Kitchen Remodeling Dallas Style For Everyone');
INSERT INTO PRODUCT VALUES ('VB001', 'Video Companion', 'Kitchen Remodeling Basics Video Companion');
INSERT INTO PRODUCT VALUES ('VB002', 'Video Companion', 'Advanced Kitchen Remodeling Video Companion');
INSERT INTO PRODUCT VALUES ('VB003', 'Video Companion', 'Kitchen Remodeling Dallas Style Video Companion');
INSERT INTO PRODUCT VALUES ('VK001', 'Video', 'Kitchen Remodeling Basics');
INSERT INTO PRODUCT VALUES ('VK002', 'Video', 'Advanced Kitchen Remodeling');
INSERT INTO PRODUCT VALUES ('VK003', 'Video', 'Kitchen Remodeling Dallas Style');
INSERT INTO PRODUCT VALUES ('VK004', 'Video', 'Heather Sweeney Seminar Live in Dallas on 25-OCT-15');

INSERT INTO PRODUCT_SALES VALUES (42658, 3, 'VB001', 1, 7.99, 7.99, 1);
INSERT INTO PRODUCT_SALES VALUES (42658, 3, 'VK001', 1, 14.95, 14.95, 1);
INSERT INTO PRODUCT_SALES VALUES (42668, 4, 'BK001', 1, 24.95, 24.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42668, 4, 'VB001', 1, 7.99, 7.99, 2);
INSERT INTO PRODUCT_SALES VALUES (42668, 4, 'VK001', 1, 14.95, 14.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42724, 7, 'VK004', 1, 24.95, 24.95, 1);
INSERT INTO PRODUCT_SALES VALUES (42819, 4, 'BK002', 1, 24.95, 24.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42819, 4, 'VK002', 1, 14.95, 14.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42819, 4, 'VK004', 1, 24.95, 24.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42821, 6, 'BK002', 1, 24.95, 24.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42821, 6, 'VB003', 1, 9.99, 9.99, 2);
INSERT INTO PRODUCT_SALES VALUES (42821, 6, 'VK002', 1, 14.95, 14.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42821, 6, 'VK003', 1, 19.95, 19.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42821, 6, 'VK004', 1, 24.95, 24.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42821, 7, 'BK001', 1, 24.95, 24.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42821, 7, 'BK002', 1, 24.95, 24.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42821, 7, 'VK003', 1, 19.95, 19.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42821, 7, 'VK004', 1, 24.95, 24.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42825, 9, 'BK001', 1, 24.95, 24.95, 1);
INSERT INTO PRODUCT_SALES VALUES (42825, 9, 'VB001', 1, 7.99, 7.99, 1);
INSERT INTO PRODUCT_SALES VALUES (42825, 9, 'VK001', 1, 14.95, 14.95, 1);
INSERT INTO PRODUCT_SALES VALUES (42828, 11, 'VB003', 2, 9.99, 19.98, 2);
INSERT INTO PRODUCT_SALES VALUES (42828, 11, 'VK003', 2, 19.95, 39.90, 2);
INSERT INTO PRODUCT_SALES VALUES (42828, 11, 'VK004', 2, 24.95, 49.90, 2);
INSERT INTO PRODUCT_SALES VALUES (42833, 1, 'BK001', 1, 24.95, 24.95, 1);
INSERT INTO PRODUCT_SALES VALUES (42833, 1, 'VB001', 1, 7.99, 7.99, 1);
INSERT INTO PRODUCT_SALES VALUES (42833, 1, 'VK001', 1, 14.95, 14.95, 1);
INSERT INTO PRODUCT_SALES VALUES (42833, 5, 'BK001', 1, 24.95, 24.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42833, 5, 'VB001', 1, 7.99, 7.99, 2);
INSERT INTO PRODUCT_SALES VALUES (42833, 5, 'VK001', 1, 14.95, 14.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42848, 3, 'BK001', 1, 24.95, 24.95, 1);
INSERT INTO PRODUCT_SALES VALUES (42862, 9, 'VB002', 1, 7.99, 7.99, 1);
INSERT INTO PRODUCT_SALES VALUES (42862, 9, 'VK002', 1, 14.95, 14.95, 1);
INSERT INTO PRODUCT_SALES VALUES (42876, 8, 'VB003', 1, 9.99, 9.99, 2);
INSERT INTO PRODUCT_SALES VALUES (42876, 8, 'VK003', 1, 19.95, 19.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42876, 8, 'VK004', 1, 24.95, 24.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42891, 3, 'BK002', 1, 24.95, 24.95, 1);
INSERT INTO PRODUCT_SALES VALUES (42891, 3, 'VB001', 1, 7.99, 7.99, 1);
INSERT INTO PRODUCT_SALES VALUES (42891, 3, 'VB002', 2, 7.99, 15.98, 1);
INSERT INTO PRODUCT_SALES VALUES (42891, 3, 'VK001', 1, 14.95, 14.95, 1);
INSERT INTO PRODUCT_SALES VALUES (42891, 3, 'VK002', 2, 14.95, 29.90, 1);
INSERT INTO PRODUCT_SALES VALUES (42891, 11, 'VB002', 2, 7.99, 15.98, 2);
INSERT INTO PRODUCT_SALES VALUES (42891, 11, 'VK002', 2, 14.95, 29.90, 2);
INSERT INTO PRODUCT_SALES VALUES (42891, 12, 'BK002', 1, 24.95, 24.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42891, 12, 'VB003', 1, 9.99, 9.99, 2);
INSERT INTO PRODUCT_SALES VALUES (42891, 12, 'VK002', 1, 14.95, 14.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42891, 12, 'VK003', 1, 19.95, 19.95, 2);
INSERT INTO PRODUCT_SALES VALUES (42891, 12, 'VK004', 1, 24.95, 24.95, 2);
