title: Error converting from varchar to numeric
body: <p>I am trying to run this update statement, however, I getting an error that reads 'Error converting varchar to numric'.  Data types of the fields are as follows:</p>
  
  <pre><code>dbo.keyona.customer_id_num is a decimal(16,0)
  s.customer_identifier is varchar(250)
  s.customer_cis is varchar(250)
  k.dedupe_static is decimal(20,0
  </code></pre>
  
  <p>)</p>
  
  <p>Query is as follows</p>
  
  <pre><code>update dbo.keyona
  set dbo.keyona.customer_id_num = s.customer_identifier
  from dbo.keyona k join [StorageDB - BAW].[dbo].[MI_NedLife_Mapper_Embedded_Linked_201804] s
  on  s.customer_cis = k.dedupe_static
  </code></pre>