CREATE PROCEDURE dbo.p_NodesSelect @parent_id int 
AS 

BEGIN 
    select ID_Rahunok into #t from Rahunok where ParentRahunok = @parent_id 
    if @@rowcount= 0  
    begin
        select * from Rahunok where ID_Rahunok in (select #t.ID_Rahunok from #t)
        return 
    end

    while ( 1 = 1 ) 
    begin
        insert #t 
        select t1.ID_Rahunok
        from Rahunok t1 
            inner join #t t2 on t1.ParentRahunok=t2.ID_Rahunok 
        where t1.ID_Rahunok not in (select #t.ID_Rahunok from #t)
         
        if @@rowcount= 0  
        begin
            select * from Rahunok where ID_Rahunok in (select #t.ID_Rahunok from #t)
            return 
        end
    end
END