title: Select top 10 records for each category
body: <p>I want to return top 10 records from each section in one query. Can anyone help with how to do it?  Section is one of the columns in the table.</p>
  
  <p>Database is SQL Server 2005. I want to return the top 10 by date entered.  Sections are business, local, and feature.  For one particular date I want only the top (10) business rows (most recent entry), the top (10) local rows, and the top (10) features.</p>