Listing 1: Code That Creates and Populates the Stores and Sales Tables
USE tempdb;
GO
IF OBJECT_ID('dbo.Sales') IS NOT NULL
  DROP TABLE dbo.Sales;
GO
IF OBJECT_ID('dbo.Stores') IS NOT NULL
  DROP TABLE dbo.Stores;
GO
CREATE TABLE dbo.Stores
(  storeid   int NOT NULL,
  storename varchar(25) NOT NULL,
  /* other columns */
  CONSTRAINT PK_Stores PRIMARY KEY(storeid)  );
GO
CREATE TABLE dbo.Sales
(  storeid int NOT NULL,
  dt datetime NOT NULL,
  revenue money NOT NULL,
  /* other columns */
  CONSTRAINT PK_Sales PRIMARY KEY(storeid, dt),
  CONSTRAINT FK_Stores_Sales
    FOREIGN KEY(storeid)
    REFERENCES dbo.Stores(storeid)  );
GO

SET NOCOUNT ON;
INSERT INTO dbo.Stores(storeid, storename) VALUES(1, 'Zion');
INSERT INTO dbo.Stores(storeid, storename) VALUES(2, 'Canyonlands');
INSERT INTO dbo.Stores(storeid, storename) VALUES(3, 'Shenandoah');

INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(1, '20050101', 1100.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(1, '20050102', 1000.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(1, '20050103', 1250.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(1, '20050123', 1050.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(1, '20050124', 1020.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(1, '20050125', 1130.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(1, '20050126', 1015.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(2, '20050105', 2050.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(2, '20050106', 1990.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(2, '20050110', 2210.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(2, '20050128', 2230.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(2, '20050129', 2040.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(2, '20050130', 2345.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(2, '20050131', 2100.00);
INSERT INTO dbo.Sales(storeid, dt, revenue) VALUES(3, '20041205',  500.00);
GO