InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 13:23:05 GMT20http://www.sqlservercentral.com/Forums/Topic870096-392-1.aspx[quote][b]Hariprasad.M (2/22/2010)[/b][hr]Thanks paul, that was good one.[/quote]No worries, Hari - I enjoyed writing the reply. It would be cool if you would just post your questions in one forum from now on though ;-)Mon, 22 Feb 2010 22:53:36 GMTPaul Whitehttp://www.sqlservercentral.com/Forums/Topic870096-392-1.aspxThanks paul, that was good one. regardsHariMon, 22 Feb 2010 22:45:14 GMTHariprasad.Mhttp://www.sqlservercentral.com/Forums/Topic870096-392-1.aspx[color="#FF0000"][b]Duplicate thread.[/b][/color]I posted a comprehensive answer here:[u][url]http://www.sqlservercentral.com/Forums/Topic870098-338-1.aspx[/url][/u]Mon, 22 Feb 2010 07:49:26 GMTPaul Whitehttp://www.sqlservercentral.com/Forums/Topic870096-392-1.aspxHi, Try this,SELECT CAST(CAST(1.67574 AS DECIMAL(38,10)) / CAST(10000 AS DECIMAL(38,10)) AS DECIMAL(38,10)) conv_factorSQL server taking a default scale, you need to explicitly specify the precision and scale.regardsHariMon, 22 Feb 2010 05:50:57 GMTHariprasad.Mhttp://www.sqlservercentral.com/Forums/Topic870096-392-1.aspxHiLook at these SELECT statements.1. SELECT CAST(1.67574 AS DECIMAL(38,10)) A, CAST(10000 AS DECIMAL(38,10)) B2. SELECT CAST(1.67574 AS DECIMAL(38,10)) / CAST(10000 AS DECIMAL(38,10)) conv_factorWhen first statement is run the result isA B1.6757400000 10000.0000000000But, when the second one runs, the result is conv_factor0.000167Both the numbers are converted into DECIMAL(38,10) before the division, but, why did this truncation occured?Mon, 22 Feb 2010 00:02:56 GMTdutt