Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION ufn_CalculateFutureValue(@SUM DECIMAL(18, 4), @yearlyInterestRate FLOAT, @numberOfYears INT)
- RETURNS DECIMAL(18, 4)
- AS
- BEGIN
- RETURN @SUM * POWER((1 + @yearlyInterestRate / 100), @numberOfYears)
- END
- SELECT dbo.ufn_CalculateFutureValue(1000, 10, 5)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement