title: SQL Select all days in a year with 9 blank INT fields
body: <p>I am trying to get all dates in a year in a <code>SELECT</code> statement with 9 INT fields that have a value of 0 in them.</p>
  
  <p>So basically I need the following:</p>
  
  <pre><code>1/1/2007 0 0 0 0 0 0 0 0 0
  1/2/2007 0 0 0 0 0 0 0 0 0
  1/3/2007 0 0 0 0 0 0 0 0 0 
  </code></pre>
  
  <p>and so on and so on for a whole year.</p>
  
  <p>The year is always the 1/1 - 12/31</p>
  
  <p>This is part of a bigger query but I don't think that part is necessary as this is the part I need....</p>
  
  <p>Thanks!</p>