BEGIN TRANSACTION [GLobalAverageTran]
    DECLARE @test bit;
BEGIN TRY
    -- skapa tabell
    IF OBJECT_ID('MachineGlobalAverage', 'U') IS NOT NULL
        BEGIN
            SET @test = 0; -- tabellen finns
            INSERT INTO dbo.MachineGlobalAverage (
                MachineId,
                CreatedDateTime,
                SearchedPeriod,
                AverageDrillHoursPerDay,
                AverageDrillMetersPerDay,
                AverageDrillMetersPerEngineHour,
                AverageDrillMetersPerDrillHour,
                AverageDrillHoursPerEngineHour,
                AverageDrillHolesPerDay,
                AverageFuelLitersPerDay,
                AverageFuelLitersPerHour,
                AverageFuelCO2EmissionPerDay,
                AverageFuelLitersPerTonnes,
                AverageFuelLitersPerMeter,
                AverageLoadingTonnesPerDay,
                AverageLoadingTonnesPerHour,
                AverageLoadingNumberOfBucketsPerDay,
                AverageLoadingTonnesPerBucket,
                AverageLoadingNumberOfBoxesPerDay,
                AverageLoadingTonnesPerBox,
                AverageUtilizationAvailableHoursPerDay,
                AverageUtilizationWorkedHoursPerDay,
                AverageUtilizationDrillHoursPerDay,
                AverageUtilizationPumpHoursPerDay,
                AverageUtilizationWorkPositionHoursPerDay,
                AverageUtilizationTrammingHoursPerDay,
                AverageUtilizationIdleHoursPerDay,
                AverageUtilizationEngineHoursPerDay)
                VALUES (6000, '2017-12-18', 1, 9.3, 400, 390, 80, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 4, 0.715651, 0.456879, 1.5659561514, 0, 0, 0.156898492, 0.11456565
            );
        END
    ELSE
        BEGIN
            SET @test = 1; -- tabellen finns inte
            CREATE TABLE dbo.MachineGlobalAverage (
                MachineGlobalAverageId INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
                MachineId INT NOT NULL,
                CreatedDateTime DATE NOT NULL,
                SearchedPeriod nvarchar(25) NOT NULL,
                AverageDrillHoursPerDay FLOAT NULL,
                AverageDrillMetersPerDay FLOAT NULL,
                AverageDrillMetersPerEngineHour FLOAT NULL,
                AverageDrillMetersPerDrillHour FLOAT NULL,
                AverageDrillHoursPerEngineHour FLOAT NULL,
                AverageDrillHolesPerDay FLOAT NULL,
                AverageFuelLitersPerDay FLOAT NULL,
                AverageFuelLitersPerHour FLOAT NULL,
                AverageFuelCO2EmissionPerDay FLOAT NULL,
                AverageFuelLitersPerTonnes FLOAT NULL,
                AverageFuelLitersPerMeter FLOAT NULL,
                AverageLoadingTonnesPerDay FLOAT NULL,
                AverageLoadingTonnesPerHour FLOAT NULL,
                AverageLoadingNumberOfBucketsPerDay FLOAT NULL,
                AverageLoadingTonnesPerBucket FLOAT NULL,
                AverageLoadingNumberOfBoxesPerDay FLOAT NULL,
                AverageLoadingTonnesPerBox FLOAT NULL,
                AverageUtilizationAvailableHoursPerDay FLOAT NULL,
                AverageUtilizationWorkedHoursPerDay FLOAT NULL,
                AverageUtilizationDrillHoursPerDay FLOAT NULL,
                AverageUtilizationPumpHoursPerDay FLOAT NULL,
                AverageUtilizationWorkPositionHoursPerDay FLOAT NULL,
                AverageUtilizationTrammingHoursPerDay FLOAT NULL,
                AverageUtilizationIdleHoursPerDay FLOAT NULL,
                AverageUtilizationEngineHoursPerDay FLOAT NULL
            );
        END
    PRINT @test;
    COMMIT TRANSACTION [GLobalAverageTran]
END TRY
    BEGIN CATCH
        ROLLBACK TRANSACTION [GLobalAverageTran]
    END CATCH
GO