title: Get data using the Date Range when 'WHERE NOT EXISTS' is used
body: <p>From the table I need get data using the Date Range on the below query mentioned when <strong>'WHERE NOT EXISTS'</strong> is used in SQL Server.</p>
  <pre><code>declare @Start DATETIME, 
          @End DATETIME 
  
      Set @Start = '01/01/2020'
      Set @End  = '01/15/2020'
  
  select A.request_id, A.order_id
         from table_a A
  where not exists (select * from table_b B where B.request_id=A.request_id 
         and B.order_id=A.order_id)
  and WHERE (provided_date between @Start and @End)
  </code></pre>
  <p><strong>need to include</strong> <code>WHERE provided_date between @Start and @End</code></p>
  <p>When date range is applied, I need the data for the provided date range. How do I achieve this?
  Please find the below table and expected output:</p>
  <p><code>**TABLE A**</code></p>
  <pre><code>request_id|order_id|Provided_Date
  10        |2567    |01/01/2020
  20        |4784    |01/03/2020
  30        |2578    |01/07/2020
  40        |8432    |01/10/2020
  50        |9032    |01/13/2020
  </code></pre>
  <p><code>**TABLE B**</code></p>
  <pre><code>request_id|order_id|Provided_Date
  30        |2578    |01/07/2020
  40        |8432    |01/10/2020
  </code></pre>
  <p><code>**EXPECTED OUTPUT**</code></p>
  <pre><code>request_id|order_id|Provided_Date
  10        |2567    |01/01/2020
  20        |4784    |01/03/2020
  50        |9032    |01/13/2020
  </code></pre>