Archives of the TeradataForum

Message Posted: Wed, 08 Nov 2006 @ 09:25:44 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

What about this:

     UPDATE  lp_test_table from
      (SELECT min(lp2.OB_TMSTMP)
        FROM  lp2.lp_test_table lp2, lp_test_table lp1
        WHERE lp2.lead_num = lp1.lead_num
        AND lp2.OB_TMSTMP > lp1.OB_TMSTMP) mytbl(col1)
      SET NEXT_OB_TMSTMP  = mytbl.col1;

	<Prev	Next>		<<First	<Prev	Next>	Last>>