title: How to assign an exec result to a sql variable?
body: <p>How do you assign the result of an exec call to a variable in SQL?  I have a stored proc called <code>up_GetBusinessDay</code>, which returns a single date.  </p>
  
  <p>Can you do something like this:</p>
  
  <pre><code>exec @PreviousBusinessDay = dbo.up_GetBusinessDay @Date, -1
  </code></pre>