CREATE DATABASE [MyDB] ON PRIMARY ( NAME = N'MyDB', FILENAME = N'C:\MyDB.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB ) LOG ON ( NAME = N'MyDB_log', FILENAME = N'C:\MyDB_log.ldf' , SIZE = 1024KB , FILEGROWTH = 10%) GO USE MyDB GO CREATE TABLE dbo.Dates (DayDate DATETIME, Month_Num SMALLINT, Month_Name VARCHAR(50), Year_Num SMALLINT, PRIMARY KEY (DayDate)) GO INSERT INTO dbo.Dates (DayDate, Month_Num, Month_Name, Year_Num) VALUES ('20130101', 1, '', 2013), ('20130201', 2, '', 2013), ('20130301', 3, '', 2013), ('20130401', 4, '', 2013), ('20130501', 5, '', 2013), ('20130601', 6, '', 2013), ('20130701', 7, '', 2013), ('20130801', 8, '', 2013), ('20130901', 9, '', 2013), ('20131001', 10, '', 2013), ('20131101', 11, '', 2013), ('20131201', 12, '', 2013) GO CREATE TABLE dbo.Regions (Region_Id INT, Region_Name VARCHAR(250), PRIMARY KEY (Region_Id)) GO INSERT INTO dbo.Regions (Region_Id, Region_Name) VALUES (1, ''), (2, ''), (3, ''), (4, ''), (5, '') GO CREATE TABLE dbo.SKU (SKU_Id INT, SKU_Name VARCHAR(250), PRIMARY KEY (SKU_Id)) GO INSERT INTO dbo.SKU (SKU_Id, SKU_Name) VALUES (1, ''), (2, ''), (3, ''), (4, ''), (5, ''), (6, ''), (7, ''), (8, ''), (9, ''), (10, '') GO CREATE TABLE dbo.Plan_Sale (DayDate DATETIME, Region_Id INT, SKU_Id INT, Sum_Sale MONEY, PRIMARY KEY (DayDate, Region_Id, SKU_Id)) GO