Thanks a million............it was great help 🙂

ok i am really lost.....am i on the right track or is there something that needs to done on my trigger to avoid concurrency......

Are you sure about that.....

This means I do not need to put any inner join while retrieving from inserted and deleted

for example (The way i had put in my trigger)

from...

Thanks a lot for guys for your help...but its still kinda not solved

yes i know it will in the deleted table...but is'nt deleted table a global table... wont it give...