with xmlnamespaces (default 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')
select C.X.value('../../@LogicalOp[1]', 'varchar(20)'),
C.X.value('@Column', 'sysname')
from T
cross apply T.X.nodes('//RelOp/OutputList/ColumnReference') as C(X);
with xmlnamespaces (default 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')
select R.X.value('@LogicalOp', 'varchar(20)'),
C.X.value('@Column', 'sysname')
from T
cross apply T.X.nodes('//RelOp') as R(X)
cross apply R.X.nodes('OutputList/ColumnReference') as C(X);