I will keep it in mind and will update you if I ever find the reason....:-)

I know but a) cross join does not require any common key between the two table b) it will increase the number of column in the output which I though...

Its simple:-

Select * from student where stdnt_id not in (select stdnt_id from student where stdnt_activity=15)

this will take sometime however your can easily optimize it but that I will leave to...

have you tried cross join...simply

select * from tableA,tableB

I would like to make two suggestions here:-

1. Use cross apply to join with the function rether then inner join.

2. Make sure no duplicate value is there. Normally incosistency occurs...

I am not very sure about it but the first MDX query is trying do something like cross join whereas the second one is doing union that is why the...

Try creating CLR stored procedure in .Net and then execute it through SSMS......