TSQL Where Clause Meeting Multiple Conditions
<p>I have a basic select query that is pulling in the results of a queue to our page. I am trying to add in some logic to the <code>where</code> clause that prevents records from showing when they contain a specific set of values.</p>

<pre><code>WHERE (
        (L.requestType &lt;&gt; 'Check')
        AND (L.requestStatus &lt;&gt; 'New Request')
        AND (DATEDIFF(hour, CAST(L.requestDate AS DATE), GETDATE()) between 0 and 48)
      )
</code></pre>

<p>In the example above, I don't want to include records that have all three data points.</p>

<p>When doing some testing, it is excluding All "Checks" for example even though those records do not also meet the other two pieces of criteria.</p>

<p>How can I go about making my <code>where</code> clause meet all criteria and not do what appears to be an <code>or</code>?</p>