Eugene Elutin (10/11/2012)
Float is a very bad choice for monetary values as it's approximate numeric.I would recommend Decimal which is precise (exact numeric).
You can use Money too, if you brave enough, but be aware of how it behaves in calculations:
declare @m money
declare @d decimal(10,4)
select @m = 19.34, @d = 19.34
select (@m / 1000)*1000 as [using money], (@d / 1000)*1000 as [using decimal]
Ops... :w00t:
Yes u r right ..but the choice may depend on the usage of data ...same data used in money transaction may considers all precision where for research and analysis , it may not be fruitful to keep all the precision....
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: