-
I've a problem, who can help me? I've a SQLServer table sorted by a type code field that show the following records A A2 A3 B B2 C Why the same table called like a temporary table, containing the same record and ordered with the same key, show records ordered like the following? A B C A2 A3 B2...
-
Hello. Temporary tables are sorted based on Navision native sorting. I suggest to use a new field with a key and as you are inserting into the temp table, increment this new field. Then set the key on this new field.
-
Check http://dynamicsuser.net/forums/p/21522/103596.aspx You could also use another PK values.