Pages
![]() |
Hi,
26 Oct 2014
| 11 comments
,
|
![]() |
This presentation demystifies usage of OLAP Analytics function for TD 15.0 and previous releases.
15 Oct 2014
,
|
![]() |
Can someone elaborate on the SQL SECURITY INVOKER option in stored procedures? I need to create a stored procedure and ensure the privilege(i.e. the privilege on the underlying database objects inside the procedure) of the user calling the procedure is always checked and I think the SQL SECURITY INVOKER option achieves that.
06 Oct 2014
| 4 comments
,
|
![]() |
I've found several posts regarding the same topic of an untranslatable character, but don't know how to fix the problem.
30 Sep 2014
| 2 comments
,
|
![]() |
Hello,
25 Sep 2014
| 2 comments
,
|
![]() |
Hi,
16 Sep 2014
| 8 comments
,
|
![]() |
Hi. I am receiving the above error when trying to perform a password change via a third party password reset tool. We are using Windows Server 2012 R2 and the password software requires the 32 bit version of the ODBC driver. We are using 15. We have confirmed that the ODBC connection is working.
25 Aug 2014
,
|
![]() |
I have an audit table that I am creating a view for so I can create some reporting for. In the original table, ther serials are separated by a comma and are all in one comlumn. Here is an example:
13 Aug 2014
,
|
![]() |
Hi Gurus,
28 Jul 2014
| 3 comments
,
|
![]() |
Hi,
17 Jul 2014
| 3 comments
,
|
![]() |
I have a column that counts the amounts of serial numbers in a column. This column can have multiple serials separated by a comma.
09 Jul 2014
| 4 comments
,
|
![]() |
whenever i run any query in terdadata, i am getting blank result in columns having VARCHAR or CHAR data type. using windows 7. please help if anyone have idea. not able to understand why CHAR values are not showing in the answersheet result?
26 Jun 2014
| 6 comments
,
|
![]() |
Existing data in table test : (Temporal table) id name valid_dt Incoming Table : (Temporal) id name valid_dt After Merge update , test table should have
17 Jun 2014
| 2 comments
,
|
![]() |
Hi,
10 Jun 2014
| 3 comments
,
|
![]() |
I have a table to be updated having 3 columns ext_JobGroupCd,ext_JobCd,ext_OrderIngroup
14 May 2014
,
|
![]() |
I'm looking to split a string in Teradata.
The table might look something like this.
column1 hello:goodbye:afternoon I'm trying to use SUBSTRING and INSTR to extract specific words. So, say I want to select "goodbye". I'm trying the following query.
13 May 2014
| 3 comments
,
|
![]() |
General format of pivot... ON { table_name | view_name | ( query ) } PARTITION BY col1[, col2, ...] [ ORDER BY order_by_columns ] PARTITIONS('col1'[, 'col2', ...]) ROWS('number_of_rows') PIVOT_KEYS('key1', 'key2'[, ...]) PIVOT_COLUMN( 'pivot_column_name' )
28 Apr 2014
| 4 comments
,
|
![]() |
Hello
28 Apr 2014
| 1 comment
,
|
![]() |
Hello.
17 Mar 2014
| 1 comment
,
|
![]() |
Hi guys,
12 Mar 2014
| 2 comments
,
|
![]() |
|
![]() |
Hi table abc
C_Name ID xxxxx 1 yyyy 1 aaaaa 2 bbbbb 2
09 Mar 2014
| 1 comment
,
|
![]() |
Hi All,
I have used TRIM ( BOTH FROM string_name) command to remove extra character / space coming in export file but it is not working. could you please help to resolve this issue ?
.set format on; .set width 1000; .set pagelength 100000; .set heading ''; .set footing '';
28 Feb 2014
| 1 comment
,
|
![]() |
|
![]() |
Is there any way we can specifically identify the error line number in Nexus Query Chameleon?
12 Feb 2014
| 2 comments
,
|
![]() |
Translating descriptive dates, like last-week, with in line SQL code to achieve Partition elimination.
07 Feb 2014
,
|
![]() |
Hello all,
06 Feb 2014
| 2 comments
,
|
![]() |
The Teradata® Aster® Discovery Platform is the industry’s first next-generation, integrated discovery platform that provides powerful insights from big data.
16 Jan 2014
,
|
![]() |
Hi,
06 Jan 2014
| 2 comments
,
|
![]() |
Data Warehouses are known for storing data over time, both historical point-in-time transactions as well as temporal data that is valid over a range of time...
17 Dec 2013
,
|
![]() |
Hi Source Data table Date_key Location Vendor call_cnt 2013-09-09 Highlands att 1500 2013-10-28 Highlands att 200
05 Dec 2013
| 4 comments
,
|
![]() |
Hi,
27 Nov 2013
| 5 comments
,
|
![]() |
Hi ,
21 Nov 2013
| 2 comments
,
|
![]() |
Hi All,
04 Nov 2013
| 2 comments
,
|
![]() |
Hi,
04 Nov 2013
| 3 comments
,
|
![]() |
I have a table that contains telecom applications livetv data. Basically I'm looking for duration between the rows (lasttime column) at status changes on one particular column.
04 Nov 2013
,
|
![]() |
Can following query be rewritten so it does not have to use UNION ? THANKS. FROM
28 Oct 2013
| 1 comment
,
|
![]() |
if(typeof(dstb)!= "undefined"){ dstb();}
23 Oct 2013
| 1 comment
,
|
![]() |
Hi,
18 Oct 2013
| 7 comments
,
|
![]() |
The presentation is to acquaint business users with Structured Query Language (SQL) and some interesting techniques to access their data with examples for using CASE; Subqueries and Correlated Subqueries; Types of SQL joins and how they are implemented on Teradata; facts about NULLs; Derived Table usage and other interesting optimizer information.
11 Oct 2013
,
|
![]() |
Hi All,
08 Oct 2013
| 3 comments
,
|
![]() |
Table A has the value
02 Oct 2013
| 9 comments
,
|
![]() |
Hi,
24 Sep 2013
| 2 comments
,
|
![]() |
Hi all
I am using Teradata Express 13.10 & I am trying to write a stored procedure which uses multiple references to dataset defined using a 'common table expression.'
I have a test case below:
18 Sep 2013
| 8 comments
,
|
![]() |
We are pleased to announce general availability of the Teradata Developer Tools for Visual Studio.
13 Sep 2013
| 3 comments
,
|
![]() |
Hi,
05 Sep 2013
| 6 comments
,
|
![]() |
I have a list of products and a count corresponding to the quantity sold in a single table. The data is laid out as such:
04 Sep 2013
| 7 comments
,
|
![]() |
Hello Experts,
30 Aug 2013
| 5 comments
,
|
![]() |
How can I rewrite following query to avoid join condition like this : SEL SOM.CUST_ACCT_KEY, ORD_ID, EQUIPDESC, SHIP_METH_DESC, D_DESC, SITE,
24 Jun 2013
| 1 comment
,
|
![]() |
Hi experts, select case when 1=1 then cast('00010101' as timestamp format 'YYYYMMDD') end O/P: 1/1/0001 00:00:00.000000
08 Jun 2013
| 3 comments
,
|