Re: [SQL] update from multiple rows

2005-01-23 Thread adam etienne
Thanks for your answer In fact the computation is somewhat more complex than an average and the data set is quite large... I did some test with view & triggers but it's too slow.. Moreover, sometime i need to do big insertion or update and then other time i need juste little updat

[SQL] update from multiple rows

2005-01-22 Thread adam etienne
hi I have some trouble updating a table like this one : date | data_raw | data_sys 12-01 | 5 | 4.5 13-01 | 6 | 6 14-01 | 7 | 8 I would like to update the 'data_sys' ro