Customer table most recent

[Dmilesikhailov]

How do I load the last few hundred rows from a QVD with over one million rows?

Customer:

Load *

;

SQL Select *

From tblCustomer

[jonathandienst]

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.