title: How to store multiple values from SELECT in SQL Server?
body: <p>Is there a way to store the results of a SELECT query in a stored proc using SQL Server?</p>
  
  <p>In the example below I would like to store both "one", and "two" from the select query.</p>
  
  <p>Example:</p>
  
  <pre><code>DECLARE @Values ???
  SET @Values = (SELECT one, two FROM dummyTable)
  </code></pre>