loop through arrays in a stored procedure
This is a discussion on loop through arrays in a stored procedure within the Sybase forums, part of the Database Server Software category; --> --CELKO-- schrieb: >>>.. it would take us 1 year to teach design of some pure SQL procedures that allow ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 06:04 PM
| ||||
| ||||
 Re: loop through arrays in a stored procedure --CELKO-- schrieb: >>>.. it would take us 1 year to teach design of some pure SQL procedures that allow us to calculate some Loans including linear interpolation in a yield curve or applying some more complex math calc (including built-in functions like exp() and so on. << > > > Or you could find a solution for NPV and IRR using auxiliary function > tables, a quick look at the details are in Chapter 22 of SQL FOR > SMARTIES. That is how people did it before calculators and cheap > computers. It also has the advantage of operating in parallel instead > of on a row-by-row basis, and you can avoid linear interpolation in > favor of a second delta interpolation so the results are more accurate. > > > The auxiliary table is loaded once and the programming is a simple > join. I doubt that it would take a year to do this  Interesting. I will have a look at your book D.      |
|
04-08-2008, 06:04 PM
| ||||
| ||||
| Re: loop through arrays in a stored procedure You might also want to look at a free SD Times Web Seminar, "Optimizing Numerical Applications in Java for Finance" Date: Tuesday, September 27, 2005 Time: 11:00am Pacific / 2:00pm Eastern Length: Under one hour http://bzmedia.com/webseminar/seminar1815.htm |
Linear Mode
