ASP.NET.4GuysFromRolla.com: Custom Paging in ASP.NET 2.0 with SQL Server 2005:

SELECT RowNum, EmployeeID, LastName, FirstName
FROM
   (SELECT EmployeeID, LastName, FirstName 
       ROW_NUMBER() OVER(ORDER BY EmployeeID) as RowNum
    FROM Employees e
   ) as EmployeeInfo