Help!!! how to show 10 by 10 records from query in sql 2000 (likepaging)?

Answer 1

1)create a temp table- with ten rows of data
2) insert data into temporary table- insert into ....
3) display / select .....
4) repeat by using "for" or "while" command