Create PROCEDURE dbo.GetPaggingOnProc ( @startRowIndex int, @maximumRows int ) AS select RowRank,Column1,Column2,Column3 FROM ( select Column1,Column2,Column3 , ROW_NUMBER() OVER (ORDER BY SADShiftCtrl) AS RowRank from tblTestABC ) AS tblTestABCWithRowNumbers WHERE RowRank > @startRowIndex AND RowRank <= (@startRowIndex + @maximumRows)