I think you are talking about pagination here. this can be done at application and sql server both.
search google for "row_number()"
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)