Pagination with SQL Server 2005

[jdom]

I am new to stored procedure. I would like to call this to my asp page but just don't have clue how to.
Reason i have to this because i have a largedata base.

Here is the query from my database:

SELECT AD_ID,make, model, year, imagea, ad_dated FROM ADS WHERE Make = "BMW" ORDER BY AD_ID DESC

Make is querystring

I did try but with no success. if anyone can help or guide me to a sample tutorial

i will appreciate it/

Thank you

DECLARE @rowsPerPage int,
    @pageNum int,
 @startRow int,
 @endRow int
 
SET @rowsPerPage = 10
SET @pageNum = 3
 
SET @startRow = ((@pageNum- 1) * @rowsPerPage)+1
SET @endRow = @startRow + @rowsPerPage -1
 
SELECT * FROM (
 SELECT row_number() OVER (ORDER BY id) as resultNum, id
 FROM regTrackingHistory
) as numberResults
WHERE resultNum  BETWEEN @startRow AND @endRow

[jhardman]

let me know if this helps.

Jared