Field Type?

[Stephen Russell]

In a Financial application what filed type would you put Principle,
Interest, NumPayments?

I am considering using Money for Princ, Numeric for Interest and Num
Payments.

Is it a good idea to use Money or should I use Numeric?

__Stephen

[David Satz]

If you are going to preform calculations in TSQL using these 3 columns, you
probably want to keep them the same datatype, i.e. decimal(24,6).
Otherwise, SQL Server will choose to perform the calculation in money data
type I am pretty sure. I know Kalen Delaney had a good article on this in
SQL Server mag a few months ago:
http://www.sqlmag.com/Articles/Index.cfm?AuthorID=185


--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions
{ SQL Server 2000 SP2/6.5 SP5a } { Cold Fusion 5 SP1 } { VSS }
(Please reply to group only - emails answered rarely)
-----------------------------------------------------------------
"Stephen Russell" <srussell@wnm.net> wrote in message
news:3cefac1b@10.1.10.29...
> In a Financial application what filed type would you put Principle,
> Interest, NumPayments?
>
> I am considering using Money for Princ, Numeric for Interest and Num
> Payments.
>
> Is it a good idea to use Money or should I use Numeric?
>
> __Stephen
>
>