there are many fine articles out there on how to do it, and i don't think an impromptu reply on a forum is going to be of higher quality, so you should really pick one of those articles and give it a serious try

cpradio:

Then you need to limit the results to the specific page you want to display (hint, look up the LIMIT clause)

unfortunately, LIMIT is a proprietary sql feature that exists only in mysql

Ok I have made some in roads here as I did find a tutorial after but it was for php and MySQL, and I need it in MSSQL, but one person replied in a thread on that site and added some changes to accomodate MSSQL, but in honesty Im not sure where he means to put or make the change.