Calculating GeoDistance between two points
In this article, we are going to see how to calculate Geo-distance between two points using SQL server. You can calculate geo distance using spatial types – geography datatype in SQL server. This type represents data in a round-earth coordinate system, You can find out detailed information at Spatial type: Geography The default syntax for to convert Latitude and Longitude into Geography…
BI Developer specialized in SQL Query Development/ SSIS/ SSAS/ SSRS /Power BI/ MS Office. Enjoy working in data analysis and presentation, challenging projects where I can uncover valuable business insights for an organization from previously under-utilized data sources and creating custom made reports and interactive dashboards