#DateForumTypeThreadPost
4912 Aug 2016 @ 12:01 PDTGeneralReplyLooking for help with regards to nested aggregatesHello.. Cant have a sub query.. actually this needs to be executed on a reporting solution and it cant allow sub queries. Also,  when you we do AVG(D) OVER (PARTITION BY A,C ORDER BY A RO...
4811 Aug 2016 @ 11:59 PDTGeneralReplyLooking for help with regards to nested aggregatesHello.. Cant have a sub query.. actually this needs to be executed on a reporting solution and it cant allow sub queries. Also,  when you we do AVG(D) OVER (PARTITION BY A,C ORDER BY A RO...
4711 Aug 2016 @ 07:55 PDTGeneralReplyLooking for help with regards to nested aggregatesHi Dieter... Any help on the above would be helpful....
4609 Aug 2016 @ 09:40 PDTGeneralReplyLooking for help with regards to nested aggregatesAlternatively, if we have to do a sub query, is that a way we can achieve a result set as below -  Find Avg within (A,C) and populate only for the first occurance of an I<> in a C<&g...
4509 Aug 2016 @ 08:58 PDTGeneralReplyLooking for help with regards to nested aggregatesHello, I need help as well on a case for nested aggregation as well.In this sample data, I need to find avg of field D over C and then sum them up over A in one query. Can it be done without sub qu...
4412 Apr 2016 @ 04:17 PDTDatabaseReplyqualify rank() over (partition.....questionHello. Thanks for your response. There could be more that 1 row per month which is causing the complexity. Any ideas?
4311 Apr 2016 @ 06:27 PDTGeneralReplyNEED HELP !! - Merging Consecutive and OVERLAPPING date spansCan I execute cte as a view? I have done it for recursive view. How do I do for this syntax?
4211 Apr 2016 @ 03:51 PDTGeneralReplyNEED HELP !! - Merging Consecutive and OVERLAPPING date spansHi Dieter, Thanks for your response. Not able to execute this as a derived table- sel distinct pstncd from( WITH cte(pstncd, effper) AS ( SELECT cast(pstncd as int) , effper FROM cte_bas...
4110 Apr 2016 @ 02:51 PDTGeneralReplyNEED HELP !! - Merging Consecutive and OVERLAPPING date spansI think, only INT works with it. How can I use it in a view? Or store its result in a table? Or use it as part of a larger query.
4010 Apr 2016 @ 09:44 PDTGeneralReplyNEED HELP !! - Merging Consecutive and OVERLAPPING date spansHi Dieter, Do you have fix the error - ""The output grouping column list does not match with input grouping list" I get the same error as well.My grpcol is varchar types. I did...
3909 Apr 2016 @ 12:55 PDTDatabaseReplyqualify rank() over (partition.....question Hello,   Need help.Need to be able to aggregate travel hrs over 12 month rolling for every state-city-traveler. And further at state-city.   Sample Data - ...
3807 Oct 2011 @ 01:45 PDTAnalyticsReplyString Search and Replace. I could create a recursive few to handle this... :)
3707 Oct 2011 @ 01:24 PDTUDAReplyDifference in output Hello,   My source column is LATIN and so is my target. I FEXPed the data from source and mloaded the data into target table on the same physical teradata server. Still I faced with...
3602 Oct 2011 @ 01:11 PDTToolsReplyMload - error 6706 Hi, Am struck with the same issue as well. My Source and Target are both Teradata databases, however they are different physical servers. I need to load data from one server to another. Both...
3502 Oct 2011 @ 01:10 PDTToolsReplyMload - error 6706 Hi, Am struck with the same issue as well. My Source and Target are both Teradata databases, however they are different physical servers. I need to load data from one server to another. Both...
3412 Aug 2011 @ 10:07 PDTToolsReplyImporting with BTEQgotcha...thanks.. :)
3312 Aug 2011 @ 10:06 PDTGeneralReplyDifference between Single Table Join Index, NUSI and Hash Index Sorry, Didnt understand that... Would it be possible to show with an example?
3211 Aug 2011 @ 03:36 PDTToolsReplyImporting with BTEQHello, I am able to import timestamp from the file successfully. However, I am not able to compare it with a timstamp field on a table. Can some please help? Here is the script:- USING IN_...
3130 Jul 2011 @ 10:10 PDTGeneralTopicDifference between Single Table Join Index, NUSI and Hash Index Hi, Really wonder how these indexes are different, which one to use and where to use. Any help would be greatly appreciated. Thanks.
3001 Jun 2011 @ 03:26 PDTUDAReplyPerformance Queries...Yes, its there...i seem to have missed it somehow...
2930 May 2011 @ 10:01 PDTUDAReplyPerformance Queries...Hi, The dbc.DBQLogTbl table has UserId in HEX Format.How can I derive the logon user name from the userid or vice versa? Regards, Ayush Jain
2810 May 2011 @ 08:23 PDTDatabaseReplyUse of a Primary IndexAnd my query results in much less than 10% of the total records in the table..
2710 May 2011 @ 08:19 PDTDatabaseReplyUse of a Primary IndexI may sound a bit crazy, the same query which I posted couple of days ago:- Sel Col1,col2,col5,col6 from tbl where col1='string' and col2 in (val1,va2) and col3=value and col7=2010 and col8...
2610 May 2011 @ 08:14 PDTUDAReplyPerformance Queries...What are their standard values for each one of CPU Time and IO operations that I should try to adhere to
2508 May 2011 @ 11:22 PDTAnalyticsReplyPercentile on MS Excel vs TeradataSeems like EXCEL performs a median at least for 50 percentile. ;)

Pages