Хранимая процедура для удаления

declare @t table (id int identity primary key, s_id int, ds datetime, de datetime);
 
insert into @t
values
(1, '17.10.2015 10:00', '17.10.2015 11:00'),
(1, '17.10.2015 10:30', '17.10.2015 12:00'),
(1, '17.10.2015 11:30', '17.10.2015 13:00'),
(1, '17.10.2015 12:20', '17.10.2015 13:00');
 
declare t cursor local dynamic for
 select id, s_id, ds, de from @t order by s_id, ds;
 
declare @id int, @s_id int, @ds datetime, @de datetime, @c__s_id int, @c__ds datetime, @c__de datetime;
 
open t;
while 1 = 1
 begin
  fetch next from t into @id, @s_id, @ds, @de;
  if @@fetch_status <> 0
   break;
 
  if @c__s_id is null or @s_id <> @c__s_id or @ds not between @c__ds and @c__de
   select
    @c__s_id = @s_id, @c__ds = @ds, @c__de = @de;
  else
   delete from @t where id = @id;
 end;
close t;
deallocate t;
 
select * from @t;