declare @datum varchar(10)
set @datum='2000.01.01'


delete from a_leltar_felv where datum<@datum
delete from akcio_tv where vdatum<@datum
delete from bevett where bizszam in (select bizszam from bevetf where datum<@datum)
delete from bevetf where datum<@datum
delete from error where left(ido,10)<@datum
delete from foglalasok where meddig<@datum
delete from havi_keszlet where datum<@datum
delete from kivett where bizszam in (select bizszam from kivetf where datum<@datum)
delete from kivetf where datum<@datum
delete from leltar_keszlet where leltar_datum<@datum
delete from rmozgast where bizszam in (select bizszam from rmozgasf where datum<@datum)
delete from rmozgasf where datum<@datum
delete from szall_arajant where bizszam in (select bizszam from szall_arajanf where aj_keres_datum<@datum)
delete from szall_arajanf where aj_keres_datum<@datum
delete from szall_art where bizszam in (select bizszam from szall_arf where vdatum<@datum)
delete from szall_arf where vdatum<@datum
delete from szall_rent where bizszam in (select bizszam from szall_renf where datum<@datum)
delete from szall_renf where datum<@datum
delete from szall_szlat where bizszam in (select bizszam from szall_szlaf where telj_datum<@datum)
delete from szall_szla_afa where bizszam in (select bizszam from szall_szlaf where telj_datum<@datum)
delete from szall_szlat_td where bizszam in (select bizszam from szall_szlaf where telj_datum<@datum)
delete from szall_szlaf where telj_datum<@datum
delete from szall_szlet where bizszam in (select bizszam from szall_szlef where telj_datum<@datum)
delete from szall_szlef_import where bizszam in (select bizszam from szall_szlef where telj_datum<@datum)
delete from szall_szlet_td where bizszam in (select bizszam from szall_szlef where telj_datum<@datum)
delete from szall_szlef where telj_datum<@datum
delete from vevo_akcio where vdatum<@datum
delete from vevo_akcio_hh where megszunt<>''
delete from vevo_akcio_me where vdatum<@datum
delete from vevo_akcio_ve where megszunt<>''
delete from vevo_ar_lista where datum<'2000.01' and exists
(select * from vevo_ar_lista as a where datum>='2000.01' and a.arcsoport=vevo_ar_lista.arcsoport)
delete from vevo_arajant where bizszam in (select bizszam from vevo_arajanf where datum_ig<@datum) 
delete from vevo_arajanf where datum_ig<@datum
delete from vevo_arajanlatt where bizszam in (select bizszam from vevo_arajanlatf where datum_ig<@datum) 
delete from vevo_arajanlatf where datum_ig<@datum
delete from vevo_pszlat where bizszam in (select bizszam from vevo_pszlaf where telj_datum<@datum) 
delete from vevo_pszlaf where telj_datum<@datum
delete from vevo_rent where bizszam in (select bizszam from vevo_renf where rend_dat<@datum) 
delete from vevo_ren_datum where bizszam in (select bizszam from vevo_renf where rend_dat<@datum) 
delete from vevo_ren_web where bizszam in (select bizszam from vevo_renf where rend_dat<@datum) 
delete from vevo_renf where rend_dat<@datum
delete from vevo_szlat where bizszam in (select bizszam from vevo_szlaf where telj_datum<@datum) 
delete from vevo_szlaf_export where bizszam in (select bizszam from vevo_szlaf where telj_datum<@datum) 
delete from vevo_szlat_nyomt where bizszam in (select bizszam from vevo_szlaf where telj_datum<@datum) 
delete from vevo_szlat_td where bizszam in (select bizszam from vevo_szlaf where telj_datum<@datum) 
delete from vevo_szlat_td1 where bizszam in (select bizszam from vevo_szlaf where telj_datum<@datum) 
delete from vevo_szlaf where telj_datum<@datum
delete from vevo_szlet where bizszam in (select bizszam from vevo_szlef where telj_datum<@datum) 
delete from vevo_szlet_td where bizszam in (select bizszam from vevo_szlef where telj_datum<@datum) 
delete from vevo_szlef where telj_datum<@datum
delete from vonal where cikk_szam not in (select cikk_szam from cikkek)