title: Can I copy & paste a SQL result that is over 1 million rows long into Excel?
body: <p>I have been running a mammoth SQL query that is as so:</p>
  
  <pre><code>select SessionID, PID, RespondentID
  from BIG_Sessions (nolock)
  where RespondentID in (
  
  '1407718',
  '1498288',
  /* ETC ETC */
  
  
  )
  </code></pre>
  
  <p>I heard that Excel has a maximum of  1 million rows.  Not sure how to approach this</p>
  
  <p>Table BIG_Sessions is huge. It is pulling multiple SessionID's for a given RespondentID - but I only want one each.</p>
  
  <p>I don't know how to winnow this. Any tips appreciated.</p>