This discussion is archived
5 Replies Latest reply: Dec 5, 2012 10:24 PM by 936666 RSS

Display records in page with set of records

936666 Newbie
Currently Being Moderated
How to display the set of records in a page

say for eg i am having a table TableA which is having some say 1000 records i need to write the stored procedure to fetch only 50 records(1 50) later on the page if user click page 2 it needs to fetch data from 51-100 and so on.... what are the inputs need for this stored procedure to do so.
Existing parameters for this stored procedure is empid number, managerid number

Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points