Dan, regarding your question of how to get the total rows affected without using temp tables, the following seems to work for me. I have no idea how efficient...