Khalid Hanif-458693 (7/16/2013)
I need data ordered by how sql orders it.
SQL doesn't order it, that's what people are trying to tell you.
There is no default ordering. There is no concept of order of inserts. There is no implied order of rows in a table.
If you want any concept of 'previous', 'next', or 'order', you need to define that order based on a column in the table.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability