Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mickster
Starting Member
10 Posts |
 Posted - 2010-12-23 : 18:25:14
|
| I have a Table which stores a few thousand addresses. I have a report in SSRS that extracts only certain addresses (based on filtering criteria). I would like to build maps into this SSRS report using the Map object.In order for this to work, I need the spatial data for these addresses (i.e., latitudes and longitudes). How can I get the latitude / longitude for each address in the database?I will be using the Geography data type to store the spatial data. Also, these addresses are constantly changing so it is not enough for me to use batchgeo.com or some other service to get the spatial data.Thanks in advance |
|
|
areeba
Starting Member
3 Posts |
Posted - 2010-12-27 : 23:45:17
|
| aoa can any one tell me how we can trace specific stored procedures through sql server profiler.especially how we will write their object name. |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-12-28 : 20:37:39
|
| 1. are you willing to pay for spatial data, there are companies that offer this service?2. What do you mean the addresses are always changing?If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
SQL Server 2008 and Spatial Data