Hello,
I have a qvd that includes about two years worth of data, and gets replaced from a SQL script each day. Obviously, this is not practical, so we need to start doing incremental loads. The rows can get updated, but it would never happen more than a week from when the record was created. There is a unique TXPORT_ID and LastUpdate field added that can be used for this purpose. I've looked at some examples online, but none seem to quite work.
I'd like to run the SQL stored procedure each day, looking back for a week's worth of activity just to be safe. Then I'd like to add the new records that aren't currently in the existing 2+ years qvd, and replace any that may have been updated.
What is the best way to do this?
