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

237 reads

Blogs

Quick Blog: Making the Power BI PowerShell cmdlets easier to use

By

One of the top reasons I love PowerShell so much is that from the...

Trouble writing? Join the club. #JustWriteTech

By

I was talking with  a couple of excellent SQL people* recently, and we were bemoaning...

Check Query Progress with Live Query Stats

By

This is something I touched on back in 2017 a little after the Live...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

update table b if b.time falls between any of table a rows start/stop

By delizat4g

I'm trying to find a way to rewrite this dusty old cursor set based,...

Check if number exists in a column

By tim.stutzman

Hello, I am pulling some address data from a legacy system and it has...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers