Listing 3: Code That Creates the usp_GetPrevPage Procedure
CREATE PROC dbo.usp_GetPrevPage
  @first_orderdate AS datetime,
  @first_orderid   AS int
AS
SELECT *
FROM (SELECT TOP 10 OrderID, OrderDate,
        CustomerID, EmployeeID, ShipVia
      FROM dbo.Orders
      WHERE OrderDate < @first_orderdate
         OR (OrderDate = @first_orderdate
             AND OrderID < @first_orderid)
      ORDER BY OrderDate DESC, OrderID DESC) AS D
ORDER BY OrderDate, OrderID;