STORE will always write away whatever is in the table in memory at that time. To load from many QVDs and store into one simply load from each QVD in turn and then store the resulting table.
Thanks for the replies guys.. You've been very helpful.. Basically I loaded from the QVD first time with the where clause for 2013 only.. Then did a concatenate load 3 more times for each other year and stored the results at the end..
