Gus,

You busted my chops on this one. I currently only have 1 client on 2008 so I don't actually user the MERGE statement much.

The idea of dumping the output into a table variable that won't be affected by a ROLLBACK is very good. I'm going to use it next time.

Todd Fifield