select T1._IDRRef as _IDRRREf
into #tt111
from _Reference98 T1
where (T1._ParentIDRRef IN(0x9774001D724E485D11E1F2850769E1F4))
union select 
T2._IDRRef
from _Reference98 T2
where (T2._IDRRef IN(0x9774001D724E485D11E1F2850769E1F4))

select T1._IDRRef as _FLDRref 
into #ttt1
from _Reference98 T1
inner join #tt111 T2
on T1._ParentIDRRef = T2._IDRRREf
left outer join #tt111 T3
on T1._IDRRef = T3._IDRRREf

select T1._Code, T1._Description
from _Reference98 T1
Where T1._ParentIDRRef IN
(select T4._FLDRref 
from #ttt1 T4)