Thanks, Kevin. I didn't know about OUTPUT - I'll be using it! NP, hope it helps...
I wrote about this in CoDe magazine a few years ago: Listings 5 and 6 at the bottom of this link have a few examples:
http://www.code-magazine.com/article.aspx?quickid=0709031&page=3It's even part of the new MERGE statement in 2008 - when you do a MERGE (i.e. "UP-SERT"), you can output what was inserted and what was changed, either as a result set, or to a temp table or table variable.