title: Generate Missing date and add zero value and add one to existing date in sql
body: <p>I am new to sql and I need to generate missing date and add value 0 and for existing date value as 1.</p>
  
  <p>refereed many example on generating missing date in sql all show, adding 0 to missing date but no solution to add 1 to existing date </p>
  
  <p>i have a table called Alarm and column Alarm_start, Alarm_Start has below data.</p>
  
  <pre><code>2019-03-24 11:36:24.000
  2019-03-25 07:47:49.000
  2019-03-27 09:40:39.000
  2019-03-29 10:04:43.000
  </code></pre>
  
  <p>result needed is only with date and 0 and 1</p>
  
  <pre><code>2019-03-24     1
  2019-03-25     1
  2019-03-26     0
  2019-03-27     1
  2019-03-28     0
  2019-03-29     1
  </code></pre>