deadlock issue

sql on paskaa