Thanks, but isn't that the point of using ROW_NUMBER() OVER (ORDER by m.Price ASC) in the first place -- to get the Rows in the proper order at the time...

I'm using Row_Number() because I am dealing with a large number of records and only want to return the specific records in question

Thanks for your reply

Unfortunately, I'm not quite following

I thought that the ROW_NUMBER() OVER (ORDER BY ...) statement was meant to take the place of an order by for the actual...