• I do agree with Mr Guru there about the ORDER BY thing, but as a matter of curiosity, I think the following also guarantees a repeatable order:

    WITH TS AS (SELECT * FROM dbo.Test TABLESAMPLE (100 PERCENT) REPEATABLE (91256))

    SELECT TOP (10) * FROM TS;

    Well, so long as no changes are made to the table anyway...:-)