title: T-SQL check to see data is in range then select record from table A
body: <p>Table A</p>
  
  <pre><code>ID   name     date_from     date_to      region   manager
  ---------------------------------------------------------
  1    Harry    2019-12-01    2020-01-01    south    ABC
  1    Harry    2020-01-01    2020-03-01    north    BCD
  1    Harry    2020-03-01       NULL       East     DCE
  </code></pre>
  
  <p>Table B</p>
  
  <pre><code>Date          name     H_time    T_time  
  ---------------------------------------
  2019-12-01    Harry     30        20
  2020-01-01    Harry     20        10
  2020-02-01    Harry     40        50
  2020-04-01    Harry     50        60
  </code></pre>
  
  <p>I wanted to check table B date falls into the date range above and return the specific region and manager info like...</p>
  
  <p>Table C</p>
  
  <pre><code>Date          name     H_time    T_time   region  manager
  ---------------------------------------------------------
  2019-12-01    Harry     30        20      south    ABC
  2020-01-01    Harry     20        10      north    BCD
  2020-02-01    Harry     40        50      north    BCD
  2020-04-01    Harry     50        60      East     DCE   
  </code></pre>