topic How to execute an MS SQL stored procedure and then use the results in arcpy??? in Python Questions https://community.esri.com/t5/python-questions/how-to-execute-an-ms-sql-stored-procedure-and-then/m-p/331318#M25777 <HTML><HEAD></HEAD><BODY><SPAN>Any help would be most appreciated...</SPAN><BR /><BR /><SPAN>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.&nbsp; 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.</SPAN><BR /><BR /><SPAN>Is there any way to execute the stored procedure and then use arcpy to interact with the results?&nbsp; </SPAN><BR /><BR /><SPAN>So far, I cannot find a way to make this work.</SPAN></BODY></HTML> Fri, 06 Jul 2012 16:29:30 GMT ShawnaErnst 2012-07-06T16:29:30Z How to execute an MS SQL stored procedure and then use the results in arcpy??? https://community.esri.com/t5/python-questions/how-to-execute-an-ms-sql-stored-procedure-and-then/m-p/331318#M25777 <HTML><HEAD></HEAD><BODY><SPAN>Any help would be most appreciated...</SPAN><BR /><BR /><SPAN>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.&nbsp; 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.</SPAN><BR /><BR /><SPAN>Is there any way to execute the stored procedure and then use arcpy to interact with the results?&nbsp; </SPAN><BR /><BR /><SPAN>So far, I cannot find a way to make this work.</SPAN></BODY></HTML> Fri, 06 Jul 2012 16:29:30 GMT https://community.esri.com/t5/python-questions/how-to-execute-an-ms-sql-stored-procedure-and-then/m-p/331318#M25777 ShawnaErnst 2012-07-06T16:29:30Z