I really appreciate all the creative solutions to this problem.  I'll do some testing for performance and see what happens.

Thanks!

I appreciate the responses, but still have a problem.  I'm processing about 30 million rows and the subquery solution has been running now for about an hour and I suspect...