Wayne,

Thanks for the response. When I tried your first approach I get the following:

Msg 134, Level 15, State 1, Line 1

The variable name '@xDeleted' has already been declared. Variable names...