Help me with formulas

SQL во всех проявлениях - от ANSI-92 до TSQL.

Модераторы: Yurich, Absurd

Ответить
Sench4
Сообщения: 2
Зарегистрирован: 12 мар 2008, 09:26

12 мар 2008, 11:53

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
Ответить