01-31-16, 10:53 #1Registered User
- Join Date
- Jan 2016
Unanswered: Code order gets mixed up after sorting to another table
Hey everyne! I've been struggling with this for quite some hours now.
I've got a query, that exports certain fields from a table to another table:
SELECT ALLQuotes.Ddate, ALLQuotes.Ttime, ALLQuotes.Price INTO 27012016_29012016
ORDER BY ALLQuotes.Code;
The problem is, for some rows it mixes up and codes do not come ordered, like they are in the initial table. Here's a screenshot:
And here how it looks in the original table:
Could this be perhaps caused by the large ammount of raws that i have? (around 4.2 million)?
And how can I export sorted data so that I don't counter this problem?
Last edited by panzer; 01-31-16 at 11:01.
01-31-16, 12:09 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
so you have a sort order, but cunningly you don't display the column you are sorting on in your query (and not int he fragment of data you include above.
check the codes for the rows, see if that explains why the order seems to changeI'd rather be riding on the Tiger 800 or the Norton