#DateForumTypeThreadPost
1022 Oct 2014 @ 12:43 PDTDatabaseReplyIndex on UPPER(col1)Ah thanks. I'll look more into the casespecific definitions on my tables
922 Oct 2014 @ 10:01 PDTDatabaseTopicIndex on UPPER(col1)I discovered last night from UseTheIndexLuke that if there's an index on col1 and an often-used query uses UPPER(col1), the index will not be used because UPPER(col1) is not the same as co...
815 Oct 2014 @ 11:06 PDTDatabaseTopicTarget row is being updated by multiple source rows in an Update statementI have an update statement directly referencing one table and a second one through a SELECT statement. That second table (CONTACT_TEMP) is created to hold no duplicates  based on the EMAIL fi...
730 Sep 2014 @ 10:02 PDTDatabaseTopicHow exactly do I fix an error related to 'untranslatable character'I've found several posts regarding the same topic of an untranslatable character, but don't know how to fix the problem.   Both my target and source tables have Latin encoding on the...
625 Sep 2014 @ 01:42 PDTDatabaseReplySyntax error in an UPDATE statementThanks, looks like that got me past the syntax error.   Now, I'm getting an error saying that I don't have enough spool space. I ran the select statement separately without any error...
525 Sep 2014 @ 11:34 PDTDatabaseTopicSyntax error in an UPDATE statementI have the following UPDATE statement in which I'm getting syntax errors pointing to the line right above the FROM clause. The error from Teradata is: Syntax error: expected something betwee...
423 Sep 2014 @ 10:34 PDTDatabaseReplySelecting all rows that have a unique columnAwesome, that's exactly what I need. Thanks!
323 Sep 2014 @ 09:31 PDTDatabaseReplySelecting all rows that have a unique columnHi Dieter, From what I've learned and verified, DISTINCT will filter based on all the columns in the SELECT clause. So in the little code snippet you wrote out, the query would return all rows...
223 Sep 2014 @ 08:33 PDTDatabaseReplySelecting all rows that have a unique columnVlad, The partition function is almost what I need. Because of the `= 1`, the statement is filtering out the partitions or IDs that have a count of greater than 1. I still want those rows, but jus...
122 Sep 2014 @ 02:36 PDTDatabaseTopicSelecting all rows that have a unique columnI have raw data coming into a table for an ETL job, so I'd like to keep all the records. I'm trying to select all the rows that basically have a unique ID. This can obviously be resolved b...