if exists(select TB1.* from TB1,TB2 where TB1.A =TB2.A and TB2.DT=convert(varchar(10),getdate(),120))
insert into TB2(A,C,E,DT) select A,C,E,convert(varchar(10),Getdate(),120) from TB1
insert into TB2(A,C,E,DT) select A,C,E,convert(varchar(10),Getdate(),120) from TB1
select
t.A,t.C,t.E,getdate()
from
TB1 t
where
not exists(select 1 from TB2 where A=t.A and datediff(dd,DT,t.DT)=0)
if exists(select TB1.* from TB1,TB2 where TB1.A =TB2.A and TB2.DT=convert(varchar(10),getdate(),120))
insert TB2(A,C,E,DT) select A,C,E,convert(varchar(10),Getdate(),120) from TB1 A
select
t.A,t.C,t.E,getdate()
from
TB1 t
where
a not in(select id from TB2 where A=t.A and datediff(dd,DT,t.DT)=0)