Archives of the TeradataForum

Message Posted: Fri, 25 Feb 2011 @ 14:41:32 GMT

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

Hi

You nedd to put a member will less precision like

     select
     cast( (3995852 * 100.000 / 12274677) as Decimal(6,3) ) as Data_Pct

Result

     Data_Pct
     32,554

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