title: Requesting for Query
body: <pre><code>Create table #job(id int,start_time datetime,end_time datetime)
  
  insert into #job values(1,'2012-08-06 11:30:00.000','2012-08-06 15:30:00.000')
  insert into #job values(1,'2012-08-06 15:30:00.000','2012-08-06 16:30:00.000')
  insert into #job values(2,'2012-08-06 16:30:00.000','2012-08-06 17:30:00.000')
  insert into #job values(1,'2012-08-06 17:30:00.000','2012-08-06 18:30:00.000')
  </code></pre>
  
  <p>I need the data as below and i need only the <strong>having id = 1</strong></p>
  
  <p>answer should be like below.</p>
  
  <pre><code>1 '2012-08-06 11:30:00.000' '2012-08-06 16:30:00.000'
  1 '2012-08-06 17:30:00.000'  '2012-08-06 18:30:00.000' 
  </code></pre>