SQL SERVER2005 利用ROW_NUMBER()函数分页存储过程

CREATE PROCEDURE dbo.subjectPager
 (
 @projectid int,
 @pageSize  int,
 @pageTo    int

 )
SELECT * FROM (SELECT TOP (@pageSize*(@pageTo+1)) ROW_NUMBER() OVER(ORDER BY feedbackdate DESC) AS row,*  FROM vw_subject  WHERE  projectid=@projectid ) AS T  WHERE T.row BETWEEN (@pageTo-1)*@pageSize+1  AND @pageSize*@pageTo