Archives of the TeradataForum

Message Posted: Tue, 16 Nov 2010 @ 08:43:31 GMT

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

Hi Jinendra ,

This error occurs when your table has huge volume of records, which exceeds the range of the integer.

Integer can accept just 10 numbers. Beyond that it has to be casted to higher data types.

The below problem can be over come as below :

     Select cast(count(*) as decimal(18,0)) from table_name;

Rgds,

Anusha

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