I have also found cursors good here (i.e. date range by weeks, period/month/ year). Use a print statement in the cursor to show progress (which gives me warm fuzzies...

Thanks,

I orginally had two schemas, one similar to this, another with a denormalized table that had id and order columns for both chapters and sections. Triggered to update based...