Archives of the TeradataForum

Message Posted: Mon, 14 Mar 2005 @ 14:56:51 GMT

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

This will work:-

     insert into t_au
     select ZEROIFNULL(MAX(tid))+ 1,  'WWW'
     from t_au;

Pulak

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