The server was upgraded.

The tables do exist but the owner is not dbo. I think I need to change the proc to pull the user from Sysusers ?? Not sure....

Sorry, should have included the error

-------------------------------------------------------------------

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'dbo.order_detail'.

Because of the nature of the application, there will never be a batch of deleted Contsupp rows that have a link in Contact1 AND Contact1del. It is not possible to...

Yeah it worked. Definitely funky though

EXISTS is the way to go

Thanks for the reply

Thanks for the assistance, Sergiy