title: Fill in missing timestamp values in SQL
body: <p>SQL newby here looking for a bit of help in writing a query.</p>
  
  <p>Some sample data</p>
  
  <pre>
  Time    Value
  9:00    1.2
  9:01    2.3
  9:05    2.4
  9:06    2.5
  </pre>
  
  <p>I need to fill in those missing times with zero - so the query would return</p>
  
  <pre>
  Time    Value
  9:00    1.2
  9:01    2.3
  9:02    0
  9:03    0
  9:04    0
  9:05    2.4
  9:06    2.5
  </pre>
  
  <p>Is this possible in T-SQL?</p>
  
  <p>Thanks for any help / advice ...</p>