title: Determining cardinal (compass) direction between points
body: <p>Is there a way to know in SQL Server 2008R2 if a point is at the south,east,etc...of   another point?</p>
  
  <p>For example, I have an origin <code>point(lat1,lng1)</code> and I want to know where <code>point(lat2,lng2)</code> is located from that origin: north, west,etc...</p>
  
  <p>I'm trying to construct a wind rose graph and this might be useful to me.</p>