Microsoft Money

Question

Post reply

Microsoft Money

mfinch4

SSC Rookie

Points: 31
More actions
January 8, 2010 at 6:54 am

#215469

We 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?

Viewing 9 posts - 1 through 8 (of 8 total)

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

tclemons SSC Journeyman Points: 87 More actions · Answer 1

if i am not mistaken the money type placse the $ infront of the number where as decimal does not

tclemons SSC Journeyman Points: 87 More actions · Answer 2

after looking it does not put the $ inf ront of the number but try this little script and then rethink your question.

declare @int money

declare @int2 decimal(9,2)

set @int = '88.5555555555555666666666666'

set @int2 = 88.55555555555556666666666666

select @int, @int2

which is more accurate

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 3

Quoting 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...

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

mfinch4 SSC Rookie Points: 31 More actions · Answer 4

What 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 FloatResult

produces DecimalResult = 1.00

Money Result = .999999

FloatResult = 1

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 5

I'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.

goran.biljetina Valued Member Points: 63 More actions · Answer 6

goran.biljetina

Valued Member

Points: 63

January 18, 2013 at 12:38 pm

#1578853

well said, I agree 100%

arnipetursson SSCertifiable Points: 6557 More actions · Answer 7

The money data type is not an MS construct.

It came over with the original Sybase SQL Server code.

arnipetursson SSCertifiable Points: 6557 More actions · Answer 8

The results you are getting have to do with rounding rules.

They may be related to accounting rounding rules.