Listing 1: Script That Creates and Populates the Orders Table
SET NOCOUNT ON;
USE tempdb;
GO
IF OBJECT_ID('dbo.usp_GetOrders') IS NOT NULL
  DROP PROC dbo.usp_GetOrders;
IF OBJECT_ID('dbo.Orders') IS NOT NULL
  DROP TABLE dbo.Orders;
GO

SELECT OrderID, CustomerID, EmployeeID, OrderDate,
  CAST('A' AS CHAR(2000)) AS filler
INTO dbo.Orders
FROM Northwind.dbo.Orders;

CREATE CLUSTERED INDEX idx_cl_OrderDate ON dbo.Orders(OrderDate);
CREATE UNIQUE INDEX idx_unc_OrderID ON dbo.Orders(OrderID);
CREATE INDEX idx_nc_CustomerID ON dbo.Orders(CustomerID);
CREATE INDEX idx_nc_EmployeeID ON dbo.Orders(EmployeeID);
GO