#DateForumTypeThreadPost
521 May 2014 @ 12:21 PDTDatabaseReplyGroup Concatenation in TeradataFrom StackOverflow.  For TD 13 http://stackoverflow.com/questions/23741925/aggregation-by-timestamp/23770295?noredirect=1#23770295 CREATE VOLATILE TABLE vt AS ( SELECT id ...
419 May 2014 @ 12:46 PDTDatabaseTopicGroup Concatenation in TeradataI have a query that results in data containing customer id numbers, marketing channel, timestamp. So, the results might look something like this. id marketingChannel TimeStamp 1 SEO ...
313 May 2014 @ 11:59 PDTDatabaseTopicString Functions I'm looking to split a string in Teradata.   The table might look something like this.      column1 hello:goodbye:afternoon I'm trying to u...
203 Apr 2014 @ 07:31 PDTDatabaseReplyMERGE INTO and CONCATENATIONYes, I've tried that and it works.  I believe that the SET expression in MERGE INTO doesn't support concatenation.  http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#...
102 Apr 2014 @ 12:56 PDTDatabaseTopicMERGE INTO and CONCATENATION So, I'm not sure why this statement isn't working properly. MERGE INTO table1 as a USING table2 as b ON a.date = b.date AND a.id = b.id WHEN MATCHED THEN UPDATE SET col2 = C...