Your solution has worked. Thanks a lot. I put my query here if it helps someone else.

With CTE_EndDate As (

SELECT sto_kod As [Stock Code]

, sto_isim As [Name]

, sto_yabanci_isim As [Foreign...

My table is about promotion related to materials and has just start date, the next start date of promotion is the end date of the previous promotion. I need a...