#DateForumTypeThreadPost
724 Nov 2009 @ 12:33 PSTAnalyticsReplyHow to calculate 90th percentile in Teradatathis is what i use. ansi, so you can use it in oracle or td. can easily be expanded out to give you the entire distibution should you want.SELECT col, MAX(CASE WHEN percentile <=10 THEN pct...
624 Nov 2009 @ 12:15 PSTDatabaseTopicFirst attempt at a stored procedure. cant quite figure it out.this is my first attempt at using store procedures in TD. ive gotten it down to a single error message, but i cannot seem to resolve this final one. would appreciate any help. i am 99% sure it i...
503 Nov 2009 @ 03:36 PSTDatabaseReplyrank() (partition by....) helpthanks guys. sort of combined the two solutions to get to what i was wanting. appreciate the help.
403 Nov 2009 @ 03:36 PSTDatabaseTopicFASTLOAD ERROR 34: fread errorI am using the Express Edition software on my laptop and have been receving this error today for some reason unbeknownst to me. I am 99% sure this exact script ran without issue last week. I cann...
327 Oct 2009 @ 07:24 PDTDatabaseReplyrank() (partition by....) helpthanks jim! so there were actually 2 parts to the question. i was hoping that would help with both, but alas i am still having an issue. the second part is more complicated, but is the same gene...
227 Oct 2009 @ 09:56 PDTDatabaseReplyrank() (partition by....) helpthanks. that is exactly what i want to do, but it is not allowed within the rank function. i just noticed the forum cut off some of my code. i wanted to bold it, but instead it got deleted. the...
123 Oct 2009 @ 05:53 PDTDatabaseTopicrank() (partition by....) helpi am trying to come up with a way to rank and have the ability to window using the rows function. i know that neither the rank nor the percent_rank functions allow you to specify the rows to windo...