Archives of the TeradataForum

Message Posted: Tue, 16 Oct 2007 @ 17:12:06 GMT

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

Have you tried this?

     insert into database.test (c1,c2,c3,c4)
     values(row_number() over(order by *c2, c3*),:c2,:c3,:c4);
     Instead of the column value in the order by list, please try the
     columnname exaclty.

Thanks & Regards,

Murali D.

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