title: SQL dynamic date but fixed time query
body: <p>I am trying to write a sql query like the example below, however, I need it to always choose the DateEntered field between the current day's date at 8:00am and the current day's date at 4:00pm. Not sure how to go about this. Can someone please help?</p>
  
  <pre><code>SELECT     OrderNumber
      , OrderRelease
      , HeatNumber
      , HeatSuffix
      , Operation
      , COUNT(Operation) AS [Pieces Out of Tolerance]
  FROM         Alerts
  WHERE     (Mill = 3) 
      AND (DateEntered BETWEEN GetDate '08:00' AND GetDate '16:00')
  GROUP BY OrderNumber, OrderRelease, HeatNumber, HeatSuffix, Operation
  </code></pre>