title: How to retrieve the total row count of a query with TOP
body: <p>I have a SQL Server 2008 query</p>
  
  <pre><code>SELECT TOP 10 *
  FROM T
  WHERE ...
  ORDER BY ...
  </code></pre>
  
  <p>I'd like to get also the total number of the rows. The obious way is to make a second query</p>
  
  <pre><code>SELECT COUNT(*)
  FROM T
  WHERE ...
  ORDER BY ...
  </code></pre>
  
  <p>Is there an efficient method?</p>
  
  <p>Thanks</p>