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...