|
|
|
SSChasing Mays
      
Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:20 AM
Points: 649,
Visits: 263
|
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Yesterday @ 9:52 AM
Points: 2,796,
Visits: 1,125
|
|
Well I got it wrong because I was not familiar with the except operator. But is MDX considered T-SQL?
|
|
|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: Yesterday @ 1:51 AM
Points: 1,972,
Visits: 1,821
|
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Monday, April 01, 2013 11:51 PM
Points: 292,
Visits: 794
|
|
When MDX is considered part of mainstream t-sql language construct then fine. Otherwise it should have being labelled MDX as the topic.
------ Robert
|
|
|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Thursday, March 14, 2013 4:15 AM
Points: 3,240,
Visits: 4,960
|
|
'-' sign used for the purpose of 'Except' in Database Engine Query window gives error...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------- Sometimes, winning is not an issue but trying. You can check my BLOG here
|
|
|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Tuesday, January 08, 2013 7:08 AM
Points: 469,
Visits: 124
|
|
| So I'm not the only one that thinks that MDX is not T-SQL. An instructor on a course I attended said, "think of MDX as T-SQL for cubes" (i.e. although it serves the same function, it is not the same thing)...
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Thursday, February 14, 2013 7:48 AM
Points: 2,321,
Visits: 135
|
|
| MDX <> TSQL. Except is not a correct answer.
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Monday, November 26, 2012 3:25 AM
Points: 1,389,
Visits: 596
|
|
I think, "-" Except supports SQL 2005 and above versions.
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Today @ 2:14 AM
Points: 1,294,
Visits: 3,871
|
|
I agree - BAH! MDX is not T-SQL. I am going to tell my mummy!
MM
|
|
|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: Wednesday, February 24, 2010 4:10 AM
Points: 1,553,
Visits: 2,232
|
|
|
|
|