CREATE procedure [C6StagingPeriodico].[REPTRIM_WSEICE2]  
AS 
BEGIN  
exec [C6StagingPeriodico].[RP_W6LogBatch] 'Replica WSEICE2'
TRUNCATE TABLE [C6StagingPeriodico].[WSEICE2]
INSERT INTO [C6StagingPeriodico].[WSEICE2]
           ([DTTRIM]
           ,[RETE]
           ,[CODFIS]
           ,[CODMAN]
           ,[CODEMI]
           ,[TOTCTV]
           ,[DESCEMI]
           ,[SOGLIACTV_CONC]
           ,[RATING]
           ,[CONC]
           ,[LIMITE_CONC]
           ,[FLGCONC])
SELECT [DTTRIM]
      ,[RETE]
      ,[CODFIS]
      ,[CODMAN]
      ,[CODEMI]
      ,[TOTCTV]
      ,[DESCEMI]
      ,[SOGLIACTV_CONC]
      ,[RATING]
      ,[CONC]
      ,[LIMITE_CONC]
      ,[FLGCONC]
  FROM FSEI0.FSEI0.[fsei0_pdc].[wseice]
  exec [C6StagingPeriodico].[RP_W6LogBatch] 'Replica WSEICE2'
END