October 5, 2012 at 7:41 am
Hugo Kornelis (10/5/2012)
kyliedude (10/5/2012)
Give me my point!If points are that important for you, you can have one of mine. Heck, you can have all of mine. Last time I checked, the grocery still didn't accept my points as payment, and I also still haven't seen any job ads where SQLServerCentral points are a job requirement.
Or, put differently: "loosen up, people!"
+1,000,000
Hugo thanks for putting these "points" in proper perspective.
October 5, 2012 at 7:47 am
sam.dahl (10/4/2012)
I recognised the attempt to insert null and hence picked 2,0 because that's what the two select statements return: 2 and 0. It's the insert statement that fails.
The question is about what the select statements return.
Both select statements run, one returns 2 rows, the other returns 0.
there's an error in the middle because of the insert, but the selects return values.
October 5, 2012 at 8:06 am
Hugo Kornelis (10/5/2012)
kyliedude (10/5/2012)
Give me my point!If points are that important for you, you can have one of mine. Heck, you can have all of mine. Last time I checked, the grocery still didn't accept my points as payment, and I also still haven't seen any job ads where SQLServerCentral points are a job requirement.
Or, put differently: "loosen up, people!"
Sorry to go off topic...
I was talking with a company recently about doing a moonlighting gig and I asked if the SSC points accumulation and percentage would give me the upperhand over someone else. The DBA laughed so hard he was in tears.
October 5, 2012 at 8:57 am
But the Explination dose not even support the question. I don't mind getting stuff wrong if I lean something from it but I do not appricate being told I'm wrong when the answer and explination do not support the question and I learn only the the person submitting the question did not even try it to see the result.
October 5, 2012 at 8:57 am
The wording of the question was "how many rows are returned from the SELECT statements" . . . I maintain that 2,0 is the correct answer since it's the INSERT statement that fails, not the SELECT statement.
October 5, 2012 at 9:02 am
bitbucket-25253 (10/5/2012)
Hugo Kornelis (10/5/2012)
kyliedude (10/5/2012)
Give me my point!If points are that important for you, you can have one of mine. Heck, you can have all of mine. Last time I checked, the grocery still didn't accept my points as payment, and I also still haven't seen any job ads where SQLServerCentral points are a job requirement.
Or, put differently: "loosen up, people!"
+1,000,000
Hugo thanks for putting these "points" in proper perspective.
I agree that the point of QotD is not to amass points. Hopefully we learn a little something each day. I do think the point thing is fun. But I think if you ask a question and someone answers correctly, you should not say "You're wrong." The question should match the results.
October 5, 2012 at 9:29 am
It's not just you. The questions and answers lately have been very poorly phrased.
October 5, 2012 at 10:11 am
that
s how I understood it as well. it's the question about the selects!
October 5, 2012 at 10:15 am
Probably a better QotD is: How did 53% get the answer 2,error? :hehe:
October 5, 2012 at 11:24 am
(Bob Brown) (10/5/2012)
Probably a better QotD is: How did 53% get the answer 2,error? :hehe:
<Cut> <Paste> <Execute> ?
October 5, 2012 at 11:58 am
Lokesh Vij (10/4/2012)
sam.dahl (10/4/2012)
I recognised the attempt to insert null and hence picked 2,0 because that's what the two select statements return: 2 and 0. It's the insert statement that fails.+1
I also misunderstood the question.
No, you didn't if you selected 2,0 as your answer. The "correct" answer is actually wrong, because the batch isn't aborted by the insert error and the second select runds and returns no rows.
Tom
October 5, 2012 at 12:02 pm
kyliedude (10/5/2012)
...and if you check out the question statistics - that's what most people are doing - getting it, erm, 'right'.
Which just demonstrates that most people don't understand how the error is handled.
Tom
October 5, 2012 at 12:07 pm
Hugo Kornelis (10/5/2012)
It wasn't intended as a lecture. It was just me letting off steam after seeing too many messages (not only in this topic, many topics have the same issue) of people "demanding" "their" points. I simply don't get why those points matter to people.
I agree with you, Hugo (except perhaps on whether it was a lecture or not) but people moaning when they got it right but the "official" answer was wrong is far less irritating (at least to me) that people moaning and demanding their points when they got it wrong and the question was right but they could not accept that it was.
edit: fix typos and a missing "not"
Tom
October 5, 2012 at 12:49 pm
Rich Weissler (10/5/2012)
(Bob Brown) (10/5/2012)
Probably a better QotD is: How did 53% get the answer 2,error? :hehe:<Cut> <Paste> <Execute> ?
Which gives you 2, 0 with an error on the insert. So the question remains...
October 5, 2012 at 12:54 pm
(Bob Brown) (10/5/2012)
Another confusing QotD! The answer is definitely 2,0. That is the results from the "selects". The "insert" errors out. It is very straight-forward.
+1
And then the guilty is the developer (never the analyst), due of its misunderstanding of the always well-written spec. 😀
Viewing 15 posts - 31 through 45 (of 57 total)
You must be logged in to reply to this topic. Login to reply