I should have elaborated, sorry. These databases and tables are cleared out most nights, and recreated from table dumps from our ERP system and are used lightly throughout the day...

Thanks for all the quick replies! We've edited the code and will hopefully get better results. You guys are pretty good to catch that needle in a haystack. 🙂

It's very possible that there is an issue within the WHILE loop, but I got the error even while running just the top part of the script.

The datatype on...