Am I right in thinking QV can't use an 'order by' clause when loading from a qvd file?
I am sucking chunks of data from a large table by year so I end up with 2007.qvd 2008.qvd 2009.qvd. This is also good for incremental cos I can just grab 2009 when i want to refresh the data.
But, I need to suck all the qvd's into QV by customerid sort order because the load script is adding some fields which expect the customerid's to hit the load script in that order.
Sounds as though my only option is to load qvd's in default order then reload as resident and re-order then.
