C11/System/ARI/SQL/schema/GC_ETL_ARI/procedures/batch.Create_Verkauf.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE PROCEDURE [batch].[Create_Verkauf]
AS
BEGIN
    BEGIN TRANSACTION;
    DROP TABLE [GC_DWH_ARI].[dbo].[Verkauf];

    SELECT *
    INTO [GC_DWH_ARI].[dbo].[Verkauf]
    FROM [GC_ETL_ARI].[load].[Verkauf];




    CREATE NONCLUSTERED INDEX [Verkauf_Datum]
        ON [GC_DWH_ARI].[dbo].[Verkauf] ([Datum]);


    CREATE NONCLUSTERED INDEX [Verkauf_Monatserster]
        ON [GC_DWH_ARI].[dbo].[Verkauf] ([Monatserster]);
    COMMIT;
END;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO