I have a table named
TestFormula Where are stored 50000 records.And table
Parameters where are stored parameters of formulas :
TestFormula Parameters
Id Formula Value Id Parameter Value
1 a+b-c NULL 1 a 10
2 a*c - b NULL 2 b 20
..................................... 3 c 5
.....................................
Can anyone help me with technique to UPDATE
TestFormula table's Value field with
his real value. I have a such technique
but it lasts over 50 seconds. I need better technique.
Sorry for my English
You can message me Russian
Thanks
I have a table named [b]TestFormula[/b] Where are stored 50000 records.And table [b]Parameters[/b] where are stored parameters of formulas :
[b]TestFormula[/b] [b] Parameters[/b]
Id Formula Value Id Parameter Value
1 a+b-c NULL 1 a 10
2 a*c - b NULL 2 b 20
..................................... 3 c 5
.....................................
Can anyone help me with technique to UPDATE [b]TestFormula[/b] table's Value field with
his real value. I have a such technique :) but it lasts over 50 seconds. I need better technique.
Sorry for my English
You can message me Russian
Thanks