#DateForumTypeThreadPost
913 May 2011 @ 05:01 PDTDatabaseTopicUpdate Set by SubqueryI am very new to SQL and hope somebody can be of assistance. I have tried doing a search on the Forum for “Update Set by Subquery” but the results I found were too difficult for me to follow. H...
809 May 2011 @ 09:44 PDTDatabaseTopicDealing with Duplicates. I have a large table which contains some duplicate records (on accnt_num ). I do not just want to just dedupe the table as work need to done on those duplicate accounts. Ideally I want to cre...
706 May 2011 @ 05:25 PDTDatabaseReplyDrop / Delete tables in bulkJim Unfortunately there are many other databases in this directory. Jimm thank you for all of your work on this, but unfortunately the Monday table is not always the first working day of ...
605 May 2011 @ 01:51 PDTDatabaseTopicDrop / Delete tables in bulkWe have a large drive that is badly in need of house keeping. There are a large number of daily tables named as A_EXM20090101 A_EXM20090102 A_EXM20090103 etc through to A_EXM20110503 A...
521 Apr 2011 @ 03:06 PDTDatabaseReplyDescribe tableThank you Show Table is just what i was after
419 Apr 2011 @ 07:57 PDTDatabaseTopicDescribe tableIn SAS sql there is a command "describe table" which gives information about the table in question. Is there a similar command in Teradata sql.?
316 Mar 2011 @ 10:41 PDTDatabaseReplyLink tables and timestamp datePerfect Kostek, thank you just what i needed
215 Mar 2011 @ 11:21 PDTDatabaseTopicLink tables and timestamp dateIn simple English I have 2 tables, I wish to compare them by date and any new records in table 1 to be appended to table 2. For the sake of example Table1 has 2 fields Cust_Ref and load_date (ti...
102 Dec 2010 @ 09:53 PSTDatabaseTopicCount and Sum by MonthI need to summarise some records for this year, by the number of entries and their value.Split by month. The issue i have is that each entry is listed by date and not by month. Could somebody pleas...