Listing 1: Query That Returns Orders by Customer and Date

SELECT
  CustomerID AS CustID,
  CONVERT(CHAR(8), OrderDate, 112)
    AS OrderDate,
  SalesOrderID AS OrderID,
  TotalDue
FROM Sales.SalesOrderHeader
ORDER BY CustID, OrderDate, OrderID;