LISTING 1: Code That Creates and Populates the Sales Table

CREATE TABLE Sales
(
  salesdate DATETIME NOT NULL,
  qty       INT      NOT NULL,
  /* other columns */
)

SET NOCOUNT ON
INSERT INTO Sales VALUES('20011203', 10)
INSERT INTO Sales VALUES('20011207', 11)
INSERT INTO Sales VALUES('20011210',  6)
INSERT INTO Sales VALUES('20011211', 21)
INSERT INTO Sales VALUES('20011215',  3)