SQL find Customers that haven't been contacted in the past 45 days, Sql Server

Language: Layout:

create table contact (dates date, companies varchar(64))
insert into contact values 
 ('20170102','Facebook')
,('20170103','Chevron')
,('20170105','AFLAC')
,('20170109','Applied Industrial Technologies')
,('20170111','Charter Communications')
,('20170112','Coca-Cola')
,('20170113','Dow Chemical')
,('20170117','Foot Locker')
,('20170118','General Dynamics')
,('20170120','Humana')
,('20170125','Imation')
,('20170126','Kimberly-Clark')
,('20170127','3M')
,('20170130','Facebook')
,('20170131','Chevron')
,('20170201','Foot Locker')
,('20170203','General Dynamics')
,('20170206','Humana')
,('20170210','Imation')
,('20170217','Kimberly-Clark')
,('20170220','3M')
,('20170221','Public Storage')
,('20170222','Qualcomm')
,('20170224','Sealy')
,('20170228','Steelcase')
,('20170202','Textron')
,('20170206','Men''s Wearhouse')
,('20170208','Toll Brothers')
,('20170209','Tractor Supply')
,('20170213','USG')
,('20170214','Valspar')
,('20170215','Waste Management')
,('20170220','Williams-Sonoma')
,('20170221','Yahoo')
,('20170223','Union Pacific')
,('20170224','Foot Locker')
,('20170227','General Dynamics')
,('20170228','Humana')
,('20170301','Imation')
,('20170302','Kimberly-Clark')
,('20170303','3M')
,('20170306','Public Storage')
,('20170309','Qualcomm')
,('20170310','Sealy')
,('20170313','Steelcase')
,('20170314','Textron')
,('20170317','Men''s Wearhouse')
,('20170323','Toll Brothers')
,('20170324','Tractor Supply')
,('20170327','USG')
,('20170301','Valspar')
,('20170303','Waste Management')
,('20170306','Williams-Sonoma')
,('20170307','Yahoo')
,('20170308','Union Pacific')
,('20170309','Foot Locker')
,('20170313','General Dynamics')
,('20170315','Humana')
,('20170322','Imation')
,('20170324','Kimberly-Clark')
,('20170327','3M')
,('20170328','Capital One Financial')
,('20170329','CBS')
,('20170403','Citigroup')
,('20170405','E*Trade Financial')
,('20170406','El Paso')
,('20170407','Goodrich')
,('20170410','Hanesbrands')
,('20170411','International Paper')
,('20170412','Eastman Kodak')
,('20170420','Kraft Foods')
,('20170425','LSI')
,('20170426','Macy''s')
,('20170427','Brunswick')
,('20170428','Meredith')
,('20170403','Manpower')
,('20170404','NCR')
,('20170405','Oracle')
,('20170407','Pepsi Bottling')
,('20170410','Pfizer')
,('20170413','Penn National Gaming')
,('20170414','Prudential Financial')
,('20170417','RadioShack')
,('20170418','Regal Entertainment Group')
,('20170424','SanDisk')
,('20170426','Facebook')
,('20170501','Chevron')
,('20170504','AFLAC')
,('20170505','Applied Industrial Technologies')
,('20170508','Charter Communications')
,('20170509','Coca-Cola')
,('20170510','Dow Chemical')
,('20170511','Foot Locker')
,('20170515','General Dynamics')
,('20170516','Humana')
,('20170517','Imation')
,('20170519','Kimberly-Clark')
,('20170524','3M')
,('20170525','Facebook')
,('20170526','Chevron')
,('20170501','Foot Locker')
,('20170504','General Dynamics')
,('20170508','Humana')
,('20170512','Imation')
,('20170515','Kimberly-Clark')
,('20170516','3M')
,('20170518','Public Storage')
,('20170519','Qualcomm')
,('20170522','Sealy')
,('20170524','Steelcase')
,('20170526','Textron')
,('20170529','Men''s Wearhouse')
,('20170530','Toll Brothers')
,('20170531','Tractor Supply')
,('20170607','USG')
,('20170609','Facebook')
,('20170613','Chevron')
,('20170614','AFLAC')
,('20170615','Applied Industrial Technologies')
,('20170619','Charter Communications')
,('20170620','Coca-Cola')
,('20170622','Dow Chemical')
,('20170623','Foot Locker')
,('20170626','General Dynamics')
,('20170628','Humana')
,('20170601','Imation')
,('20170602','Kimberly-Clark')
,('20170605','3M')
,('20170606','Facebook')
,('20170607','Chevron')
,('20170608','Foot Locker')
,('20170612','General Dynamics')
,('20170613','Humana')
,('20170614','Imation')
,('20170616','Kimberly-Clark')
,('20170620','3M')
,('20170621','Public Storage')
,('20170622','Qualcomm')
,('20170629','Sealy')
,('20170630','Steelcase')
,('20170711','Textron')
,('20170712','Men''s Wearhouse')
,('20170713','Toll Brothers')
,('20170714','Tractor Supply')
,('20170719','USG')
,('20170721','Facebook')
,('20170724','Chevron')
,('20170725','AFLAC')
,('20170726','Applied Industrial Technologies')
,('20170727','Charter Communications')
,('20170801','Coca-Cola')
,('20170802','Dow Chemical')
,('20170810','Foot Locker')
,('20170811','General Dynamics')
,('20170815','Humana')
,('20170816','Imation')
,('20170817','Kimberly-Clark')
,('20170821','3M')
,('20170823','Facebook')
,('20170824','Chevron')
,('20170825','Foot Locker')
,('20170829','General Dynamics')
,('20170830','Humana')
,('20170831','Imation')
,('20170907','Kimberly-Clark')
,('20170908','3M')
,('20170913','Public Storage')
,('20170914','Qualcomm')
,('20170915','Sealy')
,('20170920','Steelcase')
,('20170921','Textron')
,('20170922','Men''s Wearhouse')
,('20170925','Toll Brothers')
,('20170926','Tractor Supply')
,('20170927','USG')
,('20170904','Facebook')
,('20170905','Chevron')
,('20170906','AFLAC')
,('20170911','Applied Industrial Technologies')
,('20170913','Charter Communications')
,('20170914','Coca-Cola')
,('20170915','Dow Chemical')
,('20170920','Foot Locker')
,('20170921','General Dynamics')
,('20170922','Humana')
,('20170926','Imation')
,('20170927','Kimberly-Clark')
,('20170929','3M')
,('20171002','Facebook')
,('20171003','Chevron')
,('20171005','Foot Locker')
,('20171011','General Dynamics')
,('20171012','Humana')
,('20171016','Imation')
,('20171018','Kimberly-Clark')
,('20171019','3M')
,('20171020','Public Storage')
,('20171023','Qualcomm')
,('20171024','Sealy')
,('20171026','Steelcase')
/*
    select distinct companies
    from [dbo].[Contact] c
    where not exists (
      select 1
      from [dbo].[Contact] i
      where i.companies = c.companies
        and i.dates >= convert(date,dateadd(day,-45,getdate()))
      )
--*/
    select 
        companies
      , LastContact = convert(char(10),max(dates),120)
    from [dbo].[Contact] c
    group by companies
    having max(dates)<convert(date,dateadd(day,-45,getdate()))

View schema
Execution time: 0,03 sec, rows selected: 29, rows affected: 200, absolute service time: 0,2 sec