We are using MSSQL to manage different systems, we use the input from Great Plains and then we post some information to other systems.

I started having some problems and we post a big invoice, the order was not correct. If I print the invoice the order was the correct one but if I open the MSSQL table, the order was not correct. After several test I found that if I sort using DEX_ROW_ID, I'll get the order order. Is this correct?

What is the best way to sort the table in base of the time when the row was created?

Thanks,
Monica

Probably, but hard to tell without any further information.
ORDER BY CreationTimestampColumnName

Well, I tried to use CreationTimeStamp but I get an error. My table does not have a timestamp column.

My table has a column called RecordedTime and I have the date and time when the row was created; the problem is that the time is the same for a lot of rows.

The DEX_ROW_ID is just a consecutive number. Do you see any problem if I use this field to order my query?

Thanks,
Monica

If DEX_ROW_ID is an identity column, its values will be in the order of creation. In most cases it will be safe to use it in your ORDER BY clause.
As you already stated, in your case it will work.

A better design would keep an extra column like InvoiceLineNr (or some similar name), to store the sequence explicitly. Perhaps some column with that name is present?

I don't have another identity column. I'm going to use DEX_ROW_ID and reply to the post if I find any problems.

Thank you very much.
Monica