declare @handle int;
select @handle = parent
from dbo.vnet_tag_i
where name like '861-040-FC-1043'; --찾으려는 태그 id

select t1.*, '||'as 'wall', t2.name , t3.name, t0.source_role
from
(
select noderef, type, source, source_type, target, target_type, part_of_session
from dbo.vnet_association_i with(nolock)
where source = @handle
union all
select noderef, type, source, source_type, target, target_type, part_of_session
from dbo.vnet_association_i with(nolock)
where target = @handle
)t1
join dbo.vnet_tag_i t2 with(nolock) on t1.source = t2.parent
join dbo.vnet_tag_i t3 with(nolock) on t1.target = t3.parent
join [dbo].[vnet_association_type_i] t0 on t1.type = t0.noderef
where t0.[name] ='IRE'