Use a CTE along with ROW_NUMBER() to Paginate Records in SQL 2005

You may be familiar with ROW_NUMBER(), but did you know you'll also need to combine that with a Common Table Expression (CTE) to paginate through your records?