title: SQL Server : Query Union All Converting Type Failed
body: <p>I'm trying to run a query to pull back data from two tables using a union all and keep getting the following: </p>
  
  <blockquote>
    <p>Msg 245, Level 16, State 1, Line 29<br>
    Conversion failed when converting the nvarchar value 'ie9' to data type int.</p>
  </blockquote>
  
  <p>I'm not sure why anything is trying to convert it should be able to show its table data??</p>
  
  <p>Here is my SQL:</p>
  
  <pre><code>SELECT 
      CustomerNumber, Event
  FROM 
      CustomerPortal.dbo.WebLog
  WHERE 
      (Event = 'exception') 
      AND (CreateDate &gt;= '04/03/2015') AND (CreateDate &lt;= '04/06/2015')
  
  UNION ALL
  
  SELECT distinct 
      BrowserId, BrowserName 
  FROM 
      CustomerPortal.dbo.BrowserInfoLog;
  </code></pre>