title: Msg 8114, Level 16, State 5, Line 4 Error converting data type varchar to numeric
body: <p>I am using SQL Server. I have written below select and at the time of execution I am getting data conversion error. Please help me to identify the issue and suggest how do I fix it.</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT   
      CASE 
         WHEN SUM(Day_GuestCount) &lt;&gt; 0 AND SUM(Day_ForecastGuestCount) &lt;&gt; 0
            THEN CONVERT(DECIMAL(5, 1), ((SUM(Day_GuestCount) / SUM(Day_ForecastGuestCount)) - 1) * 100) * -1 
            ELSE CASE 
                    WHEN AllCompanyRestaurantsClosed = 'Yes' AND StoreOwnershipType = 'Company'
                       THEN 'All Restaurants Closed (' + SpecialDateLabel + ') '
                       ELSE '(' + SpecialDateLabel + ') '
                 END
      END AS 'vsExpectations',
      CASE 
         WHEN SUM(Day_SRSGuestCount) &lt;&gt; 0 AND SUM(Day_SRSPreviousYearGuestCount) &lt;&gt; 0
            THEN CONVERT(DECIMAL(5, 1), ((SUM(Day_SRSGuestCount) / SUM(Day_SRSPreviousYearGuestCount)) - 1) * 100) * -1
            ELSE ' '
      END AS 'SRC',
      CONVERT(DECIMAL(10, 2), SUM(Day_MO_NetSalesAmount)) AS 'Sales',
      CONVERT(DECIMAL(10, 2), SUM(Day_MO_GuestCount)) AS 'Customers ',
      'DWDMOS' AS Report
  FROM    
      [DBname].[schemaname].tablename
  WHERE   
      StoreOwnershipType = 'Company'
      AND IsMobileSite = 'Yes'
  GROUP BY 
      StoreOwnershipType, DayNameOFWeek, SpecialDateLabel,
      CurrFullDate, AllCompanyRestaurantsClosed
  </code></pre>
  <p>Columns datatypes:</p>
  <pre><code>Day_GuestCount - DECIMAL(38,4)
  Day_ForecastGuestCount - DECIMAL(38,4)
  AllCompanyRestaurantsClosed - VARCHAR(3)
  StoreOwnershipType - VARCHAR(50)
  SpecialDateLabel - VARCHAR(225)
  </code></pre>
  <p>Values:</p>
  <pre><code>Day_GuestCount - 0
  Day_ForecastGuestCount - 0
  AllCompanyRestaurantsClosed - 'Yes'
  StoreOwnershipType - 'Company'
  SpecialDateLabel - 'Thanksgiving'
  </code></pre>
  <p>This is the error I get:</p>
  <blockquote>
  <p>Msg 8114, Level 16, State 5, Line 4<br />
  Error converting data type varchar to numeric.</p>
  </blockquote>
  <p>Please help me to identify the issue and fix .</p>