title: Closest Point on a Line in SQL Server Spatial 2008 R2
body: <p>In an ideal world I would be running on SQL Server 2012 and be able to use the .ShortestLineTo() function to find the closest point on a line, to that of another point.  I currently am able to find the closest line to my point - but now I need to find the coordinates of the point closest to my point in question.</p>
  
  <p>Unfortunately I am stuck on SQL Server 2008 R2, so don't have the option to use .ShortestLineTo().</p>
  
  <p>How do others achieve this in SQL Server Spatial Geometry types?</p>
  
  <p>Cheers,</p>
  
  <p>Matt</p>