jeudi 28 juillet 2016

How to Use Formula in SQL Query Dynamic?

I need your help to create query dynamically, how to populate data value from formula in other table.

Sample Below

Table A 
ID   Amount 
1    50 
2    40 
3    50 

Table B 
ID   FormulaID   VALUE 
X    1+2+3 
Y    1-2+3 

Result Expectation 
ID   FormulaID   VALUE 
X    1+2+3       140 
Y    1-2+3       60 

Thanks

Aucun commentaire:

Enregistrer un commentaire