If you are using sql server 2005 you can achieve this by using the row number function and then using the row number to return a subset of the data based on its row number.

Here's a couple of artcles which give examples of how to do this

http://www.davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx

http://www.sqlteam.com/item.asp?ItemID=26455

http://aspnet.4guysfromrolla.com/articles/031506-1.aspx

hth

David