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!

Leave a Reply

Your email address will not be published.