sharonsql2013 (7/25/2016)
Hi ,I am trying to plot map in Reporting tool. I see that we need spatial data in SQL.
All our SQL table has is Country , City and Region. How should I go about getting Longitude and latitudes?
Quick suggestion, download and import the data you need from GeoNames[/url], good source for spatial data.
😎