#DateForumTypeThreadPost
3615 Oct 2014 @ 06:25 PDTDatabaseReplySeparation of columns into rowsThanks Dieter.  I will use and learn about this solution.
3514 Oct 2014 @ 07:36 PDTDatabaseReplySeparation of columns into rowsHi Dieter... The version of Teradata I have is 13.10 with a SQL Assistant of 14.01.   I don't have permissions to create tables so if I need a table, it would have to done as a CTE.. ...
3410 Oct 2014 @ 10:55 PDTDatabaseReplySeparation of columns into rowsThanks Raja for this.  I do not understand how the sys.calendar figures into this solution.  Also the portion of the code where you have: -character_length(regexp_replace(demog,'[^A-...
3310 Oct 2014 @ 07:44 PDTDatabaseTopicSeparation of columns into rowsHi, I am trying to find an easy way to transform data in a field to rows.     For example,   ID             ...
3228 Aug 2014 @ 02:16 PDTDatabaseReplyQUERY CHALLENGE - FIND CUSTOMERS WHO HAVE SPECIFIC PRODUCTSHi Dieter, But does this query exclusively find the customers that have products 11 or 12 and nothing else?  It seems that within the subquery you are just seeking customers that do not have ...
3128 Aug 2014 @ 10:17 PDTDatabaseTopicQUERY CHALLENGE - FIND CUSTOMERS WHO HAVE SPECIFIC PRODUCTSHi Everyone    I am trying to find a way to return client no's that exclusively have a product(s).  Let's say the product numbers are 1 and 2.   They customer can...
3021 Aug 2014 @ 09:56 PDTDatabaseReplyThis SELECT Failed 2616. ERROR is puzzling!This is excellent Dieter!  It works!  Thanks a million decimal 99999999999!
2921 Aug 2014 @ 07:57 PDTDatabaseReplyThis SELECT Failed 2616. ERROR is puzzling!Dieter, you're right once again! The calculation does indeed work but now I show just integers for the calculations and no decimals!  Any idea of how I can get the decimals?
2820 Aug 2014 @ 09:13 PDTDatabaseReplyThis SELECT Failed 2616. ERROR is puzzling!Thanks Dieter.  Dashboard Report is the  CTE and there are no errors there.  I cannot test a single Sum to check because I have 11 products (columns) x 9 key performance indicators (...
2720 Aug 2014 @ 11:36 PDTDatabaseReplyThis SELECT Failed 2616. ERROR is puzzling!There is not a numeric column being aggregated.  I am summing based upon the conditions being satisfied in the CASE statement.  
2620 Aug 2014 @ 09:00 PDTDatabaseReplyThis SELECT Failed 2616. ERROR is puzzling!RGLASS, THE DATATYPE OF THE COLUMN IS VARCHAR.
2520 Aug 2014 @ 08:12 PDTDatabaseTopicThis SELECT Failed 2616. ERROR is puzzling!Hi Everyone,   I try to find my answer in the different threads regarding this error and I still have the 2616 error.  I am doing a dashboard for different products and looking to ...
2425 Jul 2014 @ 06:14 PDTDatabaseTopic6932 ERROR: Multiple With StatementsHi, Does anyone have a fix for multiple WITH statements?  It seems that in Version 13 does not like this.    This is the error that I get:  SELECT Failed 6932: Multiple WI...
2317 Jul 2014 @ 06:56 PDTDatabaseReplyHow to Query between two tables involvng timestampsNo primary keys in this table (believe it or not).   There are FK which relate to a User table.
2216 Jul 2014 @ 05:10 PDTDatabaseTopicHow to Query between two tables involvng timestampsHi, I want to know how I should write this query between two tables:  The first is a document table with all the names of attachment files.  It's structure would be as follows: TBL....
2115 Jul 2014 @ 04:10 PDTDatabaseReplyChecking for Null Values to Make ComparisonsHi Dieter,  Because of the comparison of NULLs is unknown, I am fine with that.  Essentially nothing = nothing.   The query above is a snippet of the overall query:  Essentiall...
2015 Jul 2014 @ 09:40 PDTDatabaseTopicChecking for Null Values to Make ComparisonsHi, What is the best structure to cover all possibilities of NULL between two fields?   I am comparing to two fields to see that they are different; however if either of the fields is NU...
1927 Jun 2014 @ 09:47 PDTDatabaseTopicChecking for difference in StringsHi, I have a query in which I check between two values (Original and New) to see if there has been a change/update has been made to a record. Essentially I am just comparing the fields:...
1820 Jun 2014 @ 08:11 PDTDatabaseTopicAdding Values across multiple columnsHello,  Is it possible to have values for Teams added across columns?  Please look at the table below: <!DOCTYPE html> <html> <head> <style> table,th,td ...
1716 Jun 2014 @ 10:38 PDTDatabaseReplyFinding the difference between two records in a table.Raja, will this actually show the difference between one record to another?  I am looking to identify the differences and perhaps identify the columns in which the differences occur.   ...
1612 Jun 2014 @ 01:31 PDTDatabaseReplyFinding the difference between two records in a table.Thanks Raja for the response.  From this point, how would I identify the columns in which the information changed?   Thanks.
1511 Jun 2014 @ 07:29 PDTDatabaseTopicFinding the difference between two records in a table.Hi Everyone, Here's the challenge:  Within a table, I have client profiles.  There are two profiles:  The last update of the profile and then the previous update of the profile....
1411 Jun 2014 @ 06:27 PDTDatabaseReplyFailed 3607: Too many expressions in the select list of a queryThanks for the reply WAQ.  Great help.
1305 Jun 2014 @ 07:53 PDTDatabaseTopicFailed 3607: Too many expressions in the select list of a queryHi Everyone, I am trying to simplify a query that has a couple of subqueries.  Primarily the main subquery (outer) is what I am challenged with at this time.  Although the error code is ...
1201 May 2014 @ 06:55 PDTDatabaseTopicSELECT Failed 2665: Invalid DateHi Simply I am trying to return data between two date extremities.  The entity used is a timestamp and I have converted it to a date, but I this SELECT Failed 2665 error persists.  The o...

Pages