v5

v4

v4

specific load data: declare @i int --set @i = 10 --set @i = 100 set @i = 1000 truncate table TC80 insert into TC80(GroupId,StartDate,EndDate) select 1,tl.N,tl.N+1 from tsqlc_Tally tl where tl.N < @i

@dishdy You right. I read 'Within a group there will be no two date intervals with the same start date **and** same end date.' ;)

[edit] wrong code, see below some logic: IF OBJECT_ID('TC80','U') IS NOT NULL BEGIN DROP TABLE TC80 END GO CREATE TABLE TC80 ( GroupId INT NOT NULL, StartDate DATETIME NOT NULL, E

another little change

another little change

better perf (for intervals with same startdate)