Execute Stored Procedure From Excel With Temp Table

Do you want to execute a stored procedure from Excel?  No problem!  Does your proc contain a temp table? Problem!  Actually, don't panic.  The fix is incredibly simple.  Tracking down this post was probably the most difficult part.  When executing a SQL Server proc with a temp table you must remember to "SET NOCOUNT ON" at the beginning of the procedure.

Shout out to The NYC DBA for solving this issue for me!

By Phil Steffek

Phil Steffek is a professional sumo wrestler who is hoping to represent the U.S. in the next Olympics. During the off season Phil is a Data Architect working on transactional databases, data warehouse implementations, and all aspects of business intelligence. Also, Phil is not really a sumo wrestler. You can get to know a bit more about my non-sumo doings by checking out my LinkedIn Page

Leave a comment

Your email address will not be published. Required fields are marked *