Viewing 15 posts - 271 through 285 (of 658 total)
Richard Warr (6/21/2013)it's obvious that the second error is caused by something outside the scope of the question
obvious after reading the answer anyway.
luckily I guessed it was yet another...
June 21, 2013 at 2:37 am
Thanks Hugo.
So "<> ALL" is equivalent to "NOT IN" ?
June 18, 2013 at 2:37 am
I got this wrong, but having read the explanation I'm still none the wiser...
June 18, 2013 at 2:11 am
demonfox (6/17/2013)I wonder how 28 % got it wrong...
Inability to read in my case :hehe:
June 17, 2013 at 2:55 am
Luis Cazares (6/14/2013)
The question is interesting but I do wonder why would someone would disable a clustered index?
They wouldn't - but the question shows you what would happen if they...
June 17, 2013 at 2:51 am
mtassin (6/13/2013)
does the writer consider the one row of xml plan that is returned a row or not?
but if they do, then there are two correct answers (the...
June 13, 2013 at 9:00 am
Can't see how any coin flip was needed. One interpretation resulted in 2 correct answers, which wasn't an option. So the other interpretation had to be correct.
June 13, 2013 at 5:12 am
mtassin (6/10/2013)
the fun times are when you find financial applications that use them
nothing wrong with that, so long as you Round as necessary
June 10, 2013 at 10:31 am
Hugo Kornelis (5/18/2013)
not native but, if I may say so, better than the average non-native English speaker
Better than most native English speakers, unfortunately...
May 29, 2013 at 2:37 am
I guess you're right. I'd assumed it meant the keyword DISTINCT, given that it was in uppercase 🙂
May 28, 2013 at 3:55 am
Easy enough if you know how EXCEPT and related options work.
But don't quite understand the statement "The key to this is of course the use of DISTINCT".
There is no use...
May 28, 2013 at 3:42 am
You should only rely on clauses evaluating in order when no aggregates are involved.
Good job the question didn't include any of those or I'd have been scuppered!
May 15, 2013 at 3:29 am
It's clear if you look at the ANSI documentation, which says
"X BETWEEN Y AND Z" is equivalent to "X>=Y AND X<=Z".
May 14, 2013 at 9:09 am
Thomas Abraham (5/14/2013)
I lost those two very valuable points
I hadn't noticed it was two points.
Woo hoo - Barbados here I come!
😎
May 14, 2013 at 5:38 am
SQLRNNR (5/13/2013)
just read the query for the intent
that's what I did.
I assumed the intent related to the need for a column alias
May 13, 2013 at 10:18 am
Viewing 15 posts - 271 through 285 (of 658 total)