Question: If I select [Date].[Calendar].[Day].&[2014-01-01] is it possible to navigate in MDX to the same date but in Fiscal hierarchy - [Date].[Fiscal].[Day].&[2014-01-01]?
The idea is to have option to return fiscal calculated field which would work with both fiscal and calendar dates.

Answer: 
Try this:
`[SQLFIDDLE](http://sqlfiddle.com/#!6/2bb42/15)`

```
with  pairs as (select 
    case when c1< c2 then c1 else c2 end as minc,
    case when c1< c2 then c2 else c1 end as maxc
  from t
  group by
    case when c1< c2 then c1 else c2 end ,
    case when c1< c2 then c2 else c1 end 
  having count(*) >1) 
select * 
from t
where not exists
(select * from pairs
 where c1= minc and c2= maxc
)

```

Explain
-------

* The CTE table returns all paired rows of one side.
* Through `NOT EXISTS`, it returns all rows not paired

	+ If you change the condition of `where c1= minc and c2= maxc` to `where c2= minc and c1= maxc` will get the opposite side of the pairs.
	+ If you want delete one side of those pairs, with `DELETE FROM T WHERE EXISTS` instead of `NOT EXISTS`

There have some different ways to get paired rows.
```
SELECT A.* FROM test A LEFT JOIN test B
ON A.column1 = B.column2 AND A.column2 = B.column
WHERE B.column IS NULL;

```

This should work, assuming your OK with something like (2,2) also being excluded.