DECLARE @PageIndex INTDECLARE @PageCount INT SET @PageIndex = 3 SET @PageCount = 10 SELECT TOP(@PageCount) * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY ID) AS RowNumber,* FROM dbo.ExcelData WITH(NOLOCK) ) A WHERE RowNumber > @PageCount * (@PageIndex-1)