I have 3 tables Formula , Input, Output. I have a expression column in the formula table which has all the arithmetic expressions.
For eg: (x+2y-3z+(2a/4)-3c)*100...
I need to read this formula then substitute the values of X,Y,Z,A,C from input table and after execution I need to store the output value in the output table.
I have writen a query which can do the math for 2 variables and for single operand for eg : x+2y =z. But I dont have any idea how to do or write query for multi operand and for multi variabes as stated above.
If anyone has any idea of how to achieve this. It would be really helpfull to me. Please check the attached create table quereis and the sample query for your reference.