Dave62 (10/21/2011)
SanDroid (10/21/2011)
......It should work wether there are more or less records. You can even use a variable to limit the number of records returned or return them all.
......
I should have been more specific in my question.
Does using a "TOP 99999999" statement with an "order by" in a VIEW against an actual table with less than 99.9 Million rows keep the query optimizer from ignoring the Order by statement since nothing will be filtered?
I know in a basic select with a variable it will not, but Views are different. 😎