title: How to query for consecutive days with null records?
body: <p>I am currently working on a task that queries for a certain type of record. If it is null or less than 1 for the current date an email sends out. That part is pretty straight forward. Now a requirement has been added to get a count for how many days consecutively this has been happening.</p>
  <p>If there are no records in the table, there are no dates to check on, so I'm not entirely sure what to do.</p>
  <p>If I query on multiple dates then it destroys the code which is built upon emailing on a null result.</p>