Paging with new ROW_NUMBER() function of MS SQL Server 2005

Ok, after tackling temp tables, nested select statements and what not for paging, finally there is something really nice in Sql Server for paging.

Thanks to new ROW_NUMBER() function paging is piece of cake. Here is a MSDN link with a nice example.