• I don't think there is a way to force the inserts to happen in a certain order. If you have to have the data returned in a specific order you should specify that in your ORDER BY. So in the case you present your select should be:

    select top 8

    *

    from

    tableOrder (nolock)

    order by

    OrderDate DESC,

    OrdererID