Dear All, Need help with below situation....
Data
id        date
100   6/6/2015
100   8/1/2015
100   9/30/2015
200   8/11/2015
300   7/18/2015
300   1/10/2015
300   3/5/2015
300   6/15/2015

My data looks something like this:
table1:
ID | Line | Code
1 | 1 | a
1 | 2 | b
2 | 1 | d
2 | 2 | e
2 | 3 | f
 
table2:
Code | Name
a | alpha
b | beta
d | delta
e | epsilon
f | phi
 
A common join brings the following results:
ID | Line | Name

Hi,
I am new to Teradata and I am working on query for which I greatly appreciate any help. I have a following table (after ordering by col1 and col2) 
Col1        col2             col3        
Alpha      10:00          activity typ 1
Alpha       10:00:30    activity typ 2
Alpha       10:00:40     activity typ 3

Hi,  I am having the following problem when trying to create a CSV report  to email out.  The title line of the report is showing up like this "((((((((((((((((((((((((((((((((((((((((((((((((((AGT_ENT_US" instead of all the field names.  The records themselves are showing up properly.
 
.set MAXERROR 1
.set width 1300

Hi,
I download the 'Windows Help' file for '.NET Data Provider 14.10.00.00' at
http://downloads.teradata.com/download/connectivity/dot-net-data-provider

I am running a query that returns blling data with an account number that contains "." in no set position. What I need to do is replace the period "." in each instance that it occurs with a forward slash "/".

I have read many items related to using UDF's, however I do not own the server and have no idea if any UDFs are actually loaded.

What is the difference between FUNCTION and SPECIFIC FUNCTION?  When do I use SHOW FUNCTION versus SHOW SPECIFIC FUNCTION?  Or HELP FUNCTION versus HELP SPECIFIC FUNCTION?  Thanks,  Denmark

What is the best way to extract the output of the 'Help statistics DbName.TblName column Partition;", for the purpose of extracting the value of the column 'Number of Rows'. If you have attempted this through SQL, please share your thoughts. What I've already have in place is the following methodology...
Run 'Collect Statistics on DbName.TblName Column (Partition);
Run 'Help Statistics DbName.TblName Column (Partition);' through BTEQ with SideTitles on

Hello,

NOTE: Teradata SQL Assistant 12.0 worked over the past year and just started giving me an issue in the past month or two. I am running on Windows XP Professional 32-bit.

I am running into an interesting error that I cannot seem to find a solution to. When trying to run Teradata SQL Assistant 12.0, I am receiving the following error prompt:

Error received: "Error occurred during GetIniData. Code=339

Component 'POWERE~1.OCX' or one of its dependencies not correctly registered: a file is missing or invalid

there are two tables table1 and table2

table1 ---columns

C1 c2 c3 c4 c5

where c3 and c4 are datebegin and dateend

table2----columns

d1 d2 c5

where d1 and d2 are dategin and date end

now i need to join table1 and table2 based on c5

Hey everyone,

I'm in the midst of creating a new Viewpoint article discussing getting started with Viewpoint and what portlets are most often used as a starting dashboard for various Teradata user roles. So questions like, "if I was to share Viewpoint with our Business Users, which portlets would I want to allow them to use?" or "As a DBA, what are the most logical portlets to start with?". So the article is going to try and provide some insight for those whom have questions like that.