where not exist UniqueField

[#1]

Dear friends ,

I need to add new data to my old data in QVD

but i need to replace only 8 past days , today()-8 in each reload ,

i need to keep the data beyond the 8 days ago ,,(Inkrementation)

when i reload the QV runover all my DataBase

how can i proceed ?

lavea:
SELECT DAILY.Abs_nowage, DAILY.Abs_prem, DAILY.Abs_wage, DAILY.Abs1_abs_code, DAILY.Abs1_abs_val, DAILY.Abs1_actual, DAILY.Abs1_end, DAILY.Abs1_event_type, DAILY.Abs1_excp_code, DAILY.Abs1_manual_code, DAILY.Abs1_manual_line, DAILY.Abs1_manual_val, DAILY.Abs1_paid_val, DAILY.Abs1_round, DAILY.Abs1_start, DAILY.Abs1_wage_ind, DAILY.Abs10_abs_code, DAILY.Abs10_abs_val, DAILY.Abs10_actual , EMPLOYEE&DATE AS UNIQUEFIELD

FROM TKSQL.dbo.DAILY

WHERE NOT EXISTS (UNIQUEFIELD)

CONCATENATE
LOAD
DAILY.Abs_nowage, DAILY.Abs_prem, DAILY.Abs_wage, DAILY.Abs1_abs_code, DAILY.Abs1_abs_val, DAILY.Abs1_actual, DAILY.Abs1_end, DAILY.Abs1_event_type, DAILY.Abs1_excp_code, DAILY.Abs1_manual_code, DAILY.Abs1_manual_line, DAILY.Abs1_manual_val, DAILY.Abs1_paid_val, DAILY.Abs1_round, DAILY.Abs1_start, DAILY.Abs1_wage_ind, DAILY.Abs10_abs_code, DAILY.Abs10_abs_val, DAILY.Abs10_actual

STORE lavea INTO "P:\Carmiel I\qvw_lavea\lavea.qvd" (qvd)

DROP TABLE lavea;