![]() |
I'm looking to consilidate rows in my table by combining similar consecutive rows together.
19 Jul 2016
| 5 comments
,
|
![]() |
WITH RECURSIVE RECTBL(child_ID, child_nm, Parent_ID, Parent_NM, LVL)AS ( SELECT CHILDid, childname, PARENTID, parentname, 0 AS lvl FROM WDM_S_WCIS_GEN_S1.HIERARCHY WHERE CHILDid = 1 AND SNAP_EFF_DT = CURRENT_DATE - 1 UNION ALL SELECT CHILDid, childname, PARENTid, parentname, RECTBL.LVL + 1 FROM RECTBL
06 Jun 2016
,
|
![]() |
Normally when you define a column and give it an alias you can reference it in calculating another column:
20 May 2016
| 2 comments
,
|
![]() |
Hi All,
20 May 2016
| 2 comments
,
|
![]() |
I am looking to build and Effective Date and Expiration Date utilzing a customers next purchase date in the table without a do loop if possible as I do not have access to buid stored procedures.
28 Mar 2016
| 1 comment
,
|
![]() |
Hi,
18 Mar 2016
| 2 comments
,
|
![]() |
Hi All Source --> Target1 Target1 --> Target2 Target1 --> Target 3 Target2 --> Target 4
23 Feb 2016
| 1 comment
,
|
![]() |
Hello
26 Nov 2015
| 1 comment
,
|
![]() |
My data looks something like this:
14 Oct 2015
| 7 comments
,
|
![]() |
Hi Guys,
15 Dec 2014
| 2 comments
,
|
![]() |
Hello,
03 Jun 2014
| 1 comment
,
|
![]() |
I have a table to be updated having 3 columns ext_JobGroupCd,ext_JobCd,ext_OrderIngroup
14 May 2014
,
|
![]() |
Hello
28 Apr 2014
| 1 comment
,
|
![]() |
I am pretty new to teradata and know some basic SQL but I find that I am struggling with this problem.
01 Jul 2013
| 1 comment
,
|
![]() |
Yesterday our DBA's completed the update of our Teradata test environment to version 14.
02 Apr 2013
| 2 comments
,
|
![]() |
Hello, Can someone help me with a Recursive SQL problem. I am new to teradata and I know Recursive SQL is a more advanced function. I'm trying to concatenate all the holiday dates on one line and my query runs but it never stops :). Any Ideas?
WITH RECURSIVE Holiday (HOLIDAY_IND, Dates, level) AS (
27 Jun 2012
| 2 comments
,
|
![]() |
Hi,
I need to traverse a "Relationship Table" using a "Recursive Query". An example follows. My actual business problem is far more complicated than this example. However, the required logic should be similar to the following.
01 Apr 2012
| 2 comments
,
|
![]() |