I have tried this following code but it did not fully worked, somehow it manages to cap date range,

SELECT

f.empnr,

f.FromDate ,

min(s.ToDate) AS ToDate ,

sum(f.totaldays) as TDays

FROM [dbo].[Result] f

INNER JOIN

[dbo].[Result] s ON

f.FromDate...

Oops, my bad, I am posting again new spread sheet to clarify

Please have a look at it now, if its better explained now , however if there are more questions...

When any row is mistakenly added by HR personal, they nullify it with another row to make a balance.

you will see more of such rows in the data which i...

Hi ,

Thank you for the correction , here is my table with code. I have included three employees sick leave dates.

you can change the date to date format for your...

Thanks for quick reply @Ant-Green, I was not so quick in thanking you though :).

you are right there are other niches in the data which i totally mis-understood.  I am...