#DateForumTypeThreadPost
6931 Aug 2016 @ 10:46 PDTDatabaseReplyUsing WITH Statement Modifier instead of Temp Tables?Did DR160077 get resolved?
6815 Jul 2016 @ 04:29 PDTDatabaseReplyMedian function - Fails on view when trying to cast as decimalIf I add myCol1 and myCol2 to the GROUP BY would that make the results wrong? SELECT  myDate ,CompanyName ,Median( cast( myCol1 as DECIMAL(18,3)) ) as MedianCol1 ,Median( cast( myCol2...
6715 Jul 2016 @ 04:22 PDTDatabaseReplyMedian function - Fails on view when trying to cast as decimalLooks like the problem is the data. Sometimes myCol1='0.0000' and sometimes myCol2 ='0.0000'.
6615 Jul 2016 @ 01:09 PDTDatabaseReplyMedian function - Fails on view when trying to cast as decimalAnyone?
6514 Jul 2016 @ 01:16 PDTDatabaseTopicMedian function - Fails on view when trying to cast as decimalI have a database table which has four columns and two of the columns are INT. The two INT columns' rows are sometimes empty. When I try to cast them as DECIMAL(18,3) and then use the Median f...
6429 Jun 2016 @ 02:47 PDTDatabaseTopicShapefile doesn't load the GEOM part for 1 out of 4 rows? I have a shapefile that has 4 territories. Three of the territories have a territory name and one is null because it is the row for everything that is outside of the 3 territories. The shape file ...
6321 Jun 2016 @ 12:16 PDTDatabaseTopicReduce skew on a table with Shapefile data?I downloaded this Geospatial Shapefile: https://www2.census.gov/geo/tiger/TIGER2015/UAC/   The table that was created by loading the shapefile looks like this: CREATE SET TABLE myDataba...
6216 Mar 2016 @ 11:29 PDTDatabaseReplyMerge - Without insert when not matched?Error: Target row updated by multiple source rows. In the data it is possible to have a test at the same location multiple days. Do I need to add a check for each Test_Date in the where clause and...
6116 Mar 2016 @ 11:02 PDTDatabaseReplyMerge - Without insert when not matched?Error: The search condition must fully specify the Target table primary index and partition column(s) and expression must match INSERT specification primary index and partition column(s)   W...
6016 Mar 2016 @ 10:33 PDTDatabaseTopicMerge - Without insert when not matched?I have 2 tables.   One has the test locations, columns are: Test_Date Latitude Longitude   The second table has the info about the locations, columns are: Latitude Longitude ...
5914 Dec 2015 @ 10:04 PSTDatabaseReplyEsri ArcMap - Database Connection?ArcMap can now connect to Teradata. Does anyone know what tables or views the user needs permissions to for the tables to show up in ArcMap after connecting to the Teradata database?
5802 Sep 2015 @ 08:41 PDTDatabaseTopicCreate a new user with LDAP authentication mechanism?1. What is the SQL to  create  a new user that uses  LDAP authentication mechanism? 2. If a user was created without LDAP authentication how can we change them to LDAP authenticatio...
5728 Jul 2015 @ 01:11 PDTConnectivityReplyTeradata database sizeIs the CurrentPerm in bytes?
5610 Jul 2015 @ 10:18 PDTDatabaseReplyWhy does my percentage have no values after the decimal?Why should I have to convert the INT to DEC before the percent calculation is performed?
5510 Jul 2015 @ 10:11 PDTDatabaseTopicWhy does my percentage have no values after the decimal? Why does my percentage have no values after the decimal? 1 2 ...
5409 Jan 2015 @ 12:27 PSTDatabaseReplyFeature Request - It would be nice if we could join on null without having to do extra workYes and it doesn't matter that they are identical. I am trying to re-classify all null values with as little work as possible. For example: Table 1 - Data Table Dog null Man null Pizza ...
5309 Jan 2015 @ 11:19 PSTDatabaseTopicFeature Request - It would be nice if we could join on null without having to do extra workThere are times when I want to give a custom classification to all occurances of null in a different table. It would be nice if we could join on null without having to do the extra work of a case ...
5212 Sep 2014 @ 11:06 PDTConnectivityReplyMS Visio 2010I didn't see that version 14.00.00.05 wasn't 64bit: 14.00.00.05 02 Jul 2012 tdodbc__windows_i386.14.00.00.05.zip ...
5112 Sep 2014 @ 07:24 PDTConnectivityReplyMS Visio 2010yes, even after closing and re-opening Visio
5011 Sep 2014 @ 02:40 PDTConnectivityReplyMS Visio 2010When I access the ODBC Data Source Administrator outside of Visio Teradata is in the list. Inside Visio's ODBC Generic Driver Setup, Teradata is not listed. The 13.10 Teradata GSS Client is g...
4910 Sep 2014 @ 03:50 PDTConnectivityTopicMS Visio 2010I have a new laptop with Windows 7 64bit and MS Visio 2010 64bit. How do I get Visio to see Teradata? Teradata isn't one of the Visio Database Driver options listed. Here is what I have on my...
4811 Jul 2013 @ 10:48 PDTDatabaseTopicEsri ArcMap - Database Connection?In Esri ArcMap I see how to connect to a Netezza, Oracle, SQL Server databases, but I don't see a selection for Teradata. Anyone know how to connect to Teradata for Esri ArcMap?
4726 Jun 2013 @ 08:01 PDTDatabaseTopicTeradata Driver, LDAP & Talend?Has anyone successfully used the Teradata driver with LDAP authentication in the ETL tool Talend?
4613 Jun 2013 @ 10:14 PDTDatabaseReplyJARO_WINKLER_SIMILARITY Function for Teradata?Anyone already made a UDF for the JARO_WINKLER_SIMILARITY Function?
4510 Jun 2013 @ 10:38 PDTDatabaseTopicMS Visio 2010 - Reverse Engineering Views?Has anyone successfully Reverse Engineered Teradata Views using MS Visio 2010? When I try "Reverse Engineering" the Views check box is grayed out and not selectable. Is there a dbc table...

Pages