#DateForumTypeThreadPost
401 Jul 2015 @ 02:21 PDTDatabaseReplyReplace NULL Values in Table with Most Recent NOT NULL valuesNo. The source will always send us value in old_cust_acct_id when the cust_acct_id is getting converted. But, henceforth they will send is NULL in the value. If I use COALESCE, it wont work for t...
330 Jun 2015 @ 12:12 PDTDatabaseReplyReplace NULL Values in Table with Most Recent NOT NULL valuesI had tried using LAST_VALUE in DEV and that was working. Unfortunately, in PROD we still use TD 14.0, and the upgrade to TD 15.0 is still a few months away. So I was stumped. Thanks for the tip ab...
230 Jun 2015 @ 08:43 PDTDatabaseReplyReplace NULL Values in Table with Most Recent NOT NULL valuesI'm sorry. I am new to the forum. The sample data above looks all messed up. I'm not sure how to publish it with correct formatting.
130 Jun 2015 @ 02:27 PDTDatabaseTopicReplace NULL Values in Table with Most Recent NOT NULL valuesI have a table with the following layout cust_acct_id (PK)| effect_dt | expiry_dt | curr_rec_ind | field_a | field_b | field_c | field_d I have to populate any NULL values in field_a, fie...