HOWTO: Write Formula Engine Using T-SQL

This came from our actuaries, - create a formula generation and processing engine.

They have a dozen of well-normalized base tables that contain statistical data on competitors, broken down by state, county, city, and zip.

The result should contain aggregated breakdown by the same set of data elements, but also include along with other things an input formula and its result for the Base Rate.

The whole thing is a mini-Monte Carlo simmulation.

THE TRICK:
If the formula today looks like:

x = ((a + b) * (c - d + e)) / (a * (c - d) * (f - d) * (e + d))

then tomorrow it may look like:

x = a * b * c * d * e * f

THE REAL TRICK: It should not be based on dynamic SQL!!!

Any thoughts?...