CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS blocked_text LEFT JOIN sys.dm_exec_connections c ON r.blocking_session_id = c.session_id LEFT JOIN sys.dm_exec_sessions s_block ON ...