Requête de fou furieux (en tout cas pour moi)

declare @table table (id int)
declare @tableOK table (id int)
insert into @table
select distinct id from (
SELECT ROW_NUMBER() OVER(PARTITION BY id  ORDER BY Secteur DESC) AS 'sNumber' , 
       id
FROM newbie) as R where R.sNumber=3

DECLARE tnames_cursor CURSOR
FOR
  select id from @table 
OPEN tnames_cursor
DECLARE @id sysname
FETCH NEXT FROM tnames_cursor INTO @id
WHILE (@@FETCH_STATUS <> -1)
BEGIN
-------------------
insert into @tableOK
select id from newbie where id = @id and Secteur=2 and deb > (select max(fin) from newbie where id=@id and Secteur=3)

-------------------
FETCH NEXT FROM tnames_cursor INTO @id
END
CLOSE tnames_cursor
DEALLOCATE tnames_cursor

select * from newbie where id in (select id from @tableOK)

select * from newbie where id in (
select 
    n.id 
    from newbie as n 
    where n.id in (
        select distinct id from 
        (SELECT ROW_NUMBER() OVER(PARTITION BY id  ORDER BY Secteur DESC) AS 'sNumber' , id FROM newbie) as R 
        where R.sNumber=3)
    and deb>(select max(fin) from newbie where id = n.id))