#DateForumTypeThreadPost
36613 Jun 2012 @ 10:30 PDTDatabaseReplyCombining Multiple Insert Statements with Calculations Fields You might need to spend some reasonable time on the SQL basics  Each of your insert into tab values xxx will create a row - populated only one column.  Insert / Select statemen...
36513 Jun 2012 @ 10:24 PDTDatabaseReplyError from Insert Select statement You might avoid the error message but I doubt that you resolved the issue.  You will face skew issues if the Primary Index is Null for all rows.
36413 Jun 2012 @ 10:15 PDTDatabaseReplyUpdate Interval column on Interval substraction check the type of INTERVAL '0' SECOND - it is not an interval hour(3) to second(2). Try cast('0:00:00' as interval Hour(3) to Second(2)) instead.  
36313 Jun 2012 @ 07:58 PDTDatabaseReplyFailure 3568 Cannot nest aggregate operations funny reply - you need to avoid them as otherwise you will not get a result as the syntax is not supported. But to help you much more details would be required. Are you group this? What shou...
36213 Jun 2012 @ 07:50 PDTDatabaseReplySQL Query - Help In case the min date is on position 1 would you expect 1 or 2 result rows?
36113 Jun 2012 @ 07:43 PDTDatabaseReplyError from Insert Select statement you said that BORROWER_NAME is not part of the PK, which you seem to have defined for the table. In this case your statement will use null for all  DISTINCT TRIM (CM_CUST_NAME...
36012 Jun 2012 @ 10:52 PDTDatabaseReplyEquivalent of TSQL RAND Function in Teradata you can not controll the seed in teradata, so you can not controll the random number generation. But beside this  cast(random(0,1000000000) as decimal(20,10))/1000000000 might give ...
35912 Jun 2012 @ 10:41 PDTDatabaseReplyFailure 3568 Cannot nest aggregate operations It would be much easier if you format your code in a way that the structure can be understand. But the error message should give you an hint - you can not build a sum on a sum within one sta...
35812 Jun 2012 @ 12:46 PDTGeneralReplyJoin Condition Teradata can explain. So check the explain of the statement.
35712 Jun 2012 @ 04:45 PDTAnalyticsReplyConnecting to Teradata in R via the teradataR package You migh need to set the default DB on the connect statement. the following worked for me: library(RJDBC) Lade nötiges Paket: DBI Lade nötiges Paket: rJava > .jaddClassPat...
35611 Jun 2012 @ 09:50 PDTGeneralReplyIncomplete Query String in QueryText Column It depend on the query log settings. So you can define how much chars should be logged in the qrylog table. If SQL logging is enabled - which is often the case if the SQL is shorten for the ...
35507 Jun 2012 @ 04:22 PDTToolsReplyNumeric overflow what might be the datatype of 1? Don't you controll the max recurisve dept?
35407 Jun 2012 @ 04:20 PDTDatabaseReplyTo find invalid dates? 1.) calendar tables has < 40000 rows. We are heading for 3652060 rows. So 50 is the min value where times the count(*) calendar > 3652060. - we would clearly minimise unneccesary...
35306 Jun 2012 @ 10:36 PDTGeneralReplyHow to write FIRST_VALUE() and LAST_VALUE() window function in Teradata? as I said, not pretty, you can cast all fields separatly into fix length chars before concat and nulls can be handled via coalesce(cast(colx as char(10)),'NULLNULLNU')) - which will ...
35206 Jun 2012 @ 10:31 PDTDatabaseReplyTo find invalid dates? create volatile table ref_date as ( select row_number() over (order by c1.calendar_date, c2.calendar_date) as id, ('0001-01-01' (date)) + (id -1) as valid_date from sys_c...
35106 Jun 2012 @ 10:17 PDTDatabaseReplyTo find invalid dates? remains the problem of 29 Feb validity checking... I guess 99991231 is a high value. Your might also have some other speccial dates. What is the standard range of dates? maybe a two ...
35006 Jun 2012 @ 10:07 PDTDatabaseReplyNeed help in tuning a query Hi goldmine, how could this plan be improved? Its doning a plain aggregation, no joins etc. Stats might give better estimates but will not change the plan.  
34906 Jun 2012 @ 10:00 PDTDatabaseReplyNeed help in tuning a query Hi Ashwini, you posted only one query log entry. My understanding is that different runs differ in execution time / ellapsedtimes. Do they differ in AMPCPUtime, totalIOCount etc.? &n...
34806 Jun 2012 @ 01:26 PDTGeneralReplyHow to write FIRST_VALUE() and LAST_VALUE() window function in Teradata? also not pretty but would require no derived tables Simple example from sys_calendar. Give first and last calendar_week per calendar_date - (can be done differenty in this particular cas...
34705 Jun 2012 @ 11:27 PDTDatabaseReplyNeed help with some handy code for this situation I guess you need to explain in more detail what you want to achive. What is the rule for the split an changes in col2?
34605 Jun 2012 @ 02:30 PDTDatabaseReplyHelp with TASM and Tactical queries   There might be many other options but I guess the forum will have limited chances to help here. At least there would be some danger for your system in respect to SLAs if you just foll...
34505 Jun 2012 @ 01:50 PDTDatabaseReplyduration calculation between dates which has overlap with other date ranges for same product check dieters post on  http://forums.teradata.com/forum/general/need-help-merging-consecutive-and-overlapping-date-spans  
34404 Jun 2012 @ 10:41 PDTDatabaseReplyDelete duplicate rows from Table in Teradata database Try google search for Delete duplicate rows teradata And Carlos posted some code here: http://carlosal.wordpress.com/2009/12/07/borrando-filas-duplicadas-en-teradata/
34304 Jun 2012 @ 02:32 PDTDatabaseReplyduration calculation between dates which has overlap with other date ranges for same product so what is your expected result for this example?
34204 Jun 2012 @ 02:30 PDTDatabaseReplyaggregation error I like to quote dieter her "Whom do you believe? Your first hand experience when you actuallly tried ... or some braindumps or other dubious sources?" Try and read the docu...

Pages