SET NOCOUNT ON --Create a table in 3rd Normal form to store price history CREATE TABLE PRICES ( tdate date, ticker char(5), price money, PRIMARY KEY (tdate, ticker) ) --Put some data into a table INSERT INTO PRICES SELECT * FROM (VALUES ('2015-03-05','AAPL',126.41),('2015-03-05','GOOG',575.33),('2015-03-05','MSFT',43.11),('2015-03-05','YHOO',44.16),('2015-03-05','FB',81.21),('2015-03-05','BIDU',214.23),('2015-03-05','LNKD',268.34),('2015-03-05','TWTR',47.35), ('2015-03-04','AAPL',128.54),('2015-03-04','GOOG',573.37),('2015-03-04','MSFT',43.06),('2015-03-04','YHOO',43.99),('2015-03-04','FB',80.9),('2015-03-04','BIDU',207.69),('2015-03-04','LNKD',265.23),('2015-03-04','TWTR',47.57), ('2015-03-03','AAPL',129.36),('2015-03-03','GOOG',573.64),('2015-03-03','MSFT',43.28),('2015-03-03','YHOO',42.62),('2015-03-03','FB',79.6),('2015-03-03','BIDU',206.34),('2015-03-03','LNKD',265.54),('2015-03-03','TWTR',47.71), ('2015-03-02','AAPL',129.09),('2015-03-02','GOOG',571.34),('2015-03-02','MSFT',43.88),('2015-03-02','YHOO',44.11),('2015-03-02','FB',79.75),('2015-03-02','BIDU',205.04),('2015-03-02','LNKD',269.42),('2015-03-02','TWTR',48.15), ('2015-02-27','AAPL',128.46),('2015-02-27','GOOG',558.4),('2015-02-27','MSFT',43.85),('2015-02-27','YHOO',44.28),('2015-02-27','FB',78.97),('2015-02-27','BIDU',203.75),('2015-02-27','LNKD',267.2),('2015-02-27','TWTR',48.08), ('2015-02-26','AAPL',130.42),('2015-02-26','GOOG',555.48),('2015-02-26','MSFT',44.06),('2015-02-26','YHOO',44.45),('2015-02-26','FB',80.41),('2015-02-26','BIDU',205.88),('2015-02-26','LNKD',270.76),('2015-02-26','TWTR',49.41), ('2015-02-25','AAPL',128.79),('2015-02-25','GOOG',543.87),('2015-02-25','MSFT',43.99),('2015-02-25','YHOO',44.43),('2015-02-25','FB',79.56),('2015-02-25','BIDU',203.53),('2015-02-25','LNKD',269),('2015-02-25','TWTR',48.55), ('2015-02-24','AAPL',132.17),('2015-02-24','GOOG',536.09),('2015-02-24','MSFT',44.09),('2015-02-24','YHOO',43.38),('2015-02-24','FB',78.45),('2015-02-24','BIDU',208.06),('2015-02-24','LNKD',264.26),('2015-02-24','TWTR',48.69), ('2015-02-23','AAPL',133),('2015-02-23','GOOG',531.91),('2015-02-23','MSFT',44.15),('2015-02-23','YHOO',43.53),('2015-02-23','FB',78.84),('2015-02-23','BIDU',206.43),('2015-02-23','LNKD',264.21),('2015-02-23','TWTR',48.47), ('2015-02-20','AAPL',129.5),('2015-02-20','GOOG',538.95),('2015-02-20','MSFT',43.86),('2015-02-20','YHOO',44.11),('2015-02-20','FB',79.9),('2015-02-20','BIDU',209.63),('2015-02-20','LNKD',267.63),('2015-02-20','TWTR',49.11), ('2015-02-19','AAPL',128.45),('2015-02-19','GOOG',542.87),('2015-02-19','MSFT',43.5),('2015-02-19','YHOO',44.37),('2015-02-19','FB',79.42),('2015-02-19','BIDU',207.24),('2015-02-19','LNKD',266.34),('2015-02-19','TWTR',48.7), ('2015-02-18','AAPL',128.72),('2015-02-18','GOOG',539.7),('2015-02-18','MSFT',43.53),('2015-02-18','YHOO',43.65),('2015-02-18','FB',76.71),('2015-02-18','BIDU',207.15),('2015-02-18','LNKD',266.91),('2015-02-18','TWTR',47.82), ('2015-02-17','AAPL',127.83),('2015-02-17','GOOG',542.84),('2015-02-17','MSFT',43.58),('2015-02-17','YHOO',43.53),('2015-02-17','FB',75.6),('2015-02-17','BIDU',208.81),('2015-02-17','LNKD',265.75),('2015-02-17','TWTR',48.03), ('2015-02-13','AAPL',127.08),('2015-02-13','GOOG',549.01),('2015-02-13','MSFT',43.56),('2015-02-13','YHOO',44.42),('2015-02-13','FB',75.74),('2015-02-13','BIDU',212.13),('2015-02-13','LNKD',269),('2015-02-13','TWTR',48.5), ('2015-02-12','AAPL',126.46),('2015-02-12','GOOG',542.93),('2015-02-12','MSFT',42.79),('2015-02-12','YHOO',43.93),('2015-02-12','FB',76.23),('2015-02-12','BIDU',205.02),('2015-02-12','LNKD',267.17),('2015-02-12','TWTR',47.95), ('2015-02-11','AAPL',124.88),('2015-02-11','GOOG',535.97),('2015-02-11','MSFT',42.08),('2015-02-11','YHOO',42.96),('2015-02-11','FB',76.51),('2015-02-11','BIDU',214.67),('2015-02-11','LNKD',267.92),('2015-02-11','TWTR',47.5), ('2015-02-10','AAPL',122.02),('2015-02-10','GOOG',536.94),('2015-02-10','MSFT',42.3),('2015-02-10','YHOO',43.07),('2015-02-10','FB',75.19),('2015-02-10','BIDU',219.44),('2015-02-10','LNKD',269.75),('2015-02-10','TWTR',46.26), ('2015-02-09','AAPL',119.72),('2015-02-09','GOOG',527.83),('2015-02-09','MSFT',42.06),('2015-02-09','YHOO',42.57),('2015-02-09','FB',74.44),('2015-02-09','BIDU',215.03),('2015-02-09','LNKD',267.43),('2015-02-09','TWTR',47.32), ('2015-02-06','AAPL',118.93),('2015-02-06','GOOG',531),('2015-02-06','MSFT',42.11),('2015-02-06','YHOO',42.94),('2015-02-06','FB',74.47),('2015-02-06','BIDU',211.78),('2015-02-06','LNKD',263.4),('2015-02-06','TWTR',48.01), ('2015-02-05','AAPL',119.94),('2015-02-05','GOOG',527.58),('2015-02-05','MSFT',42.15),('2015-02-05','YHOO',43.55),('2015-02-05','FB',75.61),('2015-02-05','BIDU',216.8),('2015-02-05','LNKD',237.97),('2015-02-05','TWTR',41.26), ('2015-02-04','AAPL',119.09),('2015-02-04','GOOG',522.76),('2015-02-04','MSFT',41.54),('2015-02-04','YHOO',44.05),('2015-02-04','FB',75.63),('2015-02-04','BIDU',217.24),('2015-02-04','LNKD',232.03),('2015-02-04','TWTR',40.72), ('2015-02-03','AAPL',118.18),('2015-02-03','GOOG',529.24),('2015-02-03','MSFT',41.31),('2015-02-03','YHOO',44.7),('2015-02-03','FB',75.4),('2015-02-03','BIDU',217.16),('2015-02-03','LNKD',232.76),('2015-02-03','TWTR',39.79), ('2015-02-02','AAPL',118.16),('2015-02-02','GOOG',528.48),('2015-02-02','MSFT',40.99),('2015-02-02','YHOO',44.69),('2015-02-02','FB',74.99),('2015-02-02','BIDU',217.6),('2015-02-02','LNKD',224.57),('2015-02-02','TWTR',37.46), ('2015-01-30','AAPL',116.7),('2015-01-30','GOOG',534.52),('2015-01-30','MSFT',40.11),('2015-01-30','YHOO',43.99),('2015-01-30','FB',75.91),('2015-01-30','BIDU',217.92),('2015-01-30','LNKD',224.74),('2015-01-30','TWTR',37.53), ('2015-01-29','AAPL',118.43),('2015-01-29','GOOG',510.66),('2015-01-29','MSFT',41.71),('2015-01-29','YHOO',43.73),('2015-01-29','FB',78),('2015-01-29','BIDU',220.39),('2015-01-29','LNKD',223.04),('2015-01-29','TWTR',36.68), ('2015-01-28','AAPL',114.86),('2015-01-28','GOOG',510),('2015-01-28','MSFT',40.9),('2015-01-28','YHOO',46.46),('2015-01-28','FB',76.24),('2015-01-28','BIDU',220.31),('2015-01-28','LNKD',220.46),('2015-01-28','TWTR',37.15), ('2015-01-27','AAPL',108.71),('2015-01-27','GOOG',518.63),('2015-01-27','MSFT',42.36),('2015-01-27','YHOO',47.99),('2015-01-27','FB',75.78),('2015-01-27','BIDU',227.53),('2015-01-27','LNKD',222.62),('2015-01-27','TWTR',38.92), ('2015-01-26','AAPL',112.66),('2015-01-26','GOOG',535.21),('2015-01-26','MSFT',46.68),('2015-01-26','YHOO',49.44),('2015-01-26','FB',77.5),('2015-01-26','BIDU',229.46),('2015-01-26','LNKD',226.36),('2015-01-26','TWTR',40.1), ('2015-01-23','AAPL',112.54),('2015-01-23','GOOG',539.95),('2015-01-23','MSFT',46.85),('2015-01-23','YHOO',48.95),('2015-01-23','FB',77.83),('2015-01-23','BIDU',233.33),('2015-01-23','LNKD',232.22),('2015-01-23','TWTR',39.42), ('2015-01-22','AAPL',111.96),('2015-01-22','GOOG',534.39),('2015-01-22','MSFT',46.8),('2015-01-22','YHOO',48.89),('2015-01-22','FB',77.65),('2015-01-22','BIDU',229.88),('2015-01-22','LNKD',224.94),('2015-01-22','TWTR',39.07), ('2015-01-21','AAPL',109.12),('2015-01-21','GOOG',518.04),('2015-01-21','MSFT',45.6),('2015-01-21','YHOO',48.18),('2015-01-21','FB',76.74),('2015-01-21','BIDU',228.28),('2015-01-21','LNKD',219.2),('2015-01-21','TWTR',37.83), ('2015-01-20','AAPL',108.29),('2015-01-20','GOOG',506.9),('2015-01-20','MSFT',46.06),('2015-01-20','YHOO',47.63),('2015-01-20','FB',76.24),('2015-01-20','BIDU',220.36),('2015-01-20','LNKD',213.06),('2015-01-20','TWTR',37.57), ('2015-01-16','AAPL',105.57),('2015-01-16','GOOG',508.08),('2015-01-16','MSFT',45.91),('2015-01-16','YHOO',46.47),('2015-01-16','FB',75.18),('2015-01-16','BIDU',220.2),('2015-01-16','LNKD',214.18),('2015-01-16','TWTR',37.31), ('2015-01-15','AAPL',106.4),('2015-01-15','GOOG',501.79),('2015-01-15','MSFT',45.16),('2015-01-15','YHOO',46.23),('2015-01-15','FB',74.05),('2015-01-15','BIDU',215.97),('2015-01-15','LNKD',213.21),('2015-01-15','TWTR',36.93), ('2015-01-14','AAPL',109.37),('2015-01-14','GOOG',500.87),('2015-01-14','MSFT',45.64),('2015-01-14','YHOO',47.51),('2015-01-14','FB',76.28),('2015-01-14','BIDU',216.82),('2015-01-14','LNKD',219.43),('2015-01-14','TWTR',39.85), ('2015-01-13','AAPL',109.79),('2015-01-13','GOOG',496.18),('2015-01-13','MSFT',46.03),('2015-01-13','YHOO',48.3),('2015-01-13','FB',76.45),('2015-01-13','BIDU',219.6),('2015-01-13','LNKD',223),('2015-01-13','TWTR',39.65), ('2015-01-12','AAPL',108.82),('2015-01-12','GOOG',492.55),('2015-01-12','MSFT',46.27),('2015-01-12','YHOO',48.8),('2015-01-12','FB',76.72),('2015-01-12','BIDU',220.89),('2015-01-12','LNKD',223.13),('2015-01-12','TWTR',39.37), ('2015-01-09','AAPL',111.57),('2015-01-09','GOOG',496.17),('2015-01-09','MSFT',46.86),('2015-01-09','YHOO',49.72),('2015-01-09','FB',77.74),('2015-01-09','BIDU',226.9),('2015-01-09','LNKD',227.13),('2015-01-09','TWTR',40.17), ('2015-01-08','AAPL',111.45),('2015-01-08','GOOG',502.68),('2015-01-08','MSFT',47.25),('2015-01-08','YHOO',50.23),('2015-01-08','FB',78.18),('2015-01-08','BIDU',229.21),('2015-01-08','LNKD',227.05),('2015-01-08','TWTR',39.09), ('2015-01-07','AAPL',107.33),('2015-01-07','GOOG',501.1),('2015-01-07','MSFT',45.9),('2015-01-07','YHOO',48.59),('2015-01-07','FB',76.15),('2015-01-07','BIDU',224.35),('2015-01-07','LNKD',222.16),('2015-01-07','TWTR',37.28), ('2015-01-06','AAPL',105.84),('2015-01-06','GOOG',501.96),('2015-01-06','MSFT',45.33),('2015-01-06','YHOO',49.21),('2015-01-06','FB',76.15),('2015-01-06','BIDU',220.18),('2015-01-06','LNKD',219.51),('2015-01-06','TWTR',38.76), ('2015-01-05','AAPL',105.83),('2015-01-05','GOOG',513.87),('2015-01-05','MSFT',46),('2015-01-05','YHOO',49.13),('2015-01-05','FB',77.19),('2015-01-05','BIDU',219.79),('2015-01-05','LNKD',227.51),('2015-01-05','TWTR',36.38), ('2015-01-02','AAPL',108.9),('2015-01-02','GOOG',524.81),('2015-01-02','MSFT',46.43),('2015-01-02','YHOO',50.17),('2015-01-02','FB',78.45),('2015-01-02','BIDU',223.08),('2015-01-02','LNKD',229.65),('2015-01-02','TWTR',36.56), ('2014-12-31','AAPL',109.95),('2014-12-31','GOOG',526.4),('2014-12-31','MSFT',46.12),('2014-12-31','YHOO',50.51),('2014-12-31','FB',78.02),('2014-12-31','BIDU',227.97),('2014-12-31','LNKD',229.71),('2014-12-31','TWTR',35.87), ('2014-12-30','AAPL',112.08),('2014-12-30','GOOG',530.42),('2014-12-30','MSFT',46.69),('2014-12-30','YHOO',51.22),('2014-12-30','FB',79.22),('2014-12-30','BIDU',230.01),('2014-12-30','LNKD',232.67),('2014-12-30','TWTR',35.86), ('2014-12-29','AAPL',113.46),('2014-12-29','GOOG',530.33),('2014-12-29','MSFT',47.11),('2014-12-29','YHOO',50.53),('2014-12-29','FB',80.02),('2014-12-29','BIDU',230.21),('2014-12-29','LNKD',233.34),('2014-12-29','TWTR',36.42), ('2014-12-26','AAPL',113.54),('2014-12-26','GOOG',534.03),('2014-12-26','MSFT',47.54),('2014-12-26','YHOO',50.86),('2014-12-26','FB',80.78),('2014-12-26','BIDU',234.88),('2014-12-26','LNKD',235.25),('2014-12-26','TWTR',37.6), ('2014-12-24','AAPL',111.57),('2014-12-24','GOOG',528.77),('2014-12-24','MSFT',47.8),('2014-12-24','YHOO',50.65),('2014-12-24','FB',80.77),('2014-12-24','BIDU',230.98),('2014-12-24','LNKD',231.83),('2014-12-24','TWTR',37.61), ('2014-12-23','AAPL',112.1),('2014-12-23','GOOG',530.59),('2014-12-23','MSFT',48.11),('2014-12-23','YHOO',50.02),('2014-12-23','FB',80.61),('2014-12-23','BIDU',233.16),('2014-12-23','LNKD',231.49),('2014-12-23','TWTR',37.57), ('2014-12-22','AAPL',112.5),('2014-12-22','GOOG',524.87),('2014-12-22','MSFT',47.64),('2014-12-22','YHOO',51.15),('2014-12-22','FB',81.45),('2014-12-22','BIDU',234.6),('2014-12-22','LNKD',233),('2014-12-22','TWTR',38.43), ('2014-12-19','AAPL',111.34),('2014-12-19','GOOG',516.35),('2014-12-19','MSFT',47.32),('2014-12-19','YHOO',50.88),('2014-12-19','FB',79.88),('2014-12-19','BIDU',234.23),('2014-12-19','LNKD',234.61),('2014-12-19','TWTR',37.08), ('2014-12-18','AAPL',112.21),('2014-12-18','GOOG',511.1),('2014-12-18','MSFT',47.18),('2014-12-18','YHOO',50.91),('2014-12-18','FB',78.4),('2014-12-18','BIDU',231.88),('2014-12-18','LNKD',231.84),('2014-12-18','TWTR',36.73), ('2014-12-17','AAPL',108.98),('2014-12-17','GOOG',504.89),('2014-12-17','MSFT',45.42),('2014-12-17','YHOO',50.12),('2014-12-17','FB',76.11),('2014-12-17','BIDU',223.85),('2014-12-17','LNKD',219.78),('2014-12-17','TWTR',35.57), ('2014-12-16','AAPL',106.33),('2014-12-16','GOOG',495.39),('2014-12-16','MSFT',44.84),('2014-12-16','YHOO',48.85),('2014-12-16','FB',74.69),('2014-12-16','BIDU',219.96),('2014-12-16','LNKD',215.57),('2014-12-16','TWTR',35.13), ('2014-12-15','AAPL',107.8),('2014-12-15','GOOG',513.8),('2014-12-15','MSFT',46.34),('2014-12-15','YHOO',49.82),('2014-12-15','FB',76.99),('2014-12-15','BIDU',225.81),('2014-12-15','LNKD',218.02),('2014-12-15','TWTR',36.85), ('2014-12-12','AAPL',109.3),('2014-12-12','GOOG',518.66),('2014-12-12','MSFT',46.62),('2014-12-12','YHOO',50.24),('2014-12-12','FB',77.83),('2014-12-12','BIDU',229.32),('2014-12-12','LNKD',219.9),('2014-12-12','TWTR',37.1), ('2014-12-11','AAPL',111.18),('2014-12-11','GOOG',528.34),('2014-12-11','MSFT',46.84),('2014-12-11','YHOO',49.94),('2014-12-11','FB',77.73),('2014-12-11','BIDU',229.23),('2014-12-11','LNKD',217.36),('2014-12-11','TWTR',36.7), ('2014-12-10','AAPL',111.51),('2014-12-10','GOOG',526.06),('2014-12-10','MSFT',46.57),('2014-12-10','YHOO',49.21),('2014-12-10','FB',76.18),('2014-12-10','BIDU',225.12),('2014-12-10','LNKD',215.07),('2014-12-10','TWTR',36.35), ('2014-12-09','AAPL',113.67),('2014-12-09','GOOG',533.37),('2014-12-09','MSFT',47.25),('2014-12-09','YHOO',50.51),('2014-12-09','FB',76.84),('2014-12-09','BIDU',229.9),('2014-12-09','LNKD',215.47),('2014-12-09','TWTR',37.05), ('2014-12-08','AAPL',111.96),('2014-12-08','GOOG',526.98),('2014-12-08','MSFT',47.36),('2014-12-08','YHOO',49.62),('2014-12-08','FB',76.52),('2014-12-08','BIDU',227.67),('2014-12-08','LNKD',211.94),('2014-12-08','TWTR',36.29), ('2014-12-05','AAPL',114.55),('2014-12-05','GOOG',525.26),('2014-12-05','MSFT',48.08),('2014-12-05','YHOO',50.99),('2014-12-05','FB',76.36),('2014-12-05','BIDU',232.72),('2014-12-05','LNKD',218.08),('2014-12-05','TWTR',38.49), ('2014-12-04','AAPL',115.04),('2014-12-04','GOOG',537.31),('2014-12-04','MSFT',48.49),('2014-12-04','YHOO',50.41),('2014-12-04','FB',75.24),('2014-12-04','BIDU',230.81),('2014-12-04','LNKD',218.83),('2014-12-04','TWTR',38.79), ('2014-12-03','AAPL',115.47),('2014-12-03','GOOG',531.32),('2014-12-03','MSFT',47.74),('2014-12-03','YHOO',50.28),('2014-12-03','FB',74.88),('2014-12-03','BIDU',231.29),('2014-12-03','LNKD',217.74),('2014-12-03','TWTR',39.06), ('2014-12-02','AAPL',114.18),('2014-12-02','GOOG',533.75),('2014-12-02','MSFT',48.12),('2014-12-02','YHOO',50.67),('2014-12-02','FB',75.46),('2014-12-02','BIDU',234.74),('2014-12-02','LNKD',215.02),('2014-12-02','TWTR',38.91), ('2014-12-01','AAPL',114.62),('2014-12-01','GOOG',533.8),('2014-12-01','MSFT',48.28),('2014-12-01','YHOO',50.1),('2014-12-01','FB',75.1),('2014-12-01','BIDU',236.61),('2014-12-01','LNKD',216.81),('2014-12-01','TWTR',39.04), ('2014-11-28','AAPL',118.46),('2014-11-28','GOOG',541.83),('2014-11-28','MSFT',47.47),('2014-11-28','YHOO',51.74),('2014-11-28','FB',77.7),('2014-11-28','BIDU',245.11),('2014-11-28','LNKD',226.27),('2014-11-28','TWTR',41.74) )n(tdate,ticker,price)