10803 Jan 2013 @ 12:04 PSTDatabaseReplyCollect statsWhat is the issue?
10721 Dec 2012 @ 07:37 PSTDatabaseReplyTransposed multiple rows into one column and one rowIt's always nice to share your solution (like SQL) so that other can get benfit from the same.
10619 Dec 2012 @ 10:28 PSTDatabaseReplyMerge SQL Duplicate Key errorI mean are you getting duplicate contact_object_id in a file?
10519 Dec 2012 @ 10:27 PSTDatabaseReplyMerge SQL Duplicate Key errorOne quick question, are you getting the same contact_object_id more than one in a particluar file?
10419 Dec 2012 @ 10:22 PSTDatabaseReplyTransposed multiple rows into one column and one rowTry using recursive SQL.
10327 Nov 2012 @ 04:03 PSTDatabaseReplyConvert the strings into Date FormatWell one workaround is that if you know that your date would be in specifc formats like YYYY/MM/DD, YYYY-MM-DD etc then u can use:   create volatile table te ( date_t varchar(12) ) on c...
10227 Nov 2012 @ 03:21 PSTDatabaseReplyConvert the strings into Date FormatHi Mathuram, As you already mentioned, it can not be done in a query because the format of your data is not consistent. You can certainly go for workarounds, if you want.
10107 Nov 2012 @ 11:07 PSTDatabaseReplyTemporal Macro / Dynamic SQL in a ViewDo you want to parameterized the WHERE clause in the query?
10006 Nov 2012 @ 11:00 PSTDatabaseReplyNeed help with selecting distinct event date within last 180 daysFirst of all correct this statement in the query: B.CreatedDate Between 'Jan 10 2009' AND 'Nov 06 2012' You are not comparing createdDate with the actual DATES. Cast Jan 10 2009...
9906 Nov 2012 @ 10:52 PSTDatabaseReplyTemporal Macro / Dynamic SQL in a ViewYou can create a parameterized macro which can take the date parameter from you. If you are just running the query manually in SQL assistant and want to make the query dynamic so that everytime it...
9806 Nov 2012 @ 10:43 PSTGeneralReplyRecursive sqlPlease provide the DDL and DML Also please help me understanding your issue. So if you omit 100 then your output would be: 105  106 500  100 450  500 500  600 It would be ...
9705 Nov 2012 @ 11:56 PSTDatabaseReplyPurge the work tables cretaed a month before and create report with the list of work tables created last monthHi terankit, Use the query provided by Ulrich. It will give you the desired result.
9605 Nov 2012 @ 06:36 PSTDatabaseReplyPurge the work tables cretaed a month before and create report with the list of work tables created last monthTry using recursion.
9530 Oct 2012 @ 12:43 PDTDatabaseReplyHow to use TPT for loading all the fields of a file in a single column in a tableProbably if you skip the textDelimeter, it will pick the row as one column and insert the data into your desired column. Don't have tpt installed so can't test.
9423 Oct 2012 @ 10:15 PDTDatabaseReplyHelp with SQLIts always good to provide the DDL's and DML's in order to get the resolution quickly.
9316 Oct 2012 @ 03:38 PDTGeneralReplyForum email notifications temporarily disabledOkay sure. Thanks.
9212 Oct 2012 @ 01:55 PDTGeneralReplyLogon errors differenceI think the first one is referring to invalid username or password input by the user while later is referring that account has locked and needs to be unlocked.
9103 Oct 2012 @ 10:08 PDTGeneralReplyTable exists and shows in dbc.tablesize but not showing in dbc.tablesI don't think that comma is allowed in the table names. I tested the following queries on Teradata 12 and the first CREATE query didn't execute while the later worked having the only d...
9002 Oct 2012 @ 12:47 PDTGeneralReplyTable exists and shows in dbc.tablesize but not showing in dbc.tables I was looking for tables with comma ',' added to the table name: I couldn’t find the tables using the below query sel * from dbc.tables where databasename=<dbna...
8928 Sep 2012 @ 06:45 PDTDatabaseReplyShow Whole Business WeekCan you explain a bit more about your tab_calendar_date table? Hows does it look like? Do you have weekly intervals present in that table?
8828 Sep 2012 @ 01:36 PDTGeneralReplyPosting topics into the correct forum- General SQL and database question goes under "Database" section. - Always start a new thread to get your question answered instead of using the existing thread.
8726 Sep 2012 @ 03:35 PDTGeneralReplyForum email notifications temporarily disabledHumm, then this is something which admin needs to look into in. Neilotoole, do you have any idea why is not working for me?
8626 Sep 2012 @ 12:56 PDTGeneralReplyForum email notifications temporarily disabledOkay. Well I am more interested in receiving email notifications only for the posts in which I am participating. Is it working for you? If yes then are you using the same profile setting as mine?
8525 Sep 2012 @ 06:24 PDTDatabaseReplyHelp in Recursive query requiredSo your ouput for this string would be something like this? 1   A|B|C|D|E| 2   A|B|C|D| 3   A|B|C| 4   A|B| 5   A|
8425 Sep 2012 @ 04:53 PDTDatabaseReplyHelp in Recursive query requiredHope this will help you. http://forums.teradata.com/forum/database/deconcatenation-of-column-into-multiple-columns-0