title: How to convert decimal (28, 4) to another decimal with higher precision?
body: <p>The problem is in data conversion from decimal (28, 4) to decimal (21,20). I am working on SQL Server 2008.  </p>
  
  <p>I have tried some snippets to solve my task, but as you see I cannot save data in decimal(21,20) because i get this message:</p>
  
  <blockquote>
    <p>Msg 8115, Level 16, State 8, Line 35<br>
    Arithmetic overflow error converting numeric to data type numeric.</p>
  </blockquote>
  
  <p>Code:</p>
  
  <pre><code>UPDATE [table]  
  SET [col] = CONVERT(DECIMAL(21, 20), [col1])
  GO
  
  ALTER TABLE [non_det_liabilities] 
      MODIFY [col1] DECIMAL(21, 20)
  </code></pre>
  
  <p>The result what i expecting is copied data with required decimal precision.</p>