Sunday 15 March 2015

sql server - sort by distance using latitude and longitude -


I am trying to create a store locator, and there is a problem making my SQL statements. I have the following so far: 

  Select Top 3 Customs, (3959 AC) (Cos (Andean (36)) * cos (Andean) * cos ( Radian (regian) -   
 When I run the statement that I get:   
   
 / P> 
  Message 0, Level 11, State 0, line 0 There was a serious error on the current command. If there are any results, they should be ignored.   
 Although the query when I remove the order by command and when I press What is the reason for this error that changes the order by section and how can I avoid it?   
 
 
 Starting with SQL Server 2008, a geographical data type that is designed for things like this is a link here:  
   

 








Posted by



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)