I run a similar proc in production. The deadlock may not be caused by your routine, but rather by another proc updating the table you are reading from. ...