Hi SQLSponge,

I recently read an article that proposed one of the best solutions I've ever seen. It is a little bit complex (technically speaking) but I suggest you to read it and take your time to understanding it:

Incremental Data Loading Using CDC[/url]

I also suggest you to read the two previous articles of these series, you can find the links in the article above.

If this solution does not persuade you, please send me the design of the tables, specially the granularity and the type of the aggregations (AVG, COUNT, SUM, etc.)

Kinde Regards,