Posted by figital on 03/02/06 21:39

BVH,

You are probably the victim of integer arithmetic.

Change @DiscountRate / 100 to @DiscountRate / 100.0.

That "point zero" tells the system that you want float division,
instead of integer division. The better solution would be to cast the
integer to a float but adding .0 will work.

[Back to original message]