{"id":186,"date":"2011-10-14T15:17:49","date_gmt":"2011-10-14T22:17:49","guid":{"rendered":"http:\/\/www.sqldbpros.com\/?p=186"},"modified":"2011-10-17T10:56:24","modified_gmt":"2011-10-17T17:56:24","slug":"execute-stored-procedure-from-excel-with-temp-table","status":"publish","type":"post","link":"http:\/\/sqldbpros.com\/wordpress\/2011\/10\/execute-stored-procedure-from-excel-with-temp-table\/","title":{"rendered":"Execute Stored Procedure From Excel With Temp Table"},"content":{"rendered":"<p>Do you want to execute a stored procedure from Excel?\u00a0 No problem!\u00a0 Does your proc contain a temp table? Problem!\u00a0 Actually, don't panic.\u00a0 The fix is incredibly simple.\u00a0 Tracking down this post was probably the most difficult part.\u00a0 When executing a SQL Server proc with a temp table you must remember to \"SET NOCOUNT ON\" at the beginning of the procedure.<\/p>\n<p>Shout out to <a title=\"The NYC DBA\" href=\"http:\/\/nyc-dba.blogspot.com\/2011\/07\/query-did-not-run.html\" target=\"_blank\">The NYC DBA<\/a> for solving this issue for me!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do you want to execute a stored procedure from Excel?\u00a0 No problem!\u00a0 Does your proc contain a temp table? Problem!\u00a0 Actually, don't panic.\u00a0 The fix is incredibly simple.\u00a0 Tracking down this post was probably the most difficult part.\u00a0 When executing a SQL Server proc with a temp table you must remember to \"SET NOCOUNT ON\" [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,26],"tags":[20,25,170,10,9,5],"class_list":["post-186","post","type-post","status-publish","format-standard","hentry","category-businss-intelligence","category-charts-and-graphs","tag-business-intelligence","tag-chart","tag-excel","tag-ms-sql","tag-sql-server","tag-tips"],"_links":{"self":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/comments?post=186"}],"version-history":[{"count":4,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/186\/revisions"}],"predecessor-version":[{"id":188,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/186\/revisions\/188"}],"wp:attachment":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/media?parent=186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/categories?post=186"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/tags?post=186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}