WITH DetalhesEventos AS (

  select f.id as IdEvento,
          f.data_inicial as DataInicial,
          g.codigo_evento as CodigoEveto,
          g.descricao as DescricaoEvento,
          h.descricao as SolicitanteEventoParada,
          f.observacao as Observacao
     from composicao as a
     join evento as f on a.id = f.id_composicao
     join evento_descricao as g on f.id_evento_descricao = g.id
left join evento_parada as h on f.id_evento_parada = h.id
    where ( cast(a.data_inicio as date) between cast('2019-05-25' as date) and cast('2019-05-25' as date) )
      and g.codigo_evento = 'P'
      and a.id = '3561'


  union all

 select b.data_inicial as DataFinal
   from DetalhesEventos as a
   join evento as b on a.IdEvento = b.id
   where b.id = a.IdEvento + 1
 )
SELECT * from DetalhesEventos