Viewing 7 posts - 1 through 7 (of 7 total)
I will keep it in mind and will update you if I ever find the reason....:-)
February 6, 2012 at 1:05 pm
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...
February 3, 2012 at 9:35 am
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...
February 3, 2012 at 8:58 am
have you tried cross join...simply
select * from tableA,tableB
February 3, 2012 at 8:49 am
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...
February 3, 2012 at 8:45 am
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...
February 3, 2012 at 8:33 am
Try creating CLR stored procedure in .Net and then execute it through SSMS......
February 3, 2012 at 8:20 am