• You could add a "sort" column to your temporary table - like an Identity column that simply generates a sequential number, incremented for each row inserted into the table.

    You can then use ORDER BY when querying from the temp table, which should give you the result you are after.

    Chris