With our DBA we tried to speed up the query using tmp table.

On our server the time change from 1 minutes to 6 seconds.

Here below the query:

DECLARE

Hi Marcelo,

thank you for sharing this script, for a long time I was looking for it!

Until now I had not found how to get the data in a deadlock after...