Good job Wayne....you beat me to it. I know a cte could do the trick, I was just working through the update logic.
Great solution!
John Rowan
======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden