Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2016
    Posts
    2

    Use Formulas on Tables

    hi, i'm trying to solve an old problem with a software that we are developing, i have a initial data and a lot of formulas to calculate another lot of data with this initial one. the real question is.

    1.- what is the best way of to do this action?.

    2.- can i have a table where the formulas are stored and then execute some store procedure to calculate the rest?

    3.- can this formulas has parameters ( Like Countries, Dates, etc) to know wich formula should the system use?

    4.- Is MSQL Server the best choice? or informix, Mysql?

    Thanks a lot for the advice

  2. #2
    Join Date
    Oct 2007
    Posts
    161
    ok, I'll take a shot at solving this for you with no information as to what you are wanting.

    1. The simplest, cheapest way.

    2. Of course

    3. any parameter you want as long as you code properly for it

    4. its always best done with the product you are most comfortable with.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •