SQL Functions | Geography | Calculate Distance Using Latitude and Longitude coordinates

[@FathimaRuqaiyyahYazeer]

Super It Works, Very useful to me

[@LearnatKnowstar]

Great to hear it was helpful!

[@MrRhysstevens]

Very nice, but version of ss can I find this in ?

[@oleskool4908]

How do you make the location points dynamic if I have to look up allot of cities in a table

[@chandupaila9972]

Regional routing : We have 6 warehouses (Hyderabad, Mumbai, Delhi, Bengaluru, gurgaon and Chennai) and we are getting orders from different pincodes across India, how can I calculate the nearest warehouse to dispatch the product? Any suggestions please? Thanks in advance

[@CebuProvince]

Msg 6506, Level 16, State 10, Procedure Distance , Line 6 [Batch Start Line 7] The STGeomfromText-Methode for the Microsoft.SqlServer.Types.SqlGeography-Typ was in the Microsoft.SqlServer.Types-Assembly not found - in Version of of the SQL Server this works?