That's exactly the process I employ: processing changes within a range.  I modeled my implementation upon many of your suggestions in that article.

Hi Tim,

Thanks for the reply.
This solution is meant to be a near-real-time update to our reporting database from our transaction database.  Our current process runs overnight, so...

Hello Tim,

Can you tell me why you use a start and an end version ID? Since the version ID is database-wide, it seems like we can get the delta...

Thank you, Tim. I'm reading your posts, and they are very helpful. I am building a proof of concept now.