#DateForumTypeThreadPost
1126 Aug 2013 @ 01:05 PDTGeneralReplyNeed a function in Teradata which accepts a string and returns a integer listTry using a recusive SQL
1028 Mar 2013 @ 12:46 PDTGeneralReplyPlease convert query oracle to teradataselect address.address_id,address.state,dim_tab.src_system,di m_tab.dim_last_mdfd_dt from address left outer join dim_tab on address.address_id=dim_tab.ods_addr_id and address.state=dim_...
926 Mar 2013 @ 11:55 PDTGeneralReplyhow to find the start dates from the Transaction history I am sure you have figured out a solution by now.If not , something of this sort should work.   SELECT CUSTOMER, MIN(start_date) AS start_d, MAX(end_date) AS end_d, RANK() OVER(PARTI...
822 Mar 2013 @ 03:57 PDTDatabaseReplyMetadata information for a viewThank you
720 Mar 2013 @ 07:36 PDTDatabaseTopicMetadata information for a viewIf i query dbc.columns for a particular table within a database it gives me column data type with its length.However if i have a custom view that is build on top of lets suppose 2 tables and if i q...
602 Aug 2011 @ 04:08 PDTAnalyticsTopicHow to break a date range into 2 different rows?Hi, I have Table 1 EmployeeNo StartDt EndDt 1 1/1/09 12/31/09 1 1/1/10 ...
513 Aug 2010 @ 11:24 PDTAnalyticsReplyPassing Case Expression to a IN OperatorThanks Carlos! I was giving a different column name which is why the query was not returning anything.After the corrections the query works great.
430 Jul 2010 @ 01:38 PDTAnalyticsReplyMAX() and MAX() OVER (PARTITION BY ....) in the same query produces error 3504I don't think there is a function as dense_rank in teradata.Its there in Oracle , not in teradata.
330 Jul 2010 @ 11:03 PDTAnalyticsReplyPassing Case Expression to a IN OperatorDid you try that out ? It does not work for me. If it's a number it works fine with character it does not. Shouldn't character values be quoted in single quotes ? I tried with single quotes as ...
229 Jul 2010 @ 11:28 PDTAnalyticsReplyPassing Case Expression to a IN OperatorHi Carlos, This is an excellent solution. However you are passing numeric values , how do we do it with character values. So instead of 1,2,3 how do we use 'A','B','C' Sam
116 Jul 2010 @ 10:38 PDTAnalyticsTopicPassing Case Expression to a IN OperatorHi, How do we pass a Case expression to a IN Operator Select * from table where col1 in (case when parameter is null then Col1 else parameter) Parameter in this case has a value = 'A','B'...