Coalesce and Conversion

Question

Post reply

Coalesce and Conversion

Viewing 9 posts - 16 through 23 (of 23 total)

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

Very nice question Tom. Learnt something new today:-)

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

jvac SSC Journeyman Points: 94 More actions · Answer 2

thanks good and very tough question!

_______________________________________________________________
"The best way to prepare for programming is to write programs, and
to study great programs that other people have written." – Bill Gates

sqlnaive SSCoach Points: 17437 More actions · Answer 3

sqlnaive

SSCoach

Points: 17437

January 9, 2013 at 12:01 am

#1575075

Great question, must say. +1

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 4

Interesting question, thank you Tom.

(even kind of knowing the output for each select statement, it tempted me to challenge self and to prove it)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Dana Medley SSCertifiable Points: 6764 More actions · Answer 5

Thanks for the great question Tom. It really made me think; there were so many choices and it was so early in the morning. I can definitely say I'm awake now. 😀

Everything is awesome!

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 6

PChiragS

SSCarpal Tunnel

Points: 4965

January 9, 2013 at 6:51 pm

#1575536

Great QoTD..

Thanks..

TomThomson SSC Guru Points: 104773 More actions · Answer 7

john.arnott (1/8/2013)
How annoying. You made me think! 😉
I agree this was an excellent question and explanation. I do see that one minor correction could be needed to one example given, however. You say "...for example the numeric value 37.2 can be converted to an int (37)...". Did you actually mean that an INT (@i) could be converted to the higher precedence numeric type, as obviously could be the literal value 37.2? After all, the result of that coalesce is 37.2 and not 37.

yes, I did. Obviously my check-reading what I had written wasn't up to scratch that day. :blush:

edit: On second thoughts no; what I really meant was that no conversion was required because the decimal value 37.2 already has the type (decimal) with highest precedence of the three parameters to that coalesce expression.

Tom

manik_anu SSCrazy Points: 2377 More actions · Answer 8

really very tough one...

Manik
You cannot get to the top by sitting on your bottom.

udayroy15 Ten Centuries Points: 1076 More actions · Answer 9

I got the result by executing the each statement 🙂