topic Re: Geocode SQL 2008 Table and Display using JavaScript API in ArcGIS JavaScript Maps SDK Questions https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/geocode-sql-2008-table-and-display-using/m-p/65562#M5763 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I have a task in which I have a table of addresses in a SQL Server 2008 table.&nbsp; I need to display these as referenced points in a map via JavaScript API.&nbsp; The addresses in the table are dynamic and change, so this won't work as a feature class.&nbsp; What is the best method to accomplish this?&nbsp; Thanks!<BR /><BR />B</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>One approach i would take would be a GP services (Add X, Y as a layer or GeoCode etc. base on your date) with result/event layer on your mxd. There are certain limitations though if your SQL server table does not have OBJECTID field. So I would suggest you registered you table with Geodatabase. It really does not affect non GIS access to the table.</SPAN></BODY></HTML> Thu, 08 Mar 2012 12:51:31 GMT HemingZhu 2012-03-08T12:51:31Z Geocode SQL 2008 Table and Display using JavaScript API https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/geocode-sql-2008-table-and-display-using/m-p/65561#M5762 <HTML><HEAD></HEAD><BODY><SPAN>I have a task in which I have a table of addresses in a SQL Server 2008 table.&nbsp; I need to display these as referenced points in a map via JavaScript API.&nbsp; The addresses in the table are dynamic and change, so this won't work as a feature class.&nbsp; What is the best method to accomplish this?&nbsp; Thanks!</SPAN><BR /><BR /><SPAN>B</SPAN></BODY></HTML> Wed, 07 Mar 2012 22:10:42 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/geocode-sql-2008-table-and-display-using/m-p/65561#M5762 BradOleson 2012-03-07T22:10:42Z Re: Geocode SQL 2008 Table and Display using JavaScript API https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/geocode-sql-2008-table-and-display-using/m-p/65562#M5763 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I have a task in which I have a table of addresses in a SQL Server 2008 table.&nbsp; I need to display these as referenced points in a map via JavaScript API.&nbsp; The addresses in the table are dynamic and change, so this won't work as a feature class.&nbsp; What is the best method to accomplish this?&nbsp; Thanks!<BR /><BR />B</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>One approach i would take would be a GP services (Add X, Y as a layer or GeoCode etc. base on your date) with result/event layer on your mxd. There are certain limitations though if your SQL server table does not have OBJECTID field. So I would suggest you registered you table with Geodatabase. It really does not affect non GIS access to the table.</SPAN></BODY></HTML> Thu, 08 Mar 2012 12:51:31 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/geocode-sql-2008-table-and-display-using/m-p/65562#M5763 HemingZhu 2012-03-08T12:51:31Z