#DateForumTypeThreadPost
1901 Oct 2014 @ 12:07 PDTDatabaseReplyFinding PI for a table created alreadyThank you Fred :) and thank you all for your valuable suggestion :)
1828 Sep 2014 @ 11:46 PDTDatabaseTopicFinding PI for a table created alreadyHi All, I have tables which are already created in DB. Almost half the tables are having more skewness. Now, I need to change PI for those tables which are having high skewness. Instead of checkin...
1715 Nov 2013 @ 10:48 PSTDatabaseReplyRecursive QueryHi Dieter, Thanks for the suggestion. The data type for A.ACT_DATE is VARCHAR. I don't know why they have defined a date column as varchar field. But we have to code according to that :)...
1612 Nov 2013 @ 03:38 PSTDatabaseReplyRecursive QueryHi Khurram, The actual condition is, for a particular DND value if the correspoding rec1 value is 0 then latest_dnd should be dnd only. Consider the set of values i have provided as sample. ...
1512 Nov 2013 @ 12:55 PSTDatabaseReplyRecursive QueryI have tried this using many left outer joins. But the hierarchy level wouldn't change for some records. Dont know how to overcome that issue. Any help would be much appreciated. SELECT ...
1411 Nov 2013 @ 05:12 PSTDatabaseReplyRecursive QueryHi Dieter, Actually this is a hierarchy method. Below are a sample data. DND_NO REC1 LATEST_DND 100 200 300 200 300 300 300 0 300 400 500 800 500...
1309 Nov 2013 @ 06:22 PSTDatabaseReplyRecursive QueryHi Dieter, The data in DND_XREF_TEMP looks like, ACT_DATE                  REC1  CC         DND_NO 12/31/2020 0:0...
1209 Nov 2013 @ 02:59 PSTDatabaseReplyRecursive QueryKhurram, Actually I have to modify my code using recursive query. This is my actual query which is not working as expected. So my friend suggested me to use recursive query which is new to me. So...
1109 Nov 2013 @ 02:19 PSTDatabaseReplyRecursive QueryHi Khurram, My scenario is CASE WHEN  ( B.REC1 IS NULL OR B.REC1 =0) THEN LATST_DND --this was derived from other case stmt else B.REC1 END AS LATESTDND my sample data would like below...
1009 Nov 2013 @ 12:08 PSTDatabaseTopicRecursive QueryHi All, Can you please let me how recursive query works for more than 2 tables. As per my understanding with the syntax, we can take only one source table and the other would be recursive table. M...
928 Oct 2013 @ 03:36 PDTDatabaseReplyTranspose rows to columnsThanks for the kind help Dieter :)
825 Oct 2013 @ 06:46 PDTDatabaseReplyTranspose rows to columnsThank you Dieter. Your suggestion helped me :) I have one doubt. It will lead to product join if I use cross join rite? Won't that be a problem?
724 Oct 2013 @ 11:38 PDTDatabaseReplyTranspose rows to columnsHi, Can anyone help me in this scenario please.
624 Oct 2013 @ 01:33 PDTDatabaseReplyTranspose rows to columnsHi Raja, Am sure that my column limit would be < 50. But its the record count am worried about which am not sure. I need diffrent approches to perform transpose operation to convert rows to col...
523 Oct 2013 @ 10:35 PDTDatabaseReplyTranspose rows to columnsHi James, If you dont mind, can you post your code here. So that I'll be able to understand it more clearly.
423 Oct 2013 @ 11:52 PDTDatabaseReplyTranspose rows to columnsHi Dieter, Thanks for the suggestion. Will this code work for >1 million records? Any help is greatly appreciated.
323 Oct 2013 @ 07:43 PDTDatabaseReplyTranspose rows to columnsThanks James, for your timely reply. But the data I have provided is just a sample one. I know this could be done using union. But i have huge number of data, also using union would affect the perf...
223 Oct 2013 @ 07:15 PDTDatabaseTopicTranspose rows to columnsHi All, I'm new to TD. I need to transpose data from rows to columns. I'm not sure how to do it using PIVOT in teradata. Can anyone help me. Sample input data. ID Name English ...
108 May 2013 @ 11:48 PDTDatabaseTopicAvoid Error 3519 in stored procedureHi, I have a created a stored procedure with many volatile tables. After calling the proc, the volatile tables will be dropped at the end of the procedure. But if i get any error while calling the...