Paging in SQL Server 2005 using OVER

Full detail of "OVER" can be found on following link:

http://msdn.microsoft.com/en-us/library/ms189461.aspx

Following is the code snippet to show how quick and simply pagination can be done using OVER:

USE northwind
DECLARE  @startIndex INT,
         @pageLength INT
SET @startIndex = 6
SET @pageLength = 5

SELECT *
FROM   (SELECT o.shipname,
               o.shipaddress,
               Row_number()
                 OVER(ORDER BY o.customerid DESC) AS rownumber
        FROM   orders AS o
               JOIN [order details] AS od
                 ON od.orderid = o.orderid
        WHERE  o.customerid = 'VINET') AS shipmentdetail
WHERE  rownumber BETWEEN @startIndex AND (@startIndex + @pageLength - 1)