Listing 2: Stored Procedure to Return Next Page of Orders
CREATE PROC dbo.usp_GetNextPage
  @last_orderdate AS datetime,
  @last_orderid   AS int
AS
SELECT TOP 10 OrderID, OrderDate, CustomerID, EmployeeID, ShipVia
FROM dbo.Orders
WHERE OrderDate > @last_orderdate
   OR (OrderDate = @last_orderdate
       AND OrderID > @last_orderid)
ORDER BY OrderDate, OrderID;