title: Join two tables with geometry column into one
body: <p>I have two tables that are exactly the same. I want to join them together into one large dataset. I tried simply <code>SELECT-INTO</code> query but got an error...</p>
  
  <pre><code>SELECT * INTO dbo.ParkingBay 
  FROM (SELECT * FROM dbo.ParkingBay_Old 
        UNION 
        SELECT * FROM dbo.ParkingBay_New) AS PARKING_BAY;
  </code></pre>
  
  <p>The error is:</p>
  
  <blockquote>
    <p>The geometry data type cannot be selected as DISTINCT because it is
    not comparable.</p>
  </blockquote>