...I would hope that the two executions of the CTE happening together in milliseconds would return the same 10 rows...
Personally I prefer to not rely on "hope" to get the correct results from my data processing efforts!! :w00t:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service