It's much better, perf are really near the cursor, it seems to be a little bit much better. Thanks !

It's working, but cursor is more than 100 times faster than recursive CTE. So it's seems to be a bad idea to try to replace it by a query.

Hi,

The Data :

DECLARE @Planning_Proposal_Temp AS TABLE(object varchar(10), dateFrom datetime2, dateTo datetime2)
INSERT INTO @Planning_Proposal_Temp(object, dateFrom, dateTo ) 
SELECT * 
  FROM (VALUES 
    ...

• This reply was modified 5 years ago by  jolann69.

Hi,

Sorry but it is not very easy for me to explain clearly what i need in English.

I need to return for each Object all possible couple of date that are...

• This reply was modified 5 years ago by  jolann69.
• This reply was modified 5 years ago by  jolann69.
• This reply was modified 5 years ago by  jolann69.
• This reply was modified 5 years ago by  jolann69.
• This reply was modified 5 years ago by  jolann69.

Effectivly, it' is between the previous row, but not between the previous row that is return by the select.

it is for a booking application, i have to return all possible...

Hi,

Really Thanks for your help.

@koti.raavi, i have try your solution : With LEAD, it's return all rows :

With LAG we are near the good result, but it's...

• This reply was modified 5 years ago by  jolann69.

Hi,

Thanks for your answers.

Jonathan solution doesn't work for my case. Because in the sample i have just put few rows, but in fact i have hundreds of raw, and i...

• This reply was modified 5 years ago by  jolann69.