Append query to pull only new records to minimize load on server

[dgudkov]

Linking a similar topic, just in case:

Incremental extract ODBC

Hi, I would like to make incremental extracts via ODBC. I can’t find a standard feature of easymorph that supports this. Is it possible to find the latest date that is already extracted, store this in a parameter and use this in a select statement to collect the new rows from ODBC? In other words, how can I select the latest date from a table and write that to a parameter? Thanks in advance!