#DateForumTypeThreadPost
1518 Jan 2016 @ 04:44 PSTDatabaseTopicSQL problemHi Team,   I have data like this.   Recommendation Identifier   Audience Identifier  Directory Service Identifier  Start Date    End Date   S...
1412 Jan 2016 @ 03:24 PSTDatabaseTopicHow to Surrogate key for History data maintenanceHi Team,   I have data like:-   Table A:- emp_id     first_name     lat_name      email_adr ------     &nbs...
1312 Jan 2016 @ 01:54 PSTDatabaseTopicHow to USE surrogate Key value for history maintenanceHi Team, Can any one give me an example regarding maintentance of history of data through surrogate key. Scenario:- suppose there is a user having emp_id e1 name "DRAVID".We a...
1215 Apr 2015 @ 06:57 PDTDatabaseTopicmanager Vs Emp Hi All,   I have data like this.   empno      mgr 1               2 2           ...
1101 Apr 2015 @ 09:43 PDTDatabaseReplyHow to get min and max value in a single olap query using ROW_NUMBER in teradataThanx dnoeth.This query is working fine for small volume of data but for larger volume(TD 14) i am getting this error.  *** Failure 3610 Internal error: Please do not resubmit the last r...
1030 Mar 2015 @ 09:31 PDTDatabaseTopicHow to get min and max value in a single olap query using ROW_NUMBER in teradataI have data like this. ds_id                          Version    dwn_dt ------------------------------------------...
907 May 2014 @ 09:55 PDTDatabaseReplyTERADATAHi Dnoeth Answer that you have given is not perfect. suppose i entered '2014-04-24 12:52:00' as start_dt  and '2014-04-24 13:13:00' as end_dt then  it is not g...
807 May 2014 @ 02:56 PDTDatabaseTopicTERADATA I have table like this. CREATE TABLE RUN(RUN_ID INTEGER, START_DT VARCHAR(30), END_DT VARCHAR(30)); INSERT INTO RUN VALUES(1,'24-APR-2014 12:00:00','24-APR-2014 12:05:...
727 Apr 2014 @ 11:47 PDTDatabaseReplyTD Newbie: help needed to Convert rows to a column WITH RECURSIVE MYREC(id,key2,indicator,LVL)  AS  (  SELECT id, key2,MIN(indicator(VARCHAR(1000))) AS indicator,1  FROM <table> GROUP BY 1  ...
627 Apr 2014 @ 11:34 PDTDatabaseReplyRounding down decimalsselect substr('0.9585',1,1); This will also work.
527 Apr 2014 @ 10:32 PDTDatabaseReplyHow to get sequence numbers for a particular group based on consecutive valuesIn teradata 14.20 dense_rank is available.
427 Apr 2014 @ 09:09 PDTDatabaseReplyTD Version differencesNew functio in teradata 14.20:-Dense_rank(ANSI),Median,To_number,NVL,Decode New Data type :-Number(similar to oracle 38 digit long) BLOCK Size is increased to 1 MB from 127.5 kb Compression:-Usi...
326 Apr 2014 @ 03:10 PDTDatabaseReplyRemove the first 4 characters in a stringSELECT SUBSTR(STATE,5) FROM <TABLE> ;
226 Apr 2014 @ 02:57 PDTDatabaseReplybteq query problem.Cannot export all column to file Try this: bteq << EOF      .logon abc/def,passwd     .EXPORT REPORT FILE=bteq_export_file     .SET WIDTH 3000;       &...
124 Apr 2014 @ 02:24 PDTGeneralReplyEquivalent of LISTAGG in teradataHi Nihal, The solution of asked question can be solved by recursive method.I am writing the code.Check in your system. WITH RECURSIVE MYREC(col1,col2,LVL)  AS(  SELECT col1, ...