title: get row number of record in resultset sql server
body: <p>I have a table full of documents with serial numbers - columns:</p>
  
  <ul>
  <li>docid int</li>
  <li>writing text</li>
  <li>submissionDate datetime </li>
  </ul>
  
  <p>...and I'd like to find out where a particular serial number lies in a query against the table.</p>
  
  <p>For example, if I ordered the resultset by submissionDate asc, I might want to know where document 34 is within that ordering (i.e. is it in position 11?)</p>
  
  <p>How do I do this?</p>