title: SQL Server Geography Multipoint Insert
body: <p>I am using SQL Server 2012. I have a table where I am tracking single point instances in a geography column. Storing them as a single point is working fine but I am trying to group some of them together into a new table where they would be a multipoint. I can get it working by inserting lat and long into a multipoint column like this:   </p>
  
  <pre><code>DECLARE @g geography; 
  SET @g = geography::STMPointFromText('MULTIPOINT(-104.952784 39.524092, -104.935269 39.542652)', 4326);
  INSERT INTO test(loc) values(@g)
  </code></pre>
  
  <p>What I want to do is select the values from a table that are already a geography data type. I am not sure if I can do this with a basic query or if I have to build it with a loop? I cannot seem to get it working either way.</p>
  
  <p>Also, after I have that is there a method that will return me the center point of a multipoint column? I have been playing with some of the methods like <code>STStartPoint</code> and <code>STEndpoint</code> but I cannot seem to find a methods that return the center point?</p>
  
  <p>Any help on these questions would be great and highly appreciated.</p>
  
  <p>Thanks!</p>