Archives of the TeradataForum
Message Posted: Fri, 11 Jun 2010 @ 07:11:57 GMT
and run the following query:
SEL 82025328 AS CCCP_KEY ,99999999.00 (DECIMAL(15,2)) AS APP_MTHLY_INCM_AM ,0.9987660000 (DECIMAL(18, 10)) AS USD_RT , (APP_MTHLY_INCM_AM) /(USD_RT) (DECIMAL(18,2)) AS USD_CONV FROM (SELECT 1 x FROM sys_calendar.calendar WHERE day_of_calendar = 1) mT GROUP BY 1,2,3,4;
But no error was occurred. Try it. What is the version of your Teradata?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|