| # | Date | Forum | Type | Thread | Post |
|---|
| 3 | 06 Jun 2016 @ 05:39 PDT | Database | Topic | Find all parents for child |
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 SNA... |
| 2 | 18 Jan 2014 @ 11:23 PST | Database | Reply | Join tables and replalace NULLS | Thank you, it works!!!
|
| 1 | 18 Jan 2014 @ 07:27 PST | Database | Topic | Join tables and replalace NULLS | Hi,
Could you please help me to join Table 2 to table 2 without null values
Thank you!
======================
Table 1(trending table keeps all months)
MonthID CusID Amount
20130... |
|
|