how to retuen parameter in SP with index and Pagesize 10

Question

user can exec 510 that time disply record of 51 To 63 using Stored Procedure CREATE PROCEDURE dbo.spGetEmployees ( @StartRow INT = 1 @RowCount INT = 10 ) AS BEGIN // logic END exec dbo.spGetEmployees(5) out put will be 51 To 63 Record display

Midhun T P · Answer

Hi What is the logic behind selecting records from 51 to 63? As we are passing 5 records will be from 51. But what's the logic behind selecting upto 63?

Ananth G · Answer

i think its not possible.

Manas Mohapatra · Answer

Your logic looks fine. What is the error you are getting now?

Midhun T P · Answer

Hi Can you please specify the correct error you are getting while executing this procedure?

viral patel · Answer

CREATE PROCEDURE dbo.Pagination_Test_1 -- ORDER BY CustomerID @PageNumber INT = 1 @PageSize INT = 100 AS BEGIN SET NOCOUNT ON; SELECT CustomerID FirstName LastName EMail Active Created Updated FROM dbo.Customers_I ORDER BY CustomerID OFFSET @PageSize * (@PageNumber - 1) ROWS FETCH NEXT @PageSize ROWS ONLY OPTION (RECOMPILE); END GO Error : Offset and fetch next try to solved this error in sp

viral patel · Answer

i have to find using Pageindex and Pagesize thru display 10 record to select number return using stored procedure