• That was the picture of the actual execution plan, but I'm attaching now one from the new actual and estimate execution plan (as I created the recommended index from the mcpItems table)

    Attached is the .sql file with the script of the tables, indexes and the SP where the deadlock occurs.

    Thanks