Re: Analytics/update question

From: Isa <isapmon_at_terra.es>
Date: 27 Sep 2005 04:30:27 -0700
Message-ID: <1127820627.333294.27870@o13g2000cwo.googlegroups.com>

Hi:
you can do the next:

update table t1
  set t1.value = (select t3.value from table t3

                    where t3.id = t1.id and
                             t3.date = ( select max(tt4.date) from
table t4
                                             where t4.id=t3.id and

t4.value <> -999.99 ) )
where t1.value = -999.99 and

         t1.date = (select max(t2.date) from table t2 where t2.id=t1.id):

I hope it's usefull to you
Regards,
Isa Received on Tue Sep 27 2005 - 06:30:27 CDT