Sql Paging for MSSQL

Reference from http://www.codeproject.com/Articles/18148/SQL-Server-2005-Paging-Results

With Cust AS ( SELECT CustomerID, CompanyName,
    ROW_NUMBER() OVER (order by CompanyName) as RowNumber
    FROM Customers )
select *
from Cust
Where RowNumber Between 20 and 30