Appreciate you suggestion. Hope to get to the point where can be helping other people too.

Cheers all 😎

I was using sql server 2000, but it doesn't hurt to learn the futures of 2005 and above 🙂

thank you all,

you could be more helpful

appreciate it,

That works pretty well, how about this case:

delete t2 from #temp d

inner join table1 t1 with(nolock)

on d.id= t1.id and d.id2 = t1.id2

inner join table2 t2 with(nolock)

on t1.user = t2.user

thank you all, for your answers. Been able to identify the index sounds like a good enough reason for me to use the constraint. If there are any other...