I'd like to find all rows where the time portion of a date_time column is between 11:00AM and 1:15PM.

I seem to get into quite a rat's nest of convert(), datediff() and dateadd() combinations when looking for a simple way to do this.

Thanks,
Mike