hi all   i hoping me improve query have run periodically. @ moment takes more 40 minutes execute. uses full allocated memory during time, cpu usage meanders @ 2% - 5%, every , jumping 40% few seconds.   i have table (simplified example):       create table [dbo].[datatable]     (     [id] [int] identity(1,1) not null,     [dteeffectivedate] [date] null,     [dteprevious] [date] null,     [dtenext] [date] null,     [age] [int] null,     [count] [int] null     ) on [primary]      go   here input values:   insert [yourdb].[dbo].[datatable]            ([dteeffectivedate]            ,[dteprevious]            ,[dtenext]            ,[age]            ,[count])      values ('2009-01-01',null,'2010-01-01',40,300), ('2010-01-01','2009-01-01', null,40,200), ('2009-01-01',null, '2010-01-01',20,100), ('2010-01-01','2009-01-01', null,20,50), ('2009-01-01',null,'2010-01-01',30,10) go   each entry has dteeffectivedate f...