by joe.pesch
27. January 2014 08:15
The following SQL statement will calculate a monthly loan payment (principal and interest).
select CalculatedPmt =
cast(
LoanAmount
/ (power(1+((NoteRate*.01)/cast(12 as float)),LoanTermMonths)-1)
* (((NoteRate*.01)/cast(12 as float))
* power(1+((NoteRate*.01)/cast(12 as float)),LoanTermMonths))
as decimal(10,2))
8e825b0f-d9f7-4353-bdf4-06fb9a09fb3d|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags:
SQL Server
by joe.pesch
1. January 2014 19:50
515deeb0-fea8-4cd5-b857-321936660ad0|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags:
SSAS