Apply paging in procedure
@intPageId int, @intPageSize int select * from ( Select row_number() over (order by TableA.intID asc ) r , TableA.intID,tableA.hName,TableB.Address from TableA Join TableB on TableA.intid = TableB.intId ) A where A.r between ( (@intpageid-1)*@intpagesize)+1 and ((@intpageid-1)*@intpagesize)+@intpagesize The query in bold text is for paging, and the normal text query is that which returns your records. OR SELECT * from PressRelease order by CreatedDate desc OFFSET (@PageID-1)*@PageSize ROWS FETCH NEXT @PageSize ROWS ONLY