Payment function in MSSQL
Posted on 2003-11-26
I have developed a database in Access but am now having a problem moving it over to MSSQL. I'm experienced in Access and new to SQL. The problem is with Functions. In my access database I have a table called Mortgage_Rates. What I have done is create a qurey that will generate the APR based upon the rate.
Here is my SQL Statement from Access.
-PMT(Purch_Ref_Rate/12,180,100000,0,0) AS Payment,
Rate(180,Payment,-(100000-2500),0)*12 AS APR,
This works great in Access however when I create the View in SQL I get an Error saying that the PMT Function is not a valid function. I did a little digging in the Help files and found it was valid in something called SQL Server Analysis Services. I installed it and took a look at it. I am not sure if this is what I was looking for.
So the question is,
Do anyone know how to make my (Access) SQL Statement work in MSSQL(2000 pro). Or Do I have to use this Analysis Services thing. Or am I completely missing the mark altogether.