Scott Coleman

Calculate distance between two points

The calculation of distance between two points using standard spherical geometry can be inaccurate for short distances (ten miles or less) because the sine function of very small angles approaches zero. The haversine approach (http://en.wikipedia.org/wiki/Haversine_formula) turns this around, so it is very accurate at small distances but has larger errors (about ten miles) for points […]

4 (1)

2006-05-18 (first published: )

549 reads

Blogs

Event Notifications Example

By

Event notifications are kinda like a trigger in the sense that they respond to...

Did you know we have another SQL Server book coming out?

By

SQL Server 2017 Administration Inside Out was the first technical book I contributed to,...

Batch Scripting SQLCMD–#SQLNewBlogger

By

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

Read the latest Blogs

Forums

Can't Get Attunity Oracle Connector to Work with SQL Server 2017 / Oracle 12c

By brad.mccollum

I've tried many times to install the various versions of the Attunity Data Connector...

Using Java script to import word and pdf into SQL server

By pcq0125

I am looking for example or use case codes  in using Java script to...

Using sftp in Visual Studio for SSIS packages

By Isabelle2378

Hi, I've inherited the maintenance of SSIS packages that were created by our former...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers