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…