#DateForumTypeThreadPost
1123 Apr 2014 @ 07:20 PDTDatabaseReplyFinding the latest dateThanks Dieter for the response.  What I am trying to do is query each table so that I may return the latest or most up to date data.   Each night the tables are updated and each reco...
1022 Apr 2014 @ 07:33 PDTDatabaseTopicFinding the latest dateHi Everyone! Aggregates cannot be used in WHERE clauses and I am trying to find a way to return the latest data  according to date (GRIP_DT).  To explain, within each table there are vie...
911 Apr 2014 @ 04:02 PDTDatabaseReplyConversion of Oracle's CONNECT BY...STARTING WITH to TeradataRecursive queries?  Where can I find this on here?  Thanks.
810 Apr 2014 @ 06:37 PDTDatabaseTopicConversion of Oracle's CONNECT BY...STARTING WITH to TeradataHi, I am looking for the equivalent function to Oracle's CONNECT BY clause to generate an organization hierarchy chart.... SELECT DISTINCT  ORGUNIT_CODE  FROM ORG_UNT  WHE...
706 Apr 2014 @ 02:06 PDTDatabaseTopicIs there an equivalent to the FIRST function? SELECT DISTINCT‘ ON GOING’ AS RPT_TYPE , CURRENT_DATE – CAST(b.TIMESTMP AS DATE) AS AGING , D.NAME AS CATEGORY , B.STATUS_ID AS “TYPE” ,INCIDENT_ID AS INCID...
605 Apr 2014 @ 05:21 PDTDatabaseReplyTo UNION OR Not to UNIONHi Adharssh! I apologize for the delay in responding.   This query works.  The Warnings and Bureau table do not have the same Incident ID.  Thanks a lot for helping me out!&nbs...
501 Apr 2014 @ 08:19 PDTDatabaseTopicTo UNION OR Not to UNION SELECT DISTINCT ‘ ON GOING’ AS RPT_TYPE , CURRENT_DATE – CAST(b.TIMESTMP AS DATE) AS AGING , D.NAME AS CATEGORY , B.STATUS_ID AS “TYPE” , A.WARNING_ID AS INCIDE...
420 Mar 2014 @ 09:10 PDTDatabaseReplyCreating a Cross Tab Ah yes. Very nice.  Thanks jnevil!  If I wanted to then summarize the report by saying team red, green and blue are Operations.  Then team black, yellow and orange are Management. &n...
319 Mar 2014 @ 10:51 PDTDatabaseTopicCreating a Cross Tab Essentially what I would like to do is summarize data that I have in a CTE in which a sample of the data is the  following: TEAM     TYPE   AGE      AGE_BUCKET &...
210 Mar 2014 @ 06:19 PDTDatabaseReply3754: Precision Error Float type constant or during implicit conversionsThanks for the help Fred.  It looks like the join with enty_key to alert_id has a varchar to decimal relationship.  I just performed a cast to make the join equal.  So were right on ...
104 Mar 2014 @ 06:33 PSTDatabaseTopic3754: Precision Error Float type constant or during implicit conversionsHi, I am hopeful that someone can help with this code I am trying to execute.   The 3754 error prevents me from getting records for some reason that I cannot grasp.  Here is the cod...

Pages