<div>
Thanks for the points, and thanks for using EE, ~Ray
</div>


Thanks for the points, and thanks for using EE, ~Ray

<div>
<div class="content wysiwyg-content">
I would like to update our City table to reflect the mileage from that city from our company address. &nbsp;It can be accomplished manually by plugging in cities and our address but with over 475 city records (and over 29k job records) I would prefer to automate it.<br />
<br />
&nbsp;Is this possible? &nbsp;<br />
<br />
If so, can we do this for individual job records?
</div>
</div>


I would like to update our City table to reflect the mileage from that city from our company address.  It can be accomplished manually by plugging in cities and our address but with over 475 city records (and over 29k job records) I would prefer to automate it.

 Is this possible?  

If so, can we do this for individual job records?

SQL to populate Mileage from Business Address to each record's Site Address

The Global Positioning System (GPS) is a space-based global navigation satellite system (GNSS) that provides reliable location and time information in all weather and at all times and anywhere on or near the Earth when and where there is an unobstructed line of sight to four or more GPS satellites. A geographic information system (GIS) or geospatial information system is any system that captures, stores, analyzes, manages, and presents data that are linked to location(s). In the simplest terms, GIS is the merging of cartography, statistical analysis, and database technology.

GIS/GPS Programming

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.