1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| delete from [111.11.1.111].[PROTECT].dbo.C1_AIG_BUC_PROD
where indice in (select indice from C1_AIG_BUC
where [DATE] = CONVERT(varchar, getdate(),112)
or [DATE] = CONVERT(varchar, getdate()-1,112)
)
--
delete from [111.11.1.111].[PROTECT].dbo.AIG_BUC_PROD
where indice in (select indice from C1_AIG_BUC
where [DATE] = CONVERT(varchar, getdate(),112)
or [DATE] = CONVERT(varchar, getdate()-1,112)
)
insert into [111.11.1.111].[PROTECT].dbo.C1_AIG_BUC_PROD select * from C1_AIG_BUC
where INDICE not in (select INDICE from [111.11.1.111].[PROTECT].dbo.C1_AIG_BUC_PROD)
insert into [111.11.1.111].[PROTECT].dbo.AIG_BUC_PROD select * from AIG_BUC
where INDICE not in (select INDICE from [111.11.1.111].[PROTECT].dbo.AIG_BUC_PROD) |
Partager