title: How do I write a SQL query for a specific date range and date time using SQL Server 2008?
body: <p>I need to write a query that will get all the rows in a specified date range and time range. </p>
  
  <p>For example, I want to query all the rows from 5:00PM on 16-Sep-2010 to 9:00AM on 21-Sep-2010.</p>
  
  <p>Any ideas as to how the query should be?</p>