Advertisement
Guest User

delete sociedad

a guest
Mar 18th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.32 KB | None | 0 0
  1. DELETE FROM S_P00_07000134 WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  2. DELETE FROM SE16N_GV_CM WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  3. DELETE FROM T_RESULT_WE WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  4. DELETE FROM ZFI_SCD_2292_1 WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  5. DELETE FROM SE16N_BKPF WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  6. DELETE FROM SE16N_EKBE1 WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  7. DELETE FROM SE16N_EKBE2 WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  8. DELETE FROM SE16N_BKPF2 WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  9. DELETE FROM SE16N_BSEG_WE WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  10. DELETE FROM FBL1N WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  11. DELETE FROM SE16N_BSEG WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  12. DELETE FROM F1001_Base WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  13. DELETE FROM F1001_BaseRET WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  14. DELETE FROM F1001_BaseWE WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  15. DELETE FROM F5247_Base WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  16. DELETE FROM F5247_Ret WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  17. DELETE FROM FB03 WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  18. DELETE FROM FBL3N WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  19. DELETE FROM FBL3N_CTASFALTANTES WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
  20. DELETE FROM S_ALR_87012357 WHERE dbo.splitDate(fecha_contabilizacion) < dbo.splitDate('01.01.$validardatos_anhoActual');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement