#DateForumTypeThreadPost
529 Jul 2009 @ 09:15 PDTDatabaseReplyTeradata 12 and SubqueriesBill - You should just be able to add those subqueries as derrived tables in the FROM clause, something like Select component_location_id, component_type_code, ax.location_value...
419 Oct 2006 @ 08:19 PDTUDAReplyOracle to Teradata job schedulingYou can do it, but how happy you'll be depends on the tools you have and how you want to run the job(s).If you're doing a small number of rows and have access to SQLServer, a DTS package can do it ...
305 Sep 2006 @ 03:07 PDTAnalyticsReplyAny function like Oracle "months_between"?How about select extract(month from end_date) - extract(month from start_date)+ (extract(year from end_date) - extract(year from end_date)) * 12(Not totally tested, but it seems to work for end_dat...
225 Jul 2006 @ 08:43 PDTAnalyticsReplyEquivalent of Oracle-SEQUENCE_NAME.NEXTVAL in TeradataI've only been using Teradata for a few months, so don't take this as gospel, but....The short answer is that you can't - there is no equivalent.The more nuanced answer is that you might be able to...
130 Mar 2006 @ 08:27 PSTAnalyticsReplyOracle Function percentile_discMaybe a little late, but how about something like thisSELECT inner1.*, MIN(CASE WHEN inner1.q = 49 THEN day_of_year ELSE NULL END) over() FROM (SELECT calendar_date, day_of_yea...