Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I load the last few hundred rows from a QVD with over one million rows?
Customer:
Load *
;
SQL Select *
From tblCustomer
Something like this pattern:
Let vRowsToLoad = 200;
Let vLimit = Alt(QvdNoOfRecords('SourceQVD.qvd'), 0);
Let vStart = vLimit - vRowsToLoad - 1;
Data:
LOAD *
FROM [SourceQVD.qvd] (qvd)
Where RowNo() >= $(vStart);
Although this will scan the entire file, it should be reasonably quick -- a million rows is not a particularly large QVD.
Edit - fixed missing closing parenthesis.