title: saving select result into variable
body: <p>I'm having some problem with this statement</p>
  
  <pre><code>declare @result int
  
  select @result =   (select 1 union select 2)
  
  select @result
  </code></pre>
  
  <p>Msg 512, Level 16, State 1, Line 2
  Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , >, >= or when the subquery is used as an expression.</p>
  
  <p>plz help T_T</p>