Round up or down II

Question

Post reply

Round up or down II

Viewing 12 posts - 16 through 26 (of 26 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

Great question. I got it right....and still learned a couple of things in the explanation. Thanks.

SanjayAttray SSChampion Points: 13157 More actions · Answer 2

Good question Hugo. I missed . in Round. Still a lot to learn.

SQL DBA.

bbop1322 SSCommitted Points: 1694 More actions · Answer 3

bbop1322

SSCommitted

Points: 1694

August 10, 2010 at 8:24 am

#1204811

Almost got me with the '.'

Think great, be great!

rlwilde SSCommitted Points: 1545 More actions · Answer 4

Nice question. The discussion from the Aug. 3 question made this one easy. I learned something I didn't know last week, and I used that knowledge today. 🙂

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Nice question. Thanks Hugo.

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

David Data SSCrazy Points: 2965 More actions · Answer 6

I got one right, good! (I've used the . myself, usually as 3.0 rather than 3. for - as you say - greater clarity.)

But something went wrong with the Email version of the question, which was:

What wiil (sic) be the result when running this code?
By Hugo Kornelis
&nbsp &nbsp &nbsp &nbsp Think you know the answer? Click here, and find out if you are right.

So how were we to know whether we knew the answer to a question that was not stated?!

Hugo Kornelis SSC Guru Points: 64780 More actions · Answer 7

David Data (8/10/2010)
But something went wrong with the Email version of the question, which was:
What wiil (sic) be the result when running this code?
By Hugo Kornelis
&nbsp &nbsp &nbsp &nbsp Think you know the answer? Click here, and find out if you are right.
So how were we to know whether we knew the answer to a question that was not stated?!

I posted the code of the question as a graphic, to encourage thinking and research rather than copy/paste behaviour. It seems that such graphics are not always displayed correctly in the newsletter. Why that is, would be something for Steve to find out.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

David Data SSCrazy Points: 2965 More actions · Answer 8

Odd. I read mail using Thunderbird, which can handle HTML mail well, and the message had lots of other graphics displaying as usual.

Looking at the message 'source code', I see there IS a graphic link, but it's img alt="" border="0" src="/Images/6388.jpg" />

The URL is missing the root http://www.sqlservercentral.com/ (which the other images do have), so it's looking for 6388.jpg on my disk instead of on SQLServerCentral's!

Hugo Kornelis SSC Guru Points: 64780 More actions · Answer 9

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!

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

UMG Developer SSChampion Points: 13482 More actions · Answer 10

UMG Developer

SSChampion

Points: 13482

August 10, 2010 at 9:38 pm

#1205118

Thanks for the great question, and the discussion!

steve block SSCertifiable Points: 7698 More actions · Answer 11

I got it wrong because I over analyzed. I thought surely it can'y be this easy, Hugo wouldn't give us a cream puff. Must be getting smarter than I give myself credit for.

Steve

Ronald Beuker Old Hand Points: 387 More actions · Answer 12

Thanks, Hugo!

All clear to me now. 🙂

Reading my question now, many weeks after submitting it, I am wondering if I even should have written it like this - QotD should test SQL understanding, not reading ability

I had noticed the dot, but thought it would raise a syntax error. 😛

By the way, I agree it's best to use pictures to ask QotDs. You don't want it to become a 'copy/paste/F5' Quiz. :hehe:

Best regards,

Ronald