#DateForumTypeThreadPost
523 Aug 2012 @ 10:54 PDTAnalyticsTopicJOIN - Need to include a.tkt_num = b.tkt_num And (a.tkt_num not = b.tkt_num) Hi, Can you please assist me with the following Join Query… I’d like my query to always show everything from the pedw_tmp.tickets_ccb_tmp even if there’s nothing in the pe...
419 Jul 2012 @ 10:27 PDTAnalyticsReplyMultiple Rows Into 1 Question No it's not always 3 rows. From the Radf it can be multiple rows as each tkt can range from 1 to say 4 coupons or so.   ...
318 Jul 2012 @ 11:53 PDTAnalyticsReplyMultiple Rows Into 1 Question Hi & thanks Ulrich! Just about there, now my Sum(Radf_amt_pd) column is overstated. (3x) 1247.28 should be 475.76 1812 should be 604 Do you have a recommended solution t...
218 Jul 2012 @ 05:23 PDTAnalyticsReplyMultiple Rows Into 1 Question Hi Again, I've attempted a Qualify Row. My Query: select a.postdate, a.trans_type, a.billing_crcy_cde, a.cc_typ_cde, a.tkt_num, (case when c.dr_gl_acct_num = '123401' the...
118 Jul 2012 @ 04:07 PDTAnalyticsTopicMultiple Rows Into 1 Question Hi All, I was wondering if i could get some expert advise on the best way to receive the following output.     ...