October 16, 2014 at 6:15 am
So much complaining about a missed point. You can have mine if you want them. They are not worth anything other than tracking the number of posts you have made. If points are so important you should try posting in the forums instead of just complaining about incorrect answer on a QOTD.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 16, 2014 at 6:18 am
I can't speak for anyone else, but my complain about the point was done with my tongue firmly in my cheek! 😉
October 16, 2014 at 6:19 am
Sean Lange (10/16/2014)
If points are so important you should try posting in the forums instead of just complaining about incorrect answer on a QOTD.
+1. The missing point is not the point. It that's the point, then you've missed the point. (Sorry, I couldn't resist the opportunity. :-D)
The point is that either the wrong answer is marked as right or the QOTD is malfunctioning. The second possibility points to a software glitch, while the first possibility is more serious.
October 16, 2014 at 6:21 am
The point is not the point<grin> I use this as a way to point out deficiencies in my knowledge. It gives me a headache trying to figure out where I was wrong in my assumption or execution, only to realize it's not me:)
October 16, 2014 at 6:35 am
+1
:w00t:
October 16, 2014 at 6:39 am
PurpleLady (10/16/2014)
The point is not the point<grin> I use this as a way to point out deficiencies in my knowledge. It gives me a headache trying to figure out where I was wrong in my assumption or execution, only to realize it's not me:)
Frequently the discussions that arise from QOTD are far more educational that the question itself (be it a good or bad one). It is often in this discussions that the finer points of the topic in question are explained.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
October 16, 2014 at 7:29 am
Stuart Davies (10/16/2014)
PurpleLady (10/16/2014)
The point is not the point<grin> I use this as a way to point out deficiencies in my knowledge. It gives me a headache trying to figure out where I was wrong in my assumption or execution, only to realize it's not me:)Frequently the discussions that arise from QOTD are far more educational that the question itself (be it a good or bad one). It is often in this discussions that the finer points of the topic in question are explained.
+1 Often it is in fact the worst questions that elicit the best discussions.
That being said I thought this was a great question, it is unfortunate that the OP chose the wrong answer but that shouldn't detract from the topic and lesson being taught.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 16, 2014 at 7:41 am
It's so frustrating when you test and confirm your answer, enter it into the web page and it tells you that you're wrong!
The QotD submitters need to add what version they did their test on.
October 16, 2014 at 7:50 am
How do you get 3 rows?
October 16, 2014 at 8:00 am
REALLY getting tired of CORRECT ANSWERS BEING WRONG. I have to ask now since this is the SECOND day in a row, is it SQLServerCentral's intention to provide INCORRECT information? Someone should be reviewing these QOTD questions BEFORE they are posted. It's fairly obvious it's going to return two rows but since I got it wrong I loaded it up and ran it and I was RIGHT ABOUT BEING WRONG. FIX THIS.
October 16, 2014 at 8:02 am
twin.devil (10/16/2014)
Apologies everyone wrong radio button was selected ... Still wondering how.As for the point, i would say ..
Sometimes in the real world, even if you are right you still ends up with empty hands 😛
Look at the positive positive side. script didn't generate error and importantly, you will not forget that UNPIVOT do not return all the rows 😉
last but one the least thanks for comments.
twin devil, thanks for the terrific question that made me think, and kudos for having the courage to stand up and admit the mistake.
October 16, 2014 at 8:07 am
Bobby Russell (10/16/2014)
REALLY getting tired of CORRECT ANSWERS BEING WRONG. I have to ask now since this is the SECOND day in a row, is it SQLServerCentral's intention to provide INCORRECT information? Someone should be reviewing these QOTD questions BEFORE they are posted. It's fairly obvious it's going to return two rows but since I got it wrong I loaded it up and ran it and I was RIGHT ABOUT BEING WRONG. FIX THIS.
Have you ever posted a QOTD? Would you volunteer to be on a committee to review and test each and every QOTD before they go live? I am sure Steve would love to have somebody help with this. Instead of screaming about the problem maybe you should offer to be part of the solution.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 16, 2014 at 8:27 am
oops!
October 16, 2014 at 8:41 am
The answer has been corrected and points awarded back.
October 16, 2014 at 8:47 am
This was removed by the editor as SPAM
Viewing 15 posts - 31 through 45 (of 64 total)
You must be logged in to reply to this topic. Login to reply