Execute SQL Server stored procedures from ArcGIS 10.1

IreneGM

Hi all,

I would like to know if it is possible to execute an already-defined stored procedure (in SQL Server) from ArcGIS 10.1 and use its output data as an input for my maps.

For example, the stored procedure receives some input parameters (date, status, type) and returns back a table with two columns, the first one with a polygon ID and the second is an integer that represents the number of points in the polygon matching the input parameters. So i would like to associate to my map, that column with the number of occurrences.

Is this possible? If so, how this would be done?

Please, could you provide some guidelines or link to a tutorial?

Thanks! 🙂

VinceAngelo

You can of course execute a SQL procedure in any number of ways, but the method
you  describe doesn't match any of the existing models for accessing spatial data.
ArcGIS can read a table or view registered with an ArcSDE geodatabase, it can read
a table or view with a geometry column and a unique integer id through Query Layers,
and it can compute a point from x/y data in a table, but I don't know of any way that
you can join a stored procedure to a table with a geometry column using a SELECT
statement.

If you changed your procedure to populate a 1:1 table with the matching IDs, then
you could fashion a query or view to access the geometry column.

- V