Listing 1: Code That Creates and Populates a Very Large Copy of the Orders Table
USE Northwind
GO
DROP TABLE NewOrders
GO
SELECT IDENTITY(int) AS Number, convert(varchar(6), OrderID) AS OrderID, 
  CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, 
  ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry
INTO NewOrders
FROM Orders
GO
INSERT INTO NewOrders (OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, 
  ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, 
  ShipPostalCode, ShipCountry)
SELECT convert(char(5),OrderID)+'1', CustomerID, EmployeeID, OrderDate, RequiredDate, 
  ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, 
  ShipPostalCode, ShipCountry
FROM Orders
GO
INSERT INTO NewOrders (OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, 
  ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, 
  ShipPostalCode, ShipCountry)
SELECT convert(char(5),OrderID)+'2', CustomerID, EmployeeID, OrderDate, RequiredDate, 
  ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, 
  ShipPostalCode, ShipCountry
FROM Orders
GO
INSERT INTO NewOrders (OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, 
  ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, 
  ShipPostalCode, ShipCountry)
SELECT convert(char(5),OrderID)+'3', CustomerID, EmployeeID, OrderDate, RequiredDate, 
  ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, 
  ShipPostalCode, ShipCountry
FROM Orders
GO
INSERT INTO NewOrders (OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, 
  ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, 
  ShipPostalCode, ShipCountry)
SELECT convert(char(5),OrderID)+'4', CustomerID, EmployeeID, OrderDate, RequiredDate, 
  ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, 
  ShipPostalCode, ShipCountry
FROM Orders
GO
SELECT count(*) FROM NewOrders
GO
CREATE UNIQUE INDEX Number_index ON NewOrders(Number)
CREATE UNIQUE INDEX ID_index ON NewOrders(OrderID)
GO