title: calculate number of pages of records in select statement
body: <p>SO I am trying to figure out how many pages I will need to display my records, basically want a page count.</p>
  
  <p>I was going to do something like this:</p>
  
  <pre><code>SELECT COUNT(*) % 50 
  FROM Customers 
  WHERE ManufacturerID=@ManufacturerID 
  AND ModifiedOn &gt; @tStamp
  </code></pre>
  
  <p>SO for that statement I would want to get back a 2 for 99 records, 2 for 100, and 3 for 101</p>
  
  <p>Will this work?  Is this a bad practice? Seems a little wonky on me testing some values.</p>
  
  <p>EDIT FOR CLARIFICATION:
  I don't want to get the paged records, just the total number of pages</p>