title: Select Top into Different Variables
body: <p>Probably not possible but I thought I would ask;</p>
  
  <p>I want to get the <code>Top</code> and save each into a different variable. I know that it would be possible with 3 selects and taking the 1st, 2nd, 3rd from the <code>Top 3</code> but I was hoping it might be possible in one statement?</p>
  
  <p>I.E.</p>
  
  <pre><code>Declare @Var1 as int,
  Declare @Var2 as int,
  Declare @Var3 as int
  select Top 3 [SAVE 3 RETURNED RECORDS INTO VARIABLES] from Table
  </code></pre>