with Table_t As
(
    Select 'a' As id, '20130101020000' As d_datetime, 0 As value   Union All
    Select 'a' As id, '20130101040000' As d_datetime, 1 As value   Union All
    Select 'a' As id, '20130101060000' As d_datetime, 0 As value   Union All
    Select 'a' As id, '20130101140000' As d_datetime, 1 As value   Union All
    Select 'a' As id, '20130101160000' As d_datetime, 0 As value   Union All
    Select 'a' As id, '20130101170000' As d_datetime, 0 As value   Union All
    Select 'a' As id, '20130101200000' As d_datetime, 1 As value   Union All
    Select 'a' As id, '20130101240000' As d_datetime, 0 As value  
)
,Table_t2 As
(
    Select
           a.id
          ,a.d_datetime
          ,a.value
          ,Row_Number() Over ( Order By a.d_datetime Asc) As seq
      From Table_t a
)
,Table_t3 As
(
    Select
           a.id
          ,a.value
          ,a.seq
          ,a.d_datetime
          ,ISNULL(b.d_datetime,'') As d_datetime2
      From Table_t2 a
                      Left Outer Join
                                      (
                                         Select
                                                a.id
                                               ,a.d_datetime
                                               ,a.value
                                               ,a.seq
                                           From Table_t2 a
                                      ) b
                                          On a.seq + 1 = b.seq
                                         And b.value = 0
     Where a.value = 1
)
 Select *
   From Table_t3