title: Update Item from same table where values are null
body: <p>I have a table Member where their are duplicate entries and I want to remove one of them, but 1 of the entry has some columns updated and another has some other.</p>
  
  <p>So What I want to do is update but the columns where values exist in 1 and null or empty in another so that both the rows become completely identical and I do not loose any data out of it.</p>
  
  <p><strong>Table Structure:</strong></p>
  
  <pre><code>CREATE TABLE [dbo].[membermobilenumberisnull](
  [TransId] [bigint] NOT NULL,
  [member_id] [int] NOT NULL,
  [gendertype] [int] NULL,
  [relationship_rs_code] [nvarchar](2) NULL,
  [ration_card_id] [int] NOT NULL,
  [uid] [nvarchar](16) NULL,
  [member_dob] [datetime] NULL,
  [member_name_en] [nvarchar](150) NULL,
  [mother_name_en] [nvarchar](150) NULL,
  [father_name_en] [nvarchar](150) NULL,
  [member_age] [smallint] NULL,
  [nationality] [nvarchar](150) NULL,
  [MobileNumber] [nvarchar](20) NULL,
  [IsUpdated] [bigint] NULL,
  [UpdationDate] [datetime] NULL,
  [IsDeleted] [bigint] NULL,
  [DeletionDate] [datetime] NULL,
  [CreationDate] [datetime] NULL,
  [UpdatedBy] [nvarchar](250) NULL,
  [DeletedBy] [nvarchar](250) NULL,
  [MobileNumber1] [nvarchar](20) NULL,
  [MobileFlag] [nvarchar](250) NULL
  ) ON [PRIMARY]
  
  GO
  </code></pre>
  
  <p><strong>Sample Data</strong></p>
  
  <pre><code>TransId     member_dob  member_name_en      member_age  nationality MobileNumber    UpdationDate    CreationDate
  252238402   12-09-1985  PUSHPINDER SINGH    31          IND                         NULL            30-07-2016
  252238403   12-09-1985  PUSHPINDER SINGH    31          IND         8626934377      NULL            30-07-2016
  260846102   03-06-1984  VUDDHI DEVI         32          IND         9459209701      19-10-2016      14-08-2016
  260846105   03-06-1984  VUDDHI DEVI         32          IND         NULL                            14-08-2016
  </code></pre>
  
  <p><strong>Expected Result:</strong></p>
  
  <pre><code>TransId     member_dob  member_name_en      member_age  nationality     MobileNumber    UpdationDate    CreationDate
  252238402   12-09-1985  PUSHPINDER SINGH    31          IND             8626934377      NULL            30-07-2016
  252238403   12-09-1985  PUSHPINDER SINGH    31          IND             8626934377      NULL            30-07-2016
  260846102   03-06-1984  VUDDHI DEVI         32          IND             9459209701      19-10-2016      14-08-2016
  260846105   03-06-1984  VUDDHI DEVI         32          IND             9459209701      19-10-2016      14-08-2016
  </code></pre>
  
  <p>Thanks in advance</p>
  
  <p><strong>Example attached:</strong>
  <a href="https://i.stack.imgur.com/yzkG6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yzkG6.png" alt="enter image description here"></a></p>