#DateForumTypeThreadPost
1527 Apr 2016 @ 11:29 PDTToolsTopicIssues in Multiload, Insert and Update for Multiple tablesHi 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...
1402 Feb 2016 @ 02:07 PSTDatabaseReplyNeed a Help in Select statement & Update queryHere 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) ...
1302 Feb 2016 @ 01:26 PSTDatabaseTopicNeed 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...
1215 Jul 2014 @ 12:17 PDTDatabaseReplylogic for the Update statementHere, 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...
1114 Jul 2014 @ 01:23 PDTDatabaseTopiclogic 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 ...
1002 Jul 2014 @ 12:51 PDTDatabaseReplyUpdate 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...
930 Jun 2014 @ 03:30 PDTDatabaseTopicUpdate statmentHi  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...
806 Dec 2013 @ 07:38 PSTDatabaseReplyneed 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...
729 Nov 2013 @ 11:35 PSTDatabaseReplyneed 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 ...
629 Nov 2013 @ 10:35 PSTDatabaseTopicneed 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...
510 Apr 2013 @ 09:04 PDTUDATopicpulling 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 ...
428 Feb 2013 @ 07:37 PSTTeradata ApplicationsReplyinserting string value in to tableThanks 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.      
326 Feb 2013 @ 10:52 PSTTeradata ApplicationsTopicinserting string value in to tableHi 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 ...
207 Jul 2011 @ 03:35 PDTUDAReply TIMESTAMP in TeraDATA@ Velvet Elvis,@ Jimm Thanks for the Help and it Works fine .... Can u share the Link for the Doc's
106 Jul 2011 @ 04:14 PDTUDATopic TIMESTAMP in TeraDATAHi 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...