#DateForumTypeThreadPost
708 Aug 2014 @ 12:41 PDTAnalyticsReplyGenerate a automated Nested CASE STATEMENT using entries from a tableyou actually do not need an account for github, but you will need to do some tweaking to the code once you have it .  My computer where the code was located died 5 days ago I just got it fixed...
601 Aug 2014 @ 01:48 PDTAnalyticsReplyGenerate a automated Nested CASE STATEMENT using entries from a tableI wrote a script in python that solves your problem.  I had the same one.  its on my github. you will not be able to use it unless you have semantic programming knowledge.  I am...
501 Aug 2014 @ 01:40 PDTAsterReplyQuick NPATH questionHaving duplicate dates (or even date times) would not cause rows to be skipped. Be aware, however, that the order of the output is not guaranteed. Let's look at some example data:   othe...
431 Jul 2014 @ 07:21 PDTAsterTopicQuick NPATH questionHi guys,   I have been searching around and cannot seem to get a straight answer to my question. Thanks in advance for the time!   I had a quick question about Npath.  When one u...
311 Jul 2014 @ 12:34 PDTDatabaseTopicConditional CASE statement inside an INSERT TO statement Hi guys, How can I achieve something like this...   insert into DB.table (NEWorEMPTYCOL) values (   case     when certain_attribute_in_table like 'val' th...
211 Jul 2014 @ 11:17 PDTDatabaseReplyMapping Values from many to one relationship to a one to one relationshipThank you for the Quick response, I actually just wrote a script in python that generated SQL according to my specidications thanks though.  The script will be hosted at a Web app soon for oth...
109 Jul 2014 @ 11:29 PDTDatabaseTopicMapping Values from many to one relationship to a one to one relationshipHi Guys,   I am brand new to Teradata and writing advanced queries (with data munipulation).  I just got out of school. I have a column with a corporate code and a column with a d...