Nick,

What argument? 🙂

Tim (and Nick)

The data is stored in the order that it is loaded. I do not think that your issue is actually how it is stored.

When you issue a select * from tablename on a table without a PK or clustered index, the data should be returned in the order that it appears in the table using the collation order. If there is a clustered index on the table it will return the data in the order of the PK. Lastly in the order of the order by clause when you use it.

Now, the next issue will be to match the parent records to the child records. How are you planning to do that?