Archives of the TeradataForum

Message Posted: Mon, 14 Mar 2005 @ 14:37:59 GMT

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

Try this insert instead....

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

Kevin R Tewksbury
Database Administrator
Limited Technology Services

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