June 28, 2010 at 10:06 am
The points are nice because of the running totals in each of the various categories. It lets me know my strengths and more importantly my weaknesses. But I agree, that the number of responses here is a good thing; it shows that we have a large community of talented people who try their best to make sure everything is timely and accurate. Keep up the good work everyone!
June 28, 2010 at 10:14 am
kevin.l.williams (6/28/2010)
Sorry if this was already covered. I did read through the 11 pages :doze: and didn't see much on the subject of sort order. Without a specified order wouldn't -3, -2, -1 also be a correct answer?
Yup, that has been pointed out. By me, and probably by others as well, but a bit hard to find in between all the superfluous "me too" and "gimme my point" posts.
Steve Jones - Editor (6/28/2010)
It could be. Good catch, Kevin.
But unless I miss something, new visitors who see the corrected version of the question will get a point for the (now correct) -1,-2,-3 answer, but not get a point for the equally correct -3,-2,-1 answer. I think you should fix that as well!
(Oh, and BTW - thanks for fixing the other issue!)
June 28, 2010 at 10:22 am
Steve Jones - Editor (6/28/2010)
It could be. Good catch, Kevin.
Hey Steve did you correct Friday's question too ("SELECT @local_variable")? When I run the code I really get a,b,c and not C as stated in the real answer.
June 28, 2010 at 11:52 am
Question must have been fixed by the time I answered.
Thanks for the QOD.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2010 at 12:23 pm
CirquedeSQLeil (6/28/2010)
Question must have been fixed by the time I answered.Thanks for the QOD.
Me too. I began reading the discussion and thought the first few simply missed the "-" but it went on and on, so I figured it had been corrected by the time I got to it.:-)
June 28, 2010 at 12:44 pm
funny, teach me to read the question in the email, then read it again when I hit the site... they could very well be different questions... an annoying test in observation!
June 28, 2010 at 12:47 pm
Duncan Pryde (6/28/2010)
Changing the subject somewhat...Although I knew that you can have negative seeds and increments for the IDENTITY property, I've never actually used them myself.
I'd therefore be interested to hear if anyone else had used them, and in what sort of situations?
Duncan
Two live web servers, one on each coast. The two DB's replicate between themselves. On one coast, the identity columns are set to (-1,-1), and on the other they are set to (1,1) so that new records can be added to each server without stomping on each other. There probably is a better way, but this was done before I came here. Since this (again, before I came here), they consolidated the two servers into one, so we don't have this anymore... but we are dealing with both ranges of numbers (oh.. and guess which was is the consolidated database... yep, (-1,-1) )
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 28, 2010 at 2:35 pm
WayneS (6/28/2010)
Duncan Pryde (6/28/2010)
Changing the subject somewhat...Although I knew that you can have negative seeds and increments for the IDENTITY property, I've never actually used them myself.
I'd therefore be interested to hear if anyone else had used them, and in what sort of situations?
Duncan
Two live web servers, one on each coast. The two DB's replicate between themselves. On one coast, the identity columns are set to (-1,-1), and on the other they are set to (1,1) so that new records can be added to each server without stomping on each other. There probably is a better way, but this was done before I came here. Since this (again, before I came here), they consolidated the two servers into one, so we don't have this anymore... but we are dealing with both ranges of numbers (oh.. and guess which was is the consolidated database... yep, (-1,-1) )
So what??? it's still a freaking unique id :hehe:;-):w00t:
June 28, 2010 at 11:03 pm
i am getting -1, 0, 1
how come u r getting -1,-2,-3 ? pLz explain.......
June 29, 2010 at 1:23 am
Me too getting "-1,0,1" but available answer is "-1,-0,1" :w00t:
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 29, 2010 at 1:30 am
sunitagaikwad (6/28/2010)
i am getting -1, 0, 1how come u r getting -1,-2,-3 ? pLz explain.......
There was a typo in the question, that has been corrected after the newsletter was sent out. If you check the code on the website, you'll see that this code will indeed return -1,-2,-3 (or-3,-2,-1 - as there is no ORDER BY in the SELECT statement).
Always check for changes to the question before answering. Especially if more than a few hours have passed between sending the email and answering the question.
June 29, 2010 at 2:20 am
Perhaps we need some Quality Control on QOD.
Changing the question after people have started submitting answers - that seems a bit unfair to me...
June 29, 2010 at 2:28 am
paul s-306273 (6/29/2010)
Perhaps we need some Quality Control on QOD.Changing the question after people have started submitting answers - that seems a bit unfair to me...
Maybe you should read the previous reactions in the topic first....
What happens is that there was a typo in the question. So people gave an answer that was correct for the question as published, but wrong for the question as intended; and they did not get points for it.
When Steve got to work, he noticed the problems. He then corrected the question, and awarded points back to those who had already replied to the question because they missed the point through no fault of their own.
If you consider it unfair to change the question after people have submitted answers, does that imply that you think he should have left the incorrect question unchanged?
June 29, 2010 at 3:56 am
Answer is -1,0,-1
if(marked answer == -1,-0,1)
{ give points to those persons }
else
{ delete this questions/thread }
June 29, 2010 at 7:21 am
I thought this looked wrong, so I tried it.
I also got -1, 0, 1 from this code
Viewing 15 posts - 106 through 120 (of 144 total)
You must be logged in to reply to this topic. Login to reply