InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 18:31:36 GMT20http://www.sqlservercentral.com/Forums/Topic844257-391-1.aspxThe results you are getting have to do with rounding rules.They may be related to accounting rounding rules.Fri, 18 Jan 2013 13:02:24 GMTarnipeturssonhttp://www.sqlservercentral.com/Forums/Topic844257-391-1.aspxThe money data type is not an MS construct.It came over with the original Sybase SQL Server code.Fri, 18 Jan 2013 12:56:19 GMTarnipeturssonhttp://www.sqlservercentral.com/Forums/Topic844257-391-1.aspxwell said, I agree 100%Fri, 18 Jan 2013 12:38:54 GMTgoran.biljetinahttp://www.sqlservercentral.com/Forums/Topic844257-391-1.aspxI've avoided money as I'm not sure if provides benefits over the numeric types. It also limits me, and I prefer to not be limited. I let the application handle the decisions on formatting and presentation.Fri, 08 Jan 2010 08:02:18 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic844257-391-1.aspxWhat is being presented to me is the following SQL:DECLARE @dOne DECIMAL(10,2), @dThree DECIMAL(10,2), @mOne MONEY, @mThree MONEY, @fOne FLOAT, @fThree FLOAT SELECT @dOne = 1, @dThree = 3, @mOne = 1, @mThree = 3, @fOne = 1, @fThree = 3 SELECT @dOne = @dOne/@dThree*@dThree , @mOne = @mOne/@mThree*@mThree , @fOne = @fOne/@fThree*@fThree SELECT @dOne AS DecimalResult, @mOne as MoneyResult, @fOne as FloatResultproduces DecimalResult = 1.00Money Result = .999999FloatResult = 1Fri, 08 Jan 2010 07:51:38 GMTmfinch4http://www.sqlservercentral.com/Forums/Topic844257-391-1.aspxQuoting Books online..The money and smallmoney data types are accurate to a ten-thousandth of the monetary units that they represent. Ans it does not represent currency symbol...Fri, 08 Jan 2010 07:31:22 GMTBru Medishettyhttp://www.sqlservercentral.com/Forums/Topic844257-391-1.aspxafter looking it does not put the $ inf ront of the number but try this little script and then rethink your question.declare @int moneydeclare @int2 decimal(9,2)set @int = '88.5555555555555666666666666'set @int2 = 88.55555555555556666666666666select @int, @int2which is more accurateFri, 08 Jan 2010 07:23:36 GMTtclemonshttp://www.sqlservercentral.com/Forums/Topic844257-391-1.aspxif i am not mistaken the money type placse the $ infront of the number where as decimal does notFri, 08 Jan 2010 07:20:32 GMTtclemonshttp://www.sqlservercentral.com/Forums/Topic844257-391-1.aspxWe are trying to decide if we should use Money or Decimal(9.2) for our currency columns and are wondering why MS created Money datatype if decimal produces more accurate results?Fri, 08 Jan 2010 06:54:24 GMTmfinch4