sernst

How to execute an MS SQL stored procedure and then use the results in arcpy???

Discussion created by sernst on Jul 6, 2012
Any help would be most appreciated...

I need to execute an MS SQL stored procedure which creates a temporary table with xy records, and then interact with that temporary table via arcpy to create a point feature class.  I've got the stored procedure built, and I know how to make an XY event layer and then save the records to a feature class.

Is there any way to execute the stored procedure and then use arcpy to interact with the results? 

So far, I cannot find a way to make this work.

Outcomes