Hi,

That's actually the way it's currently setup. We take the minimum date and compare it to @MaxDate and do a WHILE loop that contains a WHILE for the list of tables to archive. When all tables have been processed for a given day, we increment @currenDate by 1 until @currentDate = @MaxDate.

I'm opened to changing the way this works completely if there's something better out there though. I'm not sure I know one right now though, that's why I was asking. Since it also needs to work on 2000 or 2005, it further restricts my choices to using a 2000 compatible method.

Greg