#DateForumTypeThreadPost
1411 Jul 2014 @ 02:46 PDTDatabaseReplyROW_NUMBER() Problem in SUb Query delete from operations.tll_gnr_master tgm where tgm.rowid in ( select a.rowid from operations.tll_gnr_master a, operations.site b where a.site_key=b.site_key and b.brand_id='WD' and a.c...
1311 Jul 2014 @ 12:22 PDTDatabaseReplyROW_NUMBER() Problem in SUb Query select * from operations.tll_gnr_master tgm where ROW_NUMBER() OVER(PARTITION BY  a.site_key ORDER BY a.site_key) in ( select ROW_NUMBER() OVER(PARTITION BY  a.site_key ORDER BY a.si...
1211 Jul 2014 @ 12:21 PDTDatabaseReplyROW_NUMBER() Problem in SUb Query select * from operations.tll_gnr_master tgm where tgm.rowid in ( select a.rowid from operations.tll_gnr_master a, operations.site b where a.site_key=b.site_key and b.brand_id='WD' and...
1111 Jul 2014 @ 12:19 PDTDatabaseTopicROW_NUMBER() Problem in SUb Query
1027 Apr 2014 @ 11:29 PDTDatabaseReplybteq query problem.Cannot export all column to fileHi, I have written query which is actually giving undesired result. Output result: 23234,    45345,   "TeraData" Expected result: 23234,45345,"TeraData&...
925 Apr 2014 @ 08:10 PDTDatabaseTopicbteq query problem.Cannot export all column to fileHi, we trying to export SELECT * FROM TableName from db2 to flat file. By default it exports with comma as separtor and puts double quotes before and after the varchar columns.  No...
814 Apr 2014 @ 03:19 PDTDatabaseReplyDate And Add_Month query problemHi, Can you help me to run below query too. SELECT TO_CHAR(TO_DATE('07-APR-2014'),'YYYYMMDD')||'|'|| TO_CHAR((TO_DATE('07-APR-2014') + 90),'YYYYMMDD') FR...
714 Apr 2014 @ 01:25 PDTDatabaseTopicDate And Add_Month query problemHi, Can anyone help me to convert the below query in Teradata. SELECT TO_CHAR(SYSDATE-7,'DD-MON-YYYY')||'|'||TO_CHAR(LAST_DAY(ADD_MONTHS(SYSDATE,11)),'DD-MON-YYYY') FROM d...
610 Apr 2014 @ 03:35 PDTDatabaseReplyRowID issue with teradataHi doneth, If the combination is not unique then what shouldbe the query. kindly help.
509 Apr 2014 @ 05:47 PDTDatabaseReplyRowID issue with teradataHi, I know the Row_NUMBER(), but I am not able toupdatethe table. Need some help in I have written the query but its not working. Please help update TEMP FROM operations.entity_group SET TEMP.s...
409 Apr 2014 @ 05:36 PDTDatabaseReplyRowID issue with teradataHi, The above query is migrating from ORACLE to Teradata. When above query is run, its showing error ROWID doesnot exist.
309 Apr 2014 @ 05:10 PDTDatabaseTopicRowID issue with teradataHi, Can any one help me toconvert below query  into teradata.   update operations.entity_group set status = 'I' where rowid in ( select rowid ...
203 Apr 2014 @ 10:21 PDTDatabaseReplyNumber Datatype issue with TeradataHi Raja, Its just number in Teradata.  
103 Apr 2014 @ 04:25 PDTDatabaseTopicNumber Datatype issue with TeradataHi, I am facing issue when Informatica coverts Integer value to Double and this double value isnot  inserting into Number datatype column in Terdata. Source Data:20109524 Informatica Conver...