Hmm, these ideas all sound good, but they are not working.

When I create my tmp table, I have an identity column (SeqNo), could that be getting in the way?

I retrieve the data in asp that has some pagination code.  I suspected a bug in the pagination code at first, but it looks good. 

And, when I create real tables,...

Thank you for the suggestion.

I am using SQL Server 2000 sp3.

The MAXDOP option gives a little boost so rows are in order a bit farther down the line, but it...

Just to be clear, I AM using an order by clause, I am ordering the RS by LastName.  The results are in Proc1's temp table in the correct order.

When...