Will give it a try and let you know. Thank You.

yeah. Good point. What about the performance issues. Have you heard of anything like that happening when running the script for a significant amount of time?

I tried to be vague to see if anyone had other ideas. I would LOVE for the million rows to be the whole table, but there is always a...

It doesn't all need to be done in a maintenance window. I have actually tried to "trickle" it. With this way I have to make sure there are...

All great ideas. But, ideas i've tried. The problem is that these are not the only records in the table. I have over 3 million recs in...