better perf (for intervals with same startdate)

The challenge is to find the minimal set of intervals without creating gaps. There is a table with groups of redundantly overlapping date intervals where each group has no gaps. Given this table, your job is to find the minimum set of date intervals witho

@dishdy thanks, btw - very interesting challenge and small logic fix (no effect on result) ,row_number() over (partition by c3.GroupId order by c3.sort1,c3.sort2,c3.sort3,c3.hist) should be ,row_number() over (partition by c3.GroupId ord

thanks

thanks

pub

pub

pub

pub

Find out the new features and enhancements added into SQL Server 2012, codenamed "Denali"...