Results 1 to 2 of 2
  1. #1
    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
    FROM ALLQuotes
    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:
    Click image for larger version. 

Name:	c30b6c2eb898.jpg 
Views:	5 
Size:	70.4 KB 
ID:	16750

    And here how it looks in the original table:

    Click image for larger version. 

Name:	a281f98cf075.jpg 
Views:	3 
Size:	65.2 KB 
ID:	16751

    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 12:01.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    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 change
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts