Hi i had faced the same problem as query was taking lots of time to give the results and ending up in deadlock. I have used "SET DEADLOCK_PRIORITY NORMAL;" before...