Thanks to Ben Reichelt over at CodeBetter.com blogs for pointing out the new Row_Number() function in SQL Server 2005. We finally have an easy way to page data in SQL Server.
In Sql Server 2005, there is a Row_Number() function. You can specify this
Read More