#DateForumTypeThreadPost
306 Jun 2016 @ 05:39 PDTDatabaseTopicFind 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...
218 Jan 2014 @ 11:23 PSTDatabaseReplyJoin tables and replalace NULLSThank you, it works!!!
118 Jan 2014 @ 07:27 PSTDatabaseTopicJoin tables and replalace NULLSHi, 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...