Sergiy (5/7/2013)
You are missing column RowNo in your table Heap.Files keep the data in physical order as they've been added to the file (because that's a definition of "file").
tables in relational databases do not have such a "natural" order of records.
You need to specify it and upload it from the file together with data.
Thank you for this point. There is a row number in the file which I can import. It's a sequential incremental number for each record in the file, new partitions doesn't start with 1.
I'm still unable to write a query for this.