t sql – stored procedure delete after today then insert the new insert

I am news on sql server

I have to create a procedure (my first time) in order tooverwrite just the rows after today

I have this table created by myself

with calendario_esteso_ISP
as
(select
CM.DimDate_Date,
SA.Indice,
SA.ambito,
SA.Capacity,
‘esterna’ as esterna
–into calendario_esteso_ISP
from (dbo).(calendari0_2020) CM
left join Capacity SA
on 1=1
order by
Cm.DimDate_Date asc,
Indice)

select
CE.DimDate_Date,
CE.Indice,
CE.ambito,
CE.Capacity,
–sum(Ft.(Effort Attuale)),
isnull(sum(FT.(Effort Attuale)/ CE.Capacity * 100),0) as Saturazione
from calendario_esteso_ISP CE
left join Fact_Table_ FT
on CE.esterna = FT.(Tipo attività) and CE.DimDate_Date between FT.Data_Inizio_Pianificata and FT.Data_Fine_Pianificata and CE.ambito = FT.Ambito
group by
CE.DimDate_Date,
CE.Indice,
CE.ambito,
CE.Capacity
order by
1,2

So the field are

CE.DimDate_Date,
CE.Indice,
CE.ambito,
CE.Capacity,

This will be my store procedure that will work every night overwriting delete and insert) the rows after today ( DimDate_date)

I am a begginer and i no idea about i neve wrote a store procedure before

Can someone help me

Kind regards
Thomas