Viewing 15 posts - 1 through 15 (of 92 total)
Think the confusion relates to the text in the Explanation, which in itself is fine but references syntax 3 but gives the right syntax from the correctly marked answer!
January 28, 2020 at 11:47 am
How does 2019-01-18 end up being Sep 1, 2019 too? 😉
September 27, 2019 at 8:05 am
Joining the throng of questions on the answer here!!! I'm pretty sure it is currently wrong!
March 1, 2018 at 1:29 am
July 31, 2017 at 2:07 am
I don't see how plot or barplot can be differentiated in terms of the requirement to "graph his home runs over time showing the count of each relative to the...
July 19, 2017 at 2:01 am
I'm sure it'll get fixed, but I'm also confused by the answer! I've also done this on a number of occasions to both Data and Log files...
February 8, 2017 at 12:53 am
Felix Pamittan (5/5/2016)
Yes, you can run this code, This returns 97
You can run this code. The CHAR variable is converted to NCHAR and the first...
May 6, 2016 at 12:59 am
a lovely easy start to the week- thanks.
July 20, 2015 at 2:01 am
Very vague question - and as others say, multiple ways to consider something the odd one out.
June 29, 2015 at 5:25 am
Looks easy, but need to notice the Union rather than Union ALL!!! Really need to read the question carefully...
June 12, 2015 at 2:03 am
I can see where all the doubt in this question arises - as discussed. Only saving grace is the statement in the Aggregate Function link, which states:
Except for COUNT, aggregate...
January 7, 2015 at 2:09 am
Missread the intention of the query. Knew NOCOUNT would return no counts, but thought it was about what should have been returned! Doh!!!
Nice question and interesting use of the two...
December 11, 2014 at 1:53 am
Great simple question... Was looking for the catch, and very glad there wasn't one!
October 23, 2014 at 1:40 am
Agree, that I want my point back.
The only thing I can add is that Either should be an option given that the column definitions actually differ! Thus if it...
September 9, 2014 at 1:22 am
Nice easy question for the end of the week, especially given the selection of answers!!! 😀
August 29, 2014 at 1:40 am