November 29, 2012 at 7:17 am
Buenos días estimados, Creo este post para consultarse si alguno tiene idea de como puedo trasladar la función Pago de Microsoft Excel a un query en sql? Aguardo sus comentarios. Y gracias de antemano por las respuestas.
Saludos
------------------------------
Translated by Google Translate
Good morning, I found this post so if anyone has any idea how I can move the function of Microsoft Excel Payment to a query in SQL? I await your feedback. And thanks in advance for the answers.
regards
November 29, 2012 at 8:37 am
jagger_89 (11/29/2012)
Buenos días estimados, Creo este post para consultarse si alguno tiene idea de como puedo trasladar la función Pago de Microsoft Excel a un query en sql? Aguardo sus comentarios. Y gracias de antemano por las respuestas.Saludos
------------------------------
Translated by Google Translate
Good morning, I found this post so if anyone has any idea how I can move the function of Microsoft Excel Payment to a query in SQL? I await your feedback. And thanks in advance for the answers.
regards
Thank you for translating to English. 🙂
A little googling and some playing.
declare @LoanAmount int
declare @InterestRate numeric (15,10)
declare @NumPayments int
set @LoanAmount = 150000 --$100,000 value of the loan
set @InterestRate = .006666666 --8% annual interest rate
set @NumPayments = 360 --30 years or 12 * 30
select (@InterestRate + (@InterestRate / (POWER((1 + @InterestRate), @NumPayments) - 1))) * @LoanAmount
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 29, 2012 at 10:25 am
Muchisimas gracias por su tiempo. Lo voy a probar y le cuento como me funcionó.
Saludos!
---------------------------
Many thanks for your time. I'm going to try and tell him how I worked.
Greetings!
November 29, 2012 at 10:28 am
¡de nada
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply