findout location point inside a radius in meter

• meenu.monu

  Old Hand

  Points: 349

  More actions

  May 30, 2011 at 5:12 pm

  #239130

  dear friend,can u help me to solve my issue.

  in sql 2005

  i have a table named radius and the fields are long ,lat,radius

  long=51,lat=22,radius=2 meter

  and another table value is

  long1 =45,lat1=25

  i want to check long1 and lat1 is inside the radius of 2 meter from long and lat.

  how can i do this ?i wnt the result like "radius in" and "radius out"

  how can i found that?

  longitude and latitude are actual location points.radius is in meter.

  anybdy help me?

• Damian Widera-396333

  Ten Centuries

  Points: 1196

  More actions

  May 30, 2011 at 5:39 pm

  #1331753

  Hi, looks like a task for an exam 🙂

  It is just a math - it has nothing to do with SQL Server

  as the data could be stored in a flat file 🙂

  Kindest Regards,

  Damian Widera
  SQL Server MVP,
  MCT, MCSE Data Platform, MCSD.NET