Fix what? A deadlock can occur for any number of reasons. If we can't see what you're doing, we can't see what you're doing wrong. Please post the code but ONLY the relevant code, along with an explanation of exactly what you're trying to achieve.
Update C set last_date = Getdate(),
data = 'Not implemented'
from dbo.employee_data As C
innerjoin #covered As D on C.item_id = D.item_id
Option (Maxdop 1)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.