I am having problems developing the UPDATE portion of a MERGE statement between 2 tables. Both table A and table B contain 331 like fields, any one of which may be being updated. I only want to update the fields in table A if the corresponding field in table B has a value (is not NULL).
Table A has a primary key, but table B may have multiple records matching the same record key in table A.
Any help is much appreciated. I do not usually do any database development, and this is being demanded of me by management in a short timeframe (yesterday, as they say).