title: Pagination sql query
body: <p>Why is this query not working in Sql Server 2008?</p>
  
  <pre><code>Select Top @PageSize Skip @Page * @PageSize * From someTable
  </code></pre>
  
  <p>Strangely even this doesn't work :-</p>
  
  <pre><code>Select Top @PageSize * From Tree
  </code></pre>
  
  <p>But this one works :-</p>
  
  <pre><code>Select Top 10 * From Tree
  </code></pre>
  
  <p>This statement is inside Stored procedure.</p>
  
  <p>Thanks in advance :)</p>