Web Listing 1: Create and Populate SalesOrderHeader Table in tempdb

USE tempdb;
GO
CREATE SCHEMA Sales;
GO
SELECT TOP(1000000)
  IDENTITY(int, 1, 1) AS SalesOrderID,
  -- 5000 CustomerIDs
  1 + ABS(CHECKSUM(NEWID())) % 5000 AS CustomerID,
  -- OrderDate spans 4 years
  DATEADD(day, ABS(CHECKSUM(NEWID())) % (365*4), '20010101') AS OrderDate,
  -- TotalDue in range 1 through 1000
  CAST(1 + ABS(CHECKSUM(NEWID())) % 1000 AS MONEY) AS TotalDue
INTO Sales.SalesOrderHeader
FROM AdventureWorks.Sales.SalesOrderHeader AS S1,
  AdventureWorks.Sales.SalesOrderHeader AS S2;

ALTER TABLE Sales.SalesOrderHeader
  ADD CONSTRAINT PK_SalesOrderHeader_SalesOrderID
      PRIMARY KEY(SalesOrderID);

CREATE UNIQUE INDEX idx_cid_od_oid_i_td
  ON Sales.SalesOrderHeader(CustomerID, OrderDate, SalesOrderID)
  INCLUDE(TotalDue);
GO




1