title: SQL Server paging query
body: <p>Urggggg! I've been struggling with this for a long time! I can do it with MySQL so easy but not with SQL Server :(</p>
  
  <p>Here are the simplified tables which should be joined all together.</p>
  
  <p><img src="https://i.stack.imgur.com/9300W.png" alt="enter image description here"></p>
  
  <p>Combining all of them by using inner join syntax, I have to write a query to use for paging in the future (btw, PHP). Let's say I need all ID, Name, and Date info which a picture is taken between 2012-10-01 and 2012-10-30.... and 20 people per page. </p>
  
  <p>What would be the easiest query to achieve the goal here? (I tried NOT IN.. but it was so buggy cuz I'm not used to 'NOT IN' stuff...)</p>
  
  <p>You can ignore the performance speed.</p>
  
  <p>Thank you!</p>