differential-execution

How Does Differential Execution Work?

I've seen a few mentions of this on SO, but staring at Wikipedia and at an MFC dynamic dialog demo did nothing to enlighten me. Can someone please explain this? Learning a fundamentally different concept sounds nice. Edit: I think I'm getting a better feel for it. I guess I just didn't look at the source code carefully enough the firs...

reflecting record deletions / additions between two datasets

Hi, I currently have a table of 3m records that needs updating nightly. The data that populates this table comes from ~100 APIs that all get normalised into one jumbo table. Problem: How to reflect new records being added, and records being deleted at the source? Facts: I can't truncate the table every night and reinsert. Each API pro...