Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Coalesce and Conversion Rate Topic Display Mode Topic Options
Author
 Message
 Posted Wednesday, January 9, 2013 6:51 PM
 SSCrazy Group: General Forum Members Last Login: Tuesday, March 8, 2016 10:23 AM Points: 2,144, Visits: 613
 Great QoTD..Thanks..
Post #1405114
 Posted Thursday, January 10, 2013 10:47 AM
 SSCrazy Eights Group: General Forum Members Last Login: Today @ 7:26 AM Points: 9,830, Visits: 11,900
 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. 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
Post #1405559
 Posted Friday, January 11, 2013 11:53 AM
 Old Hand Group: General Forum Members Last Login: Thursday, November 24, 2016 7:31 AM Points: 348, Visits: 292
 really very tough one... ManikYou cannot get to the top by sitting on your bottom.
Post #1406213
 Posted Saturday, February 2, 2013 3:20 AM
 SSC Veteran Group: General Forum Members Last Login: Wednesday, May 11, 2016 1:17 AM Points: 282, Visits: 100
 I got the result by executing the each statement :)
Post #1414933

 Permissions