title: T-SQL Skip Take Stored Procedure
body: <p>I don't seem to be having much luck on this site, still forever the optimist, I will keep trying.
  I have two tables, Journals and ArticleCategories that are joined using the this query: </p>
  
  <pre><code>SELECT Journals.JournalId,
         Journals.Year,
         Journals.Title,
         ArticleCategories.ItemText
  FROM   Journals
         LEFT OUTER JOIN ArticleCategories
           ON Journals.ArticleCategoryId = ArticleCategories.ArticleCategoryId 
  </code></pre>
  
  <p>Can anyone tell me how I can re-write this make it into a Skip, Take query.
  In other words, I want to it skip the first n records and then take the next n.
  I think ROW_NUMBER is involved somewhere but I cannot work out how to use it in this case.</p>
  
  <p>I suspect the reason why don't have much luck is that I find it difficult to explain what I am trying to do.
  If my question is not clear, please do not hesitate to tell me where I am going wrong and I will gladly try again.
  Perhaps I should also mention that I am trying to put this in a stored procedure.
  Many Thanks.
  Many thanks,</p>