how to retuen parameter in SP with index and Pagesize 10

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

0

Hi,

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

0

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

0

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

return using stored procedure

0

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?

+1

i think its not possible.

0