title: T-SQL, updating more than one variable in a single select
body: <p>Is it possible to update more than one local variable in a single select?</p>
  
  <p>Something like:</p>
  
  <pre><code>set
      @variableOne = avg(someColumn),
      @variableTwo = avg(otherColumn)
      from tblTable
  </code></pre>
  
  <p>It seems a bit wasteful to make two separate select operations for something as trivial as this task:</p>
  
  <pre><code>set @variableOne = ( select avg(someColumn) from tblTable )
  set @variableTwo = ( select avg(otherColumn) from tblTable )
  </code></pre>