title: How to display event hour by hour in SQL?
body: <pre><code>Create table tblEvent  ( Event_ID int, Start_Time datetime, End_Time datetime )
  
  insert into tblEvent values(1,'2015-02-10 9:00:00.000','2015-02-10 11:00:00.000')
  insert into tblEvent values(2,'2015-02-10 11:00:00.000','2015-02-10 11:20:00.000')
  insert into tblEvent values(3,'2015-02-10 11:20:00.000','2015-02-10 13:00:00.000')
  </code></pre>
  
  <p>and want to be display like below</p>
  
  <pre><code>Hour  Event_ID  [Start_End]
  9     1         9:00-10:00
  10    1         10:00-11:00
  11    2         11:00-11:20
  11    3         11:20-12:00
  12    3         12:00-13:00
  </code></pre>
  
  <p>and we can make the End_Time of Event 3 become 13:30
  we had to be display  </p>
  
  <pre><code>13    3         13:00-13:30
  </code></pre>
  
  <p>Can anyone help me?</p>