• 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass