Thanks for all replies, it looks like the OUTPUT clause will be the way to go on this one.

Many thanks.