title: Storing custom coordinates in SQL Server
body: <p>I have a table in SQL Server database that has a 2 fields X, Y. These fields represent coordinates on a field (american football field). 0,0 (X,Y) is the starting point with the largest value and furthest away point being 145,90 (X,Y). </p>
  
  <p>Each row in the table is a coordinate from the pitch. </p>
  
  <p>I want to be able to measure the distance between different coordinates on the field (different rows in the database) eg. 3,9 to 15,20. I also want to be able to measure the angle between coordinates.</p>
  
  <p>I looked the spatial types etc in SQL Server but its seems to me that is related to Latitude, Longitude.</p>
  
  <p>Is there any way in SQL Server that can I set such up in SQL with a custom map to measure between custom points, angles etc?</p>