title: SQL server - delete rows where multiple columns have either null or zero value
body: <p>I'm a DB newbie, and am struggling with this.  I have an existing table with the following columns:</p>
  
  <pre><code>Showroom, Salesperson, Time1, Time2, Time3, Dte
  </code></pre>
  
  <p>I'm trying to delete all rows within the table that have either null or zero values in all 3 time columns.  I tried the following:</p>
  
  <pre><code>DELETE FROM myTable 
  WHERE EXISTS(
                SELECT * 
                FROM myTable 
                WHERE (Time1 IS NULL OR Time1 = 0) 
                  AND (Time2 IS NULL OR Time2 = 0) 
                  AND (Time3 IS NULL OR Time3 = 0)
              )
  </code></pre>
  
  <p>Thankfully I'm working on a test version of the database, as I wiped out all of the data.  Any help would truly be appreciated.</p>