Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2004-01-22 : 17:58:29
|
| I've never needed the EXCEPT function, so I thought I'd try it for fun. I get syntax / violation notices everytime I try to execute it.Is there something strange about that? Shouldn'tEXCEPT (('SAM'), ('JIM'))Return a recordset of 'SAM', so...SELECT EXCEPT (('SAM'), ('JIM'))Should be a valid syntax?? |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2004-01-22 : 18:06:11
|
Are you running it against SQL Server ? Its an MDX function so needs to be run against AS. I'm confused  |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-22 : 18:09:53
|
| And AS is Analysis Services in case you're wondering.Tara |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-01-22 : 18:38:35
|
OK, OK. My mistake.  I'll turn the page in BOL and try something else. |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2004-01-22 : 18:42:03
|
| Try out ALL, SOME and ANY Sam.DavidM"SQL-3 is an abomination.." |
|
|
|
|
|
|
I fooled around and got violated