StackOverflow question #44830265, Sql Server

Language: Layout:

CREATE TABLE [KrisisShifts_ShiftTrade] (ValidFrom DATETIME, ValidTo DATETIME, ShiftId INT, TradeDate DATETIME, StatusID INT, LastActionDate DATETIME, OwnerUserID INT, WorkerUserID INT, WorkerEmail VARCHAR(MAX), Archived INT);
    INSERT INTO [KrisisShifts_ShiftTrade] (ValidFrom, ValidTo, ShiftId, TradeDate, StatusID, LastActionDate, OwnerUserID, WorkerUserID, WorkerEmail, Archived )
    VALUES ('2017-06-21 00:26:44.51', '9999-12-31 23:59:59.99', 27, '2017-01-27', 3, '2017-01-09 16:23:39.760', 45, 34, 'test@hotmail.com', 1);
    INSERT INTO [KrisisShifts_ShiftTrade] (ValidFrom, ValidTo, ShiftId, TradeDate, StatusID, LastActionDate, OwnerUserID, WorkerUserID, WorkerEmail, Archived )
    VALUES ('2017-06-21 00:19:35.57', '2017-06-21 00:26:44.51', 27, '2017-01-27', 2, '2017-01-09 16:23:39.760', 45, 34, 'test@hotmail.com', 1);
    INSERT INTO [KrisisShifts_ShiftTrade] (ValidFrom, ValidTo, ShiftId, TradeDate, StatusID, LastActionDate, OwnerUserID, WorkerUserID, WorkerEmail, Archived )
    VALUES ('2017-06-21 00:19:16.25', '2017-06-21 00:19:35.57', 27, '2017-01-28', 3, '2017-01-09 16:23:39.760', 45, 34, 'test@hotmail.com', 1);
    
    GO
    
    CREATE PROCEDURE GetChanges(@RequestedShiftID INT)
    AS
    BEGIN
        DECLARE @ValidFrom DATETIME, @ValidTo DATETIME, @TradeDate DATETIME; 
        DECLARE @PrevTradeDate DATETIME, @LastActionDate DATETIME;
        DECLARE @PrevLastActionDate DATETIME;
        DECLARE @ShiftId INT, @StatusID INT, @PrevStatusID INT, @OwnerUserID INT;
        DECLARE @PrevOwnerUserID INT, @WorkerUserID INT, @PrevWorkerUserID INT;
        DECLARE @Archived INT, @PrevArchived INT;
        DECLARE @WorkerEmail VARCHAR(MAX), @PrevWorkerEmail VARCHAR(MAX);
        
        CREATE TABLE #Results (Id INT NOT NULL IDENTITY (1,1) PRIMARY KEY, ShiftId INT,
                               [Column] VARCHAR(255), Value VARCHAR(MAX), 
                               ValidFrom DATETIME, ValidTo DATETIME);
    
        DECLARE cur CURSOR FOR
        SELECT 
            ValidFrom
            , ValidTo
            , ShiftId
            , TradeDate
            , StatusID
            , [LastActionDate]
            , [OwnerUserID]
            , [WorkerUserID]
            , [WorkerEmail]
            , [Archived]
        FROM [KrisisShifts_ShiftTrade]
        /*FOR SYSTEM_TIME ALL*/
        WHERE [ShiftID] = @RequestedShiftID
        ORDER BY ValidTo Desc;
        
        OPEN cur;
        FETCH NEXT FROM cur INTO
            @ValidFrom
            , @ValidTo
            , @ShiftId
            , @TradeDate
            , @StatusID
            , @LastActionDate
            , @OwnerUserID
            , @WorkerUserID
            , @WorkerEmail
            , @Archived;
        
        WHILE @@FETCH_STATUS = 0
        BEGIN
           SET @PrevTradeDate = @TradeDate;
           SET @PrevStatusID = @StatusID;
           SET @PrevLastActionDate = @LastActionDate;
           SET @PrevOwnerUserID = @OwnerUserID;
           SET @PrevWorkerUserID = @WorkerUserID;
           SET @PrevWorkerEmail = @WorkerEmail;
           SET @PrevArchived = @Archived;
           
           FETCH NEXT FROM cur INTO
                @ValidFrom
                , @ValidTo
                , @ShiftId
                , @TradeDate
                , @StatusID
                , @LastActionDate
                , @OwnerUserID
                , @WorkerUserID
                , @WorkerEmail
                , @Archived;
                
           IF @TradeDate <> @PrevTradeDate
               INSERT INTO #Results (ShiftId, [Column], Value, ValidFrom, ValidTo)
               VALUES (@ShiftId, 'TradeDate', @TradeDate, @ValidFrom, @ValidTo);
           IF @StatusID <> @PrevStatusID
               INSERT INTO #Results (ShiftId, [Column], Value, ValidFrom, ValidTo)
               VALUES (@ShiftId, 'StatusID', @StatusID, @ValidFrom, @ValidTo);
           IF @LastActionDate <> @PrevLastActionDate
               INSERT INTO #Results (ShiftId, [Column], Value, ValidFrom, ValidTo)
               VALUES (@ShiftId, 'LastActionDate', @LastActionDate, @ValidFrom, @ValidTo);
           IF @OwnerUserID <> @PrevOwnerUserID
               INSERT INTO #Results (ShiftId, [Column], Value, ValidFrom, ValidTo)
               VALUES (@ShiftId, 'OwnerUserID', @OwnerUserID, @ValidFrom, @ValidTo);
           IF @WorkerUserID <> @PrevWorkerUserID
               INSERT INTO #Results (ShiftId, [Column], Value, ValidFrom, ValidTo)
               VALUES (@ShiftId, 'WorkerUserID', @WorkerUserID, @ValidFrom, @ValidTo);
           IF @WorkerEmail <> @PrevWorkerEmail
               INSERT INTO #Results (ShiftId, [Column], Value, ValidFrom, ValidTo)
               VALUES (@ShiftId, 'WorkerEmail', @WorkerEmail, @ValidFrom, @ValidTo);
           IF @Archived <> @PrevArchived
               INSERT INTO #Results (ShiftId, [Column], Value, ValidFrom, ValidTo)
               VALUES (@ShiftId, 'WorkerEmail', @WorkerEmail, @ValidFrom, @ValidTo);
        END   
        
        CLOSE cur;
        DEALLOCATE cur;
        
        SELECT ShiftId, [Column], Value, ValidFrom, ValidTo
        FROM #Results
        ORDER BY Id
    END;
    
    GO
    
    EXEC GetChanges 27;

View schema
Execution time: 0,04 sec, rows selected: 24, rows affected: 6, absolute service time: 0,28 sec