#DateForumTypeThreadPost
923 Mar 2016 @ 12:47 PDTGeneralReplyinterview helpPlease share them @ chinmay.teradata@gmail.com. Thanks for your help. 
823 Mar 2016 @ 12:39 PDTGeneralReplyneed update logicThe below select query will give you the desired output, let me know if this doesn't work. SEL  SEQ_NBR ,M_SYS_DT AS EFF_STRT_DT ,COALESCE(MAX(M_SYS_DT) OVER (ORDER BY SEQ_...
723 Mar 2016 @ 12:04 PDTGeneralReplySelect data from char position to the nextCheck if this works. SEL SUBSTR('/a/bbb/cc/aaa/ddd', INSTR ('/a/bbb/cc/aaa/ddd' , '/',1,2)+1,  INSTR ('/a/bbb/cc/aaa/ddd' , '/',1,3) - INSTR ('/a/b...
622 Mar 2016 @ 11:43 PDTGeneralReplyFill Missing Rows With DataHi, Please check if this works. SEL * FROM Table1 ORDER BY 1,2; SessionId Old_Col 1   1   ...
522 Mar 2016 @ 03:12 PDTDatabaseReplyGet actual column name not alias via DBC/system tablesBelow query will provide the actual column name  SEL TableName, ColumnName FROM DBC.COLUMNS WHERE TableName = 'T_NAME' AND DatabaseName = 'DB_NAME' ORDER BY ColumnId;
422 Mar 2016 @ 02:47 PDTDatabaseReplyTransposing Rows to ColumnsCheck if this works for you.  SEL A.NAME AS Actor, D.NAME AS Doctor, P.NAME AS Professor, S.NAME AS Singer FROM  (SEL NAME, RANK() OVER(PARTITION BY OCCUPATION ORDER BY NAME ASC) ...
314 Jan 2008 @ 12:11 PSTDatabaseTopicExport to Excel Or XMLHi, Can any one tell me is it possible to export the result of query in to Excel sheet or XML. If yes please give me a brief idea. I want this process to be automated, ie if i give the query th...
203 Oct 2007 @ 02:05 PDTDatabaseReplyWhat is dynamic sqlThanks a lot.
128 Sep 2007 @ 11:06 PDTDatabaseTopicWhat is dynamic sqlHI can any one explain me what is dynamic sql in teredata.is it the sql we write and run in sql assistant or any thing different?thanks in advanceChinmay