USE SQL2008SBS
GO

CREATE VIEW Archive.v_OrderItems
WITH SCHEMABINDING
AS
SELECT a.OrderID, a.CustomerID, a.OrderDate, a.SubTotal, a.TaxAmount, a.ShippingAmount, 
a.GrandTotal, a.FinalShipDate, b.OrderDetailID, b.SKU, b.Quantity, b.UnitPrice, b.Quantity + b.UnitPrice LineItemTotal
FROM Archive.OrderHeader a INNER JOIN Archive.OrderDetail b ON a.OrderID = b.OrderID
GO
CREATE UNIQUE CLUSTERED INDEX iucx_orderitems ON Archive.v_OrderItems (OrderID, OrderDetailID)
GO