Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Complex Query
Hey just to let you know I got around this problem in a very blunt way by creating a table in my Oracle application to mimic the 33 seperate queries needed. It ain't pretty but its pretty robust. I will roll out this application soon using my less than perfect solution and when my plate clears... -
Complex Query
Wow thanks!! I'll take a little time to digest this and come back with some questions!!! Many many thanks to you guys this is great -
Complex Query
I'm 110% sure there is Alex :) :lol: Yes it helps.... very much! It is being written in HTMLDB/ Application Express, which as you rightly say is a middleware/ front end for deploying web apps reading from Oracle. Here is the select query. select (D2004 /(POWER((1 + (:DISC_1/100)),(2004 -... -
Complex Query
Alex thanks. I've only got as far as writing 33 different queries for each possible value of Y2, which will be between 2003 and 2036. This approach will be fine but I need help getting this one to run as well. So I have a value for Y2 which will trigger one of 33 possible queries. How can I... -
Complex Query
Ok I have the following variables Discount Rate (R) - A static user defined value demand (D) - the result of a query base year (Y1) - 2003 future year (Y2) - user entered and needs to count backward to base year I need the following formula to execute NPD = D/ (1+R)^(Y2-Y1) and iterate...
