title: find rows that fall between a day and time of the week in sql server
body: <p>I have a table of rows in MS SQL that contain a start and end day of the week, hour, and time. I need a T-SQL query that can pull rows from that table where GETDATE matches the day of week and time of those rows. Specifically, I need the query to work if a row has a day/time that starts on one day of the week and ends on the next day.</p>
  
  <p>Here's the structure I'm working with:</p>
  
  <p>_start_day_of_week (int) = 5<br/>_start_hour (int) = 15<br/>_start_minute (int) = 30<br/>
  _end_day_of_week (int) = 6<br/>_end_hour (int) = 2<br/>
  _end_minute (int) = 30<br/>
  _title (string) = 'My Sample Row'<br/>
  _id (int) = 1<br/></p>
  
  <p>How would I retrieve this row given the current DATETIME?</p>