busraker (9/17/2013)

---

Eliza (9/16/2013)

---

Hi,

All the information for parameters comes from three tables. All joined with inner joins.

At the moment I feel I have functions embedded with functions and its not clean but messy.

Because the data is from 3rd party database, we cannot add indexes to improve performance or add application logic. I can select data only.

Can you create custom tables in that another database? If you're looking to document and optimize your calculation, you could set up a job that:

1. Finds new rows not already processed

2. Pull the necessary data into a properly indexed table (with your three inner joins) with NULL columns for your calculations

3. Perform the document the calcs with the new columns

4. Do what you need to with the result