Thanks Rob. I guess I misunderstood the proper usage of LOAD and thought it was just to fetch records from the QVD into memory for use within the current QVW session.
I am working towards staging records in a separate loading QVW from SQL into the QVD files and then having a more heavily utilized QVW that doesn't fetch from SQL but only from those staged QVD files. I guess by having both the SQL with STORE and the LOAD I was doubling up records
Could you help me with loading?
I load data from SQL ( last month)
SELECT * FROM dbo_***;
then I add historical data which had stored before
LOAD Distinct * FROM $(vQVD)\NEWFILE.qvd (QVD)
Sometimes my historical data has the same month. For example I load February data, then concatenate historical data with February. I get double count for February.( instead of 10 , I get 20). Do you know how to avoid duplicate records?