title: SQL-Server Geography Remove an overlap
body: <p>I'm trying to remove an overlap with the SQL-Server 2012 but i have no clue how to do it.</p>
  
  <p>Example:</p>
  
  <pre><code>CREATE TABLE #temp(
  [Geo] [geography] NOT NULL)
  INSERT INTO #temp
  VALUES (geography::STGeomFromText('POLYGON((0 0, 0.1 0, 0.1 0.1, 0 0.1,0 0))', 4326))
  INSERT INTO #temp
  VALUES (geography::STGeomFromText('POLYGON((0.05 0.05, 0.15 0.05, 0.15 0.15, 0.05 0.15, 0.05 0.05 ))', 4326))
  SELECT * FROM #temp
  </code></pre>
  
  <p>My idea would be to use the STIntersection() function to get the overlapping polygon and then somehow to delete it from one of the polygons.</p>