• Jeff Moden (8/29/2016)


    Someone would have to prove that one to me, Sergiy.

    It took 2 minutes:

    DECLARE @Amount MONEY, @Term INT

    DECLARE @fRate float, @dRate decimal (38,10)

    SELECT @Amount = 1000000, @Term = 17*9*13*7

    SELECT @fRate = CONVERT(FLOAT, @Amount)/@Term,

    @dRate = CONVERT(DECIMAL(38,10), @Amount)/@Term

    SELECT @fRate, @fRate * @Term fAmount,

    @dRate, @dRate * @Term dAmount

    _____________
    Code for TallyGenerator