paging data returned from a stored procedure

• solus

  Hall of Fame

  Points: 3495

  More actions

  May 23, 2017 at 4:19 am

  #325923

  I have a complex stored procedure that can return anywhere from a few rows, to several thousand.  I want to page the data returned.  I have the pagenumber and page size to pass in, but what are 'best practices' for doing this ?  any tips/advice would be welcome

• Mark Cowne

  One Orange Chip

  Points: 26952

  More actions

  May 23, 2017 at 6:45 am

  #1943758

  SQL Server 2012 has built in support for this using the OFFSET ... FETCH NEXT syntax

  https://technet.microsoft.com/en-us/library/gg699618(v=sql.110).aspx

  ____________________________________________________

  Deja View - The strange feeling that somewhere, sometime you've optimised this query before

  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537