SQL Server v.Next (Denali) : Using the OFFSET clause (paging)
A very common request over the past, oh, 10 years, maybe more, has been better support for paging within T-SQL (this Connect request dates back to 2005). Well, you will see some broader support...