mssql 2005, paging query, incorrect syntax near "WHERE", "WITH"

[itamar82]

I am getting the following error:

Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near the keyword 'WHERE'.

for the sql below:

SELECT TourId
FROM
(SELECT ROW_NUMBER() OVER (ORDER BY BaseTours.DateCreated DESC) AS RowNumber
FROM Tours INNER JOIN BaseTours ON Tours.BaseTourId = BaseTours.BaseTourId WHERE Tours.Archived = 0)
WHERE RowNumber BETWEEN 0 AND 10 ORDER BY RowNumber ASC;

I also attempted to the do the following:
WITH PagedTours AS
(
SELECT TourId, ROW_NUMBER() OVER (ORDER BY BaseTours.DateCreated DESC0 AS RowNumber
FROM Tours INNER JOIN BaseTours ON Tours.BaseTourId = BaseTours.BaseTourId
WHERE Tours.Archived = 0
)
SELECT TourId
FROM PagedTours
WHERE RowNumber BETWEEN 0 AND 10 ORDER BY RowNumber ASC;

The above two queries are failing from my asp webpage, but when I run the commands in MS SQL Management Studio they both work.

Thanks for helping.

[jhardman]

Your SQL statement is awefully complicated, I couldn't even follow what it was doing. Are you sure you can't simplify it?

Jared