SQL Server Stored Procedure Pagination
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi, I would like to have an stored procedure that could paginate it's result, I have a SELECT query than can give from 10 rows as result to 5000 rows, what I would like is to do is "Give me from the rows 30, the next 50 rows", like a TOP, but a subset... SELECT START_ROW 300 PAGE_SIZE 30 * FROM MyTable WHERE... I have been searching on the net and the only thing that I have found are samples with Set Row count, but making several selects or even memory tables and nasty tricks like use ID or... Does T-SQL implement this ?