# | Date | Forum | Type | Thread | Post |
10 | 13 Jul 2016 @ 12:02 PDT | Database | Topic | Regarding Teradata Migration | We are planning to do a Teradata migration, the versions for source and target Tearadata is close (source Teradata version 15.00.02.02, though not sure about Target version yet). The migration is h... |
9 | 15 Jan 2014 @ 02:59 PST | Database | Reply | Account balance SQL | Hi Saeed,
Your query will give below output :
A_date A_bal
1/1/2014 10,000
1/15/2014 15,000
1/25/2014 13,000
But I want the output in the below way where all the 31 days of Januar... |
8 | 14 Jan 2014 @ 11:58 PST | Database | Topic | Account balance SQL |
A_date A_bal
1/1/2014 10,000
1/15/2014 15,000
1/25/2014 13,000
I have sample account balance information as shown above. i.e. 01-Jan 10K, 15th J... |
7 | 11 Dec 2013 @ 11:22 PST | Database | Reply | SQL to transpose (row to column) any level (nth level) of data | Thanks for your reply, but when I will have a dataset like below :
Tgt Src lvl
============ ============ ====
L4_Tab1.Col1 L3_Tab2.Col3 0
L4_Tab1.Col4 L3_Tab2.Col1 0
L4_Tab1.... |
6 | 11 Dec 2013 @ 12:18 PST | Database | Reply | SQL to transpose (row to column) any level (nth level) of data | Hi Khurram,
My question is little different. In my example there is a linkage between Src column value of lvl=0 with Tgt column value of lvl=1
Source Data
Tgt Src lvl
L3_Tab1.C... |
5 | 10 Dec 2013 @ 11:53 PST | Database | Reply | SQL to transpose (row to column) any level (nth level) of data | Source Data
Tgt
Src
lvl
L3_Tab1.Col1
L2_Tab1.Col3
0
L3_Tab1.Col2
L2_Tab2.Col2
... |
4 | 10 Dec 2013 @ 11:50 PST | Database | Topic | SQL to transpose (row to column) any level (nth level) of data | Hi,
I have a data like below:
Tgt
Src
lvl
L3_Tab1.Col1
L2_Tab1.Col3
0
L... |
3 | 04 Oct 2012 @ 07:51 PDT | General | Topic | Server configuration for TDE 13.10.00.10 for VM Ware (1 TB) installation | Hi,
Can any one please let me know the configuration required for a Linux VM Ware server for "TDE 13.10.00.10 for VM Ware (1 TB)" installation, considering approximately 100 concurrent u... |
2 | 30 Sep 2012 @ 11:47 PDT | General | Topic | General Information on Teradata Software | Hi,
We are actually at the start of a project on Teradata and for that we want build and/or enhance skill on Teradata of the resources who will be working on it. Could you please let me know that ... |
1 | 24 Sep 2012 @ 01:53 PDT | Tools | Topic | Date (Y2K) Issue | Hi,
I have installed "Teradata Express 13 - Windows" for learning purpose. Now when I am executing the query below in "Teradata SQL Assistant" I am getting output as "12/2... |
|
|