Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

T-SQL Operators Expand / Collapse
Author
Message
Posted Monday, April 13, 2009 8:25 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 6:34 AM
Points: 654, Visits: 265
Comments posted to this topic are about the item T-SQL Operators
Post #696278
Posted Monday, April 13, 2009 8:30 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 17, 2014 1:28 PM
Points: 3,189, Visits: 1,271
Well I got it wrong because I was not familiar with the except operator. But is MDX considered T-SQL?


Post #696279
Posted Tuesday, April 14, 2009 1:10 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 2,600, Visits: 2,448
Bah?
Post #696335
Posted Tuesday, April 14, 2009 2:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 5:58 PM
Points: 293, Visits: 815
When MDX is considered part of mainstream t-sql language construct then fine. Otherwise it should have being labelled MDX as the topic.

------
Robert



Post #696363
Posted Tuesday, April 14, 2009 2:57 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 24, 2014 8:40 AM
Points: 3,244, Visits: 5,008
'-' 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

Post #696370
Posted Tuesday, April 14, 2009 2:59 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, January 8, 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)...
Post #696371
Posted Tuesday, April 14, 2009 5:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, February 14, 2013 7:48 AM
Points: 2,647, Visits: 135
MDX <> TSQL. Except is not a correct answer.
Post #696436
Posted Tuesday, April 14, 2009 5:42 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 14, 2014 8:57 AM
Points: 1,391, Visits: 609
I think, "-" Except supports SQL 2005 and above versions.



Post #696442
Posted Tuesday, April 14, 2009 6:02 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:10 AM
Points: 1,805, Visits: 5,872
I agree - BAH! MDX is not T-SQL. I am going to tell my mummy!

MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #696451
    Posted Tuesday, April 14, 2009 6:03 AM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: Wednesday, February 24, 2010 4:10 AM
    Points: 1,550, Visits: 2,232
    I don't think MDX is t-sql either

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley


    Posting Best Practices
    Numbers / Tally Tables

    SQL-4-Life
    Post #696452
    « Prev Topic | Next Topic »

    Add to briefcase 1234»»»

    Permissions Expand / Collapse