15 | 27 Apr 2016 @ 11:29 PDT | Tools | Topic | Issues in Multiload, Insert and Update for Multiple tables | Hi Gurus,
I just need the information about the Candidate records not applied is 1 and i am not able to find the information about that.
We are pulling the data from source system(Ora... |
14 | 02 Feb 2016 @ 02:07 PST | Database | Reply | Need a Help in Select statement & Update query | Here is the correct Metadata
Create MULTISET Table T_PLANT12
(
plant_no INTEGER NOT NULL
,plant_Name CHAR(9)
,part1 CHAR(9)
,part2 CHAR(9)
,partType CHAR(9)
,MfgType CHAR(9) ... |
13 | 02 Feb 2016 @ 01:26 PST | Database | Topic | Need a Help in Select statement & Update query |
Hi Gurus,
Can anyone share the Log for this I have tried but there is no luck.
we have a Duplicate records and we are nt Deleting the Duplicat... |
12 | 15 Jul 2014 @ 12:17 PDT | Database | Reply | logic for the Update statement | Here, i got the answer from the @dnoeth in different forum and Thank you very much to @dnoeth
Your final Select was close, you just need to replace the Select part with an... |
11 | 14 Jul 2014 @ 01:23 PDT | Database | Topic | logic for the Update statement |
Hi Gurus,
Here is the Output what i have tried through the lead function, i just got the result But i need to Update the Table as below result set .
Can anyone ... |
10 | 02 Jul 2014 @ 12:51 PDT | Database | Reply | Update statment | @krishaneesh
Thanks for the Query and this is really helps me thinking in another way
i have tried this in the above query in my post works fine but i am facing the issue with Nul... |
9 | 30 Jun 2014 @ 03:30 PDT | Database | Topic | Update statment | Hi
can any one share the logic for the Update statment. i am not able to do the update records.
i want to remove the duplicate records from the table based on the Max date
site,par... |
8 | 06 Dec 2013 @ 07:38 PST | Database | Reply | need a associated select query defined from view table in teradata? | @ Khurram
Thanks.. i just tried many options and googled and finally i posted here
This is from Prod so we don’t have the administrator access
so we need to raise the request to get the de... |
7 | 29 Nov 2013 @ 11:35 PST | Database | Reply | need a associated select query defined from view table in teradata? | Here is the example i am facing the issue from SQL Assistant
Select * from View1
SHOW QUALIFIED Select * from View1
select t1.col1
,t1.col2
,t1.col3
... |
6 | 29 Nov 2013 @ 10:35 PST | Database | Topic | need a associated select query defined from view table in teradata? |
Hi Gurus,
I have an issue trying to get the associated select query (couple of tables - whole query) defined from view table in teradata?
Issue is, i am not getting the whole select query in... |
5 | 10 Apr 2013 @ 09:04 PDT | UDA | Topic | pulling all the tables and Views not using in prod since from long time in teradata | Hi Gurus,
Please help me suggesting a query to find for pulling all the tables and Views in teradata .
we have lot of backed up temp tables and views not using in prod since from ... |
4 | 28 Feb 2013 @ 07:37 PST | Teradata Applications | Reply | inserting string value in to table | Thanks guys for replying back.
The issue is single quote after 9 and this thorwing the error and the data has been fixed from the soruce after identifying the issue.
|
3 | 26 Feb 2013 @ 10:52 PST | Teradata Applications | Topic | inserting string value in to table | Hi All,
i am just trying to insert the million records if values into table but having the issues with this
i had the data in this formate 'PYE:879'-"sd4696' and i ... |
2 | 07 Jul 2011 @ 03:35 PDT | UDA | Reply | TIMESTAMP in TeraDATA | @ Velvet Elvis,@ Jimm
Thanks for the Help and it Works fine ....
Can u share the Link for the Doc's |
1 | 06 Jul 2011 @ 04:14 PDT | UDA | Topic | TIMESTAMP in TeraDATA | Hi
I am new to the Topics in Teradata and having the Column Table is
UPDATE_DTS TIMESTAMP(0) NOT NULL
and the data in the Columns is '2009-01-16 02:29:08'
i want to select th... |