Skip to content

GitLab

public
Authored by avatar Alexander Herold

Angelegte Backups der BUCHUNGEN, BUZEITEN, BUPAUSEN und ZEITKONTENWERTE löschen, wenn diese bereits vorhanden sind

sql.sql 830 bytes
1 2 3 4 
delete BCK from BCK_BUCHUNGEN BCK where Exists(select BUFINR,BUPENR,BUTAG from BUCHUNGEN BU where BU.BUFINR = BCK.BUFINR and BU.BUPENR = BCK.BUPENR and BU.BUTAG = BCK.BUTAG)
delete BCK from BCK_BUZEITEN BCK where Exists(select BZFINR,BZPENR,BZTAG,BZLNR from BUZEITEN BZ where BZ.BZFINR = BCK.BZFINR and BZ.BZPENR = BCK.BZPENR and BZ.BZTAG = BCK.BZTAG and BZ.BZLNR = BCK.BZLNR)
delete BCK from BCK_BUPAUSEN BCK where Exists(select BPFINR,BPPENR,BPTAG,BPLNR from BUPAUSEN BP where BP.BPFINR = BCK.BPFINR and BP.BPPENR = BCK.BPPENR and BP.BPTAG = BCK.BPTAG and BP.BPLNR = BCK.BPLNR)
delete BCK from BCK_ZEITKONTENWERTE BCK where Exists(select ZWFINR,ZWPENR,ZWMON,ZWJAHR,ZWZKT from ZEITKONTENWERTE ZK where ZK.ZWFINR = BCK.ZWFINR and ZK.ZWPENR = BCK.ZWPENR and ZK.ZWMON = BCK.ZWMON and ZK.ZWJAHR = BCK.ZWJAHR and ZK.ZWZKT = BCK.ZWZKT)
Markdown is supported
0% or .
You are about to add 0 people to the discussion. Proceed with caution.
Finish editing this message first!
Please register or to comment