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