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

 Scaled-down SQL Rate Topic Display Mode Topic Options
Author
 Message
 Posted Saturday, March 19, 2011 12:24 PM
 Hall of Fame Group: General Forum Members Last Login: Thursday, December 05, 2013 6:32 AM Points: 3,352, Visits: 1,474
Post #1080873
 Posted Sunday, March 20, 2011 8:38 AM
 SSCertifiable Group: General Forum Members Last Login: Yesterday @ 7:45 PM Points: 5,333, Visits: 21,992
Post #1080986
 Posted Sunday, March 20, 2011 11:58 AM
 Hall of Fame Group: General Forum Members Last Login: Thursday, December 05, 2013 6:32 AM Points: 3,352, Visits: 1,474
 bitbucket-25253 (3/20/2011)Excellent question and a more than excellent explanation of why the correct answer is what it is.Thanks - high praise indeed! I must mention though, that when trying to decide how to format the explanation, I came across this excellent post from SQL Kiwi (Paul White?) - which helped me considerably to come up with a clearer and more concise one than I would have done otherwise.
Post #1081005
 Posted Sunday, March 20, 2011 6:22 PM
 Mr or Mrs. 500 Group: General Forum Members Last Login: Wednesday, September 25, 2013 5:10 PM Points: 589, Visits: 2,436
 I am sorry, but I realy, realy don't understand why D is not good, even if I do your formula. Why is so that D would have a truncate answer and not C? I mean, both have a precision of 51 and only the scale is different (3 more digit more for C), which might explain something if you could explain my question here:If I declare D as precision of 23 instead of 25 and still having a scale of 10DECLARE @value1D DECIMAL(23,10), @value2D DECIMAL(23,10)it is still a precision over 38, and the scale is still 20 as previous, but the answer is not truncateWhy???
Post #1081052
 Posted Sunday, March 20, 2011 10:46 PM
 SSCrazy Group: General Forum Members Last Login: Thursday, November 07, 2013 10:01 AM Points: 2,163, Visits: 2,181
 Thanks for the question, it really does show why we need to pay close attention to the data types we use.
Post #1081079
 Posted Sunday, March 20, 2011 10:53 PM
 Ten Centuries Group: General Forum Members Last Login: Sunday, December 08, 2013 6:32 AM Points: 1,336, Visits: 1,714
 Excellent question, with an excellent (If I may dare say, better than BOL) explanation!Have a wonderful day! Thanks & Regards,Nakul Vachhrajani.http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspxBe courteous. Drive responsibly.Follow me on Twitter: @nakulv_sqlGoogle Plus: +Nakul
Post #1081080
 Posted Monday, March 21, 2011 1:31 AM
 SSChampion Group: General Forum Members Last Login: Today @ 1:24 AM Points: 11,229, Visits: 8,079
 Nice question, but a tough one for a Monday How to post forum questions.Need an answer? No, you need a question.What’s the deal with Excel & SSIS?Member of LinkedIn. My blog at LessThanDot. MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1081103
 Posted Monday, March 21, 2011 1:53 AM
 SSCrazy Group: General Forum Members Last Login: Yesterday @ 1:49 AM Points: 2,724, Visits: 3,794
 Very good question, indeed. +++ Best Regards, Chris Büttner
Post #1081107
 Posted Monday, March 21, 2011 2:01 AM
 SSCrazy Group: General Forum Members Last Login: Today @ 12:29 AM Points: 2,230, Visits: 2,123
 Unbelievable, but true!Thank you for qotd and a clear explanation!
Post #1081111
 Posted Monday, March 21, 2011 2:58 AM
 Ten Centuries Group: General Forum Members Last Login: 2 days ago @ 5:14 AM Points: 1,280, Visits: 713
 Good question - an area often overlooked by developers.
Post #1081121

 Permissions