Viewing 15 posts - 2,701 through 2,715 (of 3,348 total)
Festeron (8/16/2010)
It does care. Because if there is no data in one partition, then the result varies.
That was my understanding, but the supplied answer seems to say that the function...
August 16, 2010 at 1:32 pm
Frankly, I never understand why people do take the considerate effort to assemble and submit a question, along with an explanation and some believable answer options, and then don't take...
August 12, 2010 at 3:28 am
malleswarareddy_m (8/11/2010)I guessed correctly as 4.but i executed the script it is throwing error in the last statement.because group by is not there in the last statement.
Based on visual inspection...
August 12, 2010 at 1:02 am
That sounds like a very probably explanation to me.
I've sent a mail to Steve, asking him to check and then fix this. Thanks, David!
August 10, 2010 at 5:05 pm
David Data (8/10/2010)
What wiil (sic) be the result when running this code?
By Hugo Kornelis
        ...
August 10, 2010 at 2:29 pm
shyamsri83 (8/10/2010)
Hi,Very interesting question.
But I cant understand the usage of the 'dot' in the line
Set @result = Round(5/3.,1)
Can you please explain.
Regards,
a.shyam
Adding the dot is the easiest...
August 10, 2010 at 3:33 am
Ronald Beuker (8/10/2010)
Oeps, weer wat geleerd. 😉
The precedence of decimal is higher than that of integer, so the result will be truncated to a decimal(7,6) value of 1.666666.
This...
August 10, 2010 at 3:30 am
ziangij (8/10/2010)
thanks 🙂was always worried about such integer conversions... will now just add a dot to ensure that the conversion is correct...
You're welcome.
But please do realise that the code in...
August 10, 2010 at 3:23 am
me_always (8/9/2010)
Hi,Could not get the having clause ...
can anyonce please explain?
Sure - but such a broad question is too hard to answer (other than with a reference to Books...
August 9, 2010 at 4:47 am
Good question! When I first saw it, I thought there would be a very high percentage of correct answers since the confusing default lengths for character strings have already been...
August 9, 2010 at 12:59 am
It's an interesting technique - but not one I would recommend!
The simple version has this caveat: it works "as long as they share the same primary key and the shared...
August 9, 2010 at 12:52 am
Interesting question. Shame about the typos in the answer options, though - they almost made me miss the correct answer.
August 5, 2010 at 1:21 am
mtillman-921105 (8/3/2010)
August 3, 2010 at 2:52 pm
Open Minded (8/3/2010)
It surprises me why round() acts like floor() when numbers are integers.
That is not the case. ROUND() does not act like FLOOR().
The "problem" here is the order or...
August 3, 2010 at 5:08 am
cengland0 (8/3/2010)
So you need to cast it like this?round(cast(5 as float) / cast(3 as float),1)
As ziangij already says, casting one of the operands is sufficient. And if you do use...
August 3, 2010 at 3:46 am
Viewing 15 posts - 2,701 through 2,715 (of 3,348 total)