title: Arithmetic overflow error converting numeric to data type numeric
body: <p>I am facing an error on my SQL script:</p>
  
  <blockquote>
    <p>Arithmetic overflow error converting numeric to data type numeric</p>
  </blockquote>
  
  <pre><code>select x.MemberName,x.DOB,x.FilePath,x.Medication,x.NDC,x.Directions,x.Name,x.Strength,x.GenericName,x.QtyOrdered,x.DaysSupply,x.DateFilled, 
  CASE
      WHEN x.test = 0  THEN 'N/A'
      WHEN compliance &gt; 100.0   THEN '100.0'
      ELSE CONVERT(VARCHAR(5), CAST(FLOOR(compliance *10)/10.0 AS DECIMAL(3,1)))
  END as [Compliance]
  </code></pre>
  
  <p>I am facing the error on just above syntax line. </p>