For a sql server 2000 table that must hold exchange rates for currency and
fractions of hours that will be multiplied by currency values, is it (in
general) best to use a decimal data type or a smallmoney / money data type?
The values are small, i.e. a typical exchange rate might be 1.3367 or a
fraction of hours might be 1.5, 1.25 etc. The calculations will typically
be done in a query or stored procedure
Problem is that it's used for financial calculations and I'm not sure of the
implications of money versus decimal.
(I think float is completely ...