14 | 11 Jul 2014 @ 02:46 PDT | Database | Reply | ROW_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... |
13 | 11 Jul 2014 @ 12:22 PDT | Database | Reply | ROW_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... |
12 | 11 Jul 2014 @ 12:21 PDT | Database | Reply | ROW_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... |
11 | 11 Jul 2014 @ 12:19 PDT | Database | Topic | ROW_NUMBER() Problem in SUb Query | |
10 | 27 Apr 2014 @ 11:29 PDT | Database | Reply | bteq query problem.Cannot export all column to file | Hi,
I have written query which is actually giving undesired result.
Output result:
23234, 45345, "TeraData"
Expected result:
23234,45345,"TeraData&... |
9 | 25 Apr 2014 @ 08:10 PDT | Database | Topic | bteq query problem.Cannot export all column to file | Hi,
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... |
8 | 14 Apr 2014 @ 03:19 PDT | Database | Reply | Date And Add_Month query problem | Hi,
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... |
7 | 14 Apr 2014 @ 01:25 PDT | Database | Topic | Date And Add_Month query problem | Hi,
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... |
6 | 10 Apr 2014 @ 03:35 PDT | Database | Reply | RowID issue with teradata | Hi doneth,
If the combination is not unique then what shouldbe the query.
kindly help.
|
5 | 09 Apr 2014 @ 05:47 PDT | Database | Reply | RowID issue with teradata | Hi,
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... |
4 | 09 Apr 2014 @ 05:36 PDT | Database | Reply | RowID issue with teradata | Hi,
The above query is migrating from ORACLE to Teradata.
When above query is run, its showing error ROWID doesnot exist.
|
3 | 09 Apr 2014 @ 05:10 PDT | Database | Topic | RowID issue with teradata | Hi,
Can any one help me toconvert below query into teradata.
update operations.entity_group set status = 'I'
where rowid in (
select rowid ... |
2 | 03 Apr 2014 @ 10:21 PDT | Database | Reply | Number Datatype issue with Teradata | Hi Raja,
Its just number in Teradata.
|
1 | 03 Apr 2014 @ 04:25 PDT | Database | Topic | Number Datatype issue with Teradata | Hi,
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... |