I was having the same problem many months ago - I was trying to insert an identity column in the first temp. table and it still wouldn't maintain the order. ...