title: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the UNION operation
body: <p>I have to join 2 views and create table which populates dates from the view.</p>
  
  <p>But I am getting this error: </p>
  
  <blockquote>
    <p>Cannot resolve the collation conflict between
    "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the UNION
    operation.</p>
  </blockquote>
  
  <pre><code>CREATE VIEW [dbo].[Destinations_1415_1516_Union]
  AS
  SELECT *
  FROM
  [dbo].[Destinations_1415] 
  UNION
  SELECT *
  FROM
  [dbo].[Destinations_1516] 
  GO
  </code></pre>
  
  <p>Please suggest how to resolve this</p>