Listing 1: Stored Procedure to Return First Page of Orders
CREATE PROC dbo.usp_GetFirstPage
AS
SELECT TOP 10 OrderID, OrderDate, CustomerID, EmployeeID, ShipVia
FROM dbo.Orders
ORDER BY OrderDate, OrderID;