title: Transact SQL: selecting a boolean expression
body: <p>Query:</p>
  
  <pre><code>SELECT TOP 1 ReportInvoked , EmailSent
    FROM tblReportInvoker 
   WHERE WebUserId = 12345
  </code></pre>
  
  <p>This gives me two bit values. What I really want is a scalar result that is the logical AND of these two values. Is this possible? This seems like it would be easy but I'm not finding a syntax that will work.</p>
  
  <p>Edit: Of course the flaw in my clever plan is that it will be true if both processes fail, so revised query to:</p>
  
  <pre><code>SELECT TOP 1 (ReportInvoked &amp; EmailSent) &amp; (1 &amp; ReportInvoked) AS 'ReportSent'
  FROM tblReportInvoker 
  WHERE WebUserId = 12345
  </code></pre>