Haversine Calculation in User Defined Function

Uses the haversine formula to calculate distance between 2 long / lat points.  This can be used with a zip code / lat and long table that are available from the census bureau or post office.The @R can be tweaked dependent on what gives you the best result (its the radius of the earth, fluctuates […]

2003-09-25

373 reads

Blogs

Logging Messages with Raiserror – #SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Daily Coping 8 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Webinar – Building a Proper SQL Server Database Security Model

By

Tomorrow, March 9, 2020, at 3 PM EST, I will be giving a presentation...

Read the latest Blogs

Forums

Importing text file issue

By smattiko83

Hi, I am trying to import the attached REF_RF1MAS.txt file but am getting numerous...

Empty Index Statistics object

By AnzioBake

This is a new thread but relates directly to Index statistic is empty -...

Transactions

By sizal0234

Hi, Can you please let me know what is the benefit of using the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers