title: Getting SQL stored procedure results into data.frame format using RODBC
body: <p>I am using the RODBC package to query for results in my SQL server. I have a certain stored procedure written that, when executed in my SQL Server Mgmt. studio (for example), returns a table. However, when I run the query through R, it returns <code>character(0)</code></p>
  
  <pre><code># Execute command...
  sqlQuery(production,"exec port.tdp_RISK2_ModelRunCompare @ModelRunId1 = 399")
  </code></pre>
  
  <p>Weird thing is... when I do something like...</p>
  
  <pre><code>sqlQuery(production,"exec sp_who")
  </code></pre>
  
  <p>I get a table of results...</p>
  
  <p>Help?</p>