#DateForumTypeThreadPost
1505 Mar 2015 @ 01:28 PSTDatabaseTopicHow to get the statement used to updated/populate a tableHi, Is there a way I can check how the table has been updated. I mean I can get the DDL by using "Show table database.Tablename" but what I want to know is what was the select statement...
1404 Dec 2014 @ 09:54 PSTDatabaseReplyFilter results from two joinsAre you getting 0 rows as a result of this query ? If yes: May be the Max(event_dtm) value does not lie in the date ranges you selected for startclock_day. So I would suggest  Sel * from&nb...
1317 Nov 2014 @ 07:50 PSTDatabaseReplyUse of CTE within stored proceduresThanks a lot!! It works now!!
1214 Nov 2014 @ 03:56 PSTDatabaseReplyUse of CTE within stored proceduresHi, I have this query, which executes fine. INSERT INTO workdb.delq_pool_final2 SELECT pool_id, age, SUM(prin_loan_bal)/SUM(orig_pool_amt) AS pool_factor, ...
1107 Nov 2014 @ 01:58 PSTDatabaseReplyCumulative Average where the partition are overlapping (Moving Avg.)Thanks a lot Dieter!! Its very helpful!!  
1007 Nov 2014 @ 05:58 PSTDatabaseReplyCumulative Average where the partition are overlapping (Moving Avg.)Thanks for this information Walter! Now I know I should not waste anymore time in getting this thing done in a single query. There is one concernt though... I have to save this query as a macro w...
906 Nov 2014 @ 03:02 PSTDatabaseReplyCumulative Average where the partition are overlapping (Moving Avg.)Thanks Walter!
806 Nov 2014 @ 08:17 PSTDatabaseReplyCumulative Average where the partition are overlapping (Moving Avg.)In fact I also tried Avg (amount) over(partition by (extract(year from current_Date)*100 + extract(month from current_date)) >= ((extract(year from month)-1)*100+12) order by month rows betwe...
706 Nov 2014 @ 06:37 PSTDatabaseReplyCumulative Average where the partition are overlapping (Moving Avg.)Thanks Raja! About the solution since it was an example only, The data I have has more than 20 years. and I am trying to use   Avg (amount) over(order by month rows between (extract(month...
605 Nov 2014 @ 08:58 PSTDatabaseReplyCumulative Average where the partition are overlapping (Moving Avg.) Month       Amount     Avg amt Dec-12    50495    50495             Jan-13    55023...
505 Nov 2014 @ 06:51 PSTDatabaseTopicCumulative Average where the partition are overlapping (Moving Avg.)Need help on how to get moving average. Please suggest.   Thanks!
410 Oct 2014 @ 07:21 PDTDatabaseReplyImport data from excel in a stored procedure / macroThanks Raj! Yes, you understood it correct. This is what I need exactly. " read an excel file in a stored proc or macro. and do something.... and deliver to ssrs......" The artical...
309 Oct 2014 @ 01:19 PDTDatabaseReplyImport data from excel in a stored procedure / macroNo answers :(
208 Oct 2014 @ 10:47 PDTDatabaseTopicImport data from excel in a stored procedure / macroI need to import data from an excel file that is updated randomly sevral times a month. I just need to import the file once everymonth and have to do it as a part of query which is to be used as a ...
107 Oct 2014 @ 09:34 PDTDatabaseReplyHow to get data from Excel to Teradata table without using teradata olap connectorCan we import data from excel using a query in SQL assistant? I need to create a stored procedure or macro that can import data from an excel file that is updated every month. Can not do it from G...