Thread: MSSQL/Great Plains using DEX_ROW_ID to sort
View Single Post
  #2 (permalink)  
Old 04-20-09, 05:34
Wim Wim is online now
Registered User
  
Join Date: Nov 2004
Posts: 1,159
Quote:
After several test I found that if I sort using DEX_ROW_ID, I'll get the order order. Is this correct?
Probably, but hard to tell without any further information.
Quote:
What is the best way to sort the table in base of the time when the row was created?
ORDER BY CreationTimestampColumnName
__________________
With kind regards . . . . . SQL Server 2000/2005/2008/2008 R2 Earned beers: 13
Wim
Beware of bugs in the above code; I have only proved it correct, not tried it. -- Donald Knuth
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages
Reply With Quote