declare @nuke_spid int select @nuke_spid = session_id
from sys.dm_exec_requests r outer apply sys.fn_get_sql(r.sql_handle) s
where s.text like '%sanad_insert r%'
بعد از مقدار کردن متغیر nuke_spid@ با دستور kill اقدام به توقف نمائید.
مثلا اگر مقدار متغیر فوق 65 شد با دستور
kill 65
DECLARE @childID INT
SET @childID = 1 --chield to search
;WITH RCTE AS
(
SELECT *, 1 AS Lvl FROM RelationHierarchy
WHERE ChildID = @childID
UNION ALL
SELECT rh.*, Lvl+1 AS Lvl FROM dbo.RelationHierarchy rh
INNER JOIN RCTE rc ON rh.CHildId = rc.ParentId
)
SELECT TOP 1 id, Name
FROM RCTE r
inner JOIN dbo.Person p ON p.id = r.ParentId
ORDER BY lvl DESC