Создание строк входа и выхода из одной строки

У меня вход и выход такой.

DECLARE @t TABLE
           (
               id INT IDENTITY(1, 1), 
               empid VARCHAR(10), 
               logindate DATE, 
               logintime TIME, 
               logoutdate DATE, 
               logouttime TIME
           )

INSERT @t (empid, logindate, logintime, logoutdate, logouttime) VALUES('251803', CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T08:00:00.000' AS TIME), CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T11:00:00.000' AS TIME))
INSERT @t (empid, logindate, logintime, logoutdate, logouttime) VALUES ('251803', CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T12:00:00.000' AS TIME), CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T16:59:00.003' AS TIME))
INSERT @t (empid, logindate, logintime, logoutdate, logouttime) VALUES ('251809', CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T08:00:00.000' AS TIME), CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T10:14:00.003' AS TIME))
INSERT @t (empid, logindate, logintime, logoutdate, logouttime) VALUES ('251809', CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T11:13:00.000' AS TIME), CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T17:20:00.003' AS TIME))
INSERT @t (empid, logindate, logintime, logoutdate, logouttime) VALUES ('251800', CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T08:00:00.000' AS TIME), CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T13:08:00.003' AS TIME))
INSERT @t (empid, logindate, logintime, logoutdate, logouttime) VALUES('251800', CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T14:08:00.003' AS TIME), CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T17:00:00.003' AS TIME))
INSERT @t (empid, logindate, logintime, logoutdate, logouttime) VALUES ('251800', CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T18:00:00.003' AS TIME), CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T18:00:00.003' AS TIME))
INSERT @t (empid, logindate, logintime, logoutdate, logouttime) VALUES('251800', CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T20:08:00.003' AS TIME), CAST(N'2024-06-28T00:00:00.000' AS DATETIME), CAST(N'1899-12-30T21:00:00.003' AS TIME))

Мне нужно вывести это так:

Я написал этот SQL-скрипт

DECLARE @clock TABLE 
               (
                   i INT IDENTITY,  
                   empid VARCHAR(10), 
                   datetimelog DATETIME, 
                   log_status VARCHAR(10), 
                   punch VARCHAR(10)
               )

DECLARE @i INT = 1, @pnum INT, @curempid VARCHAR(10)

DECLARE @empid VARCHAR(10), 
        @logindate DATE, @logintime TIME, 
        @logoutdate DATE, @logouttime TIME

WHILE (@i <= (SELECT MAX(id)FROM @t))
BEGIN
    SELECT 
        @empid = empid, 
        @logindate = logindate, @logintime = logintime, 
        @logoutdate = logoutdate, @logouttime = logouttime
    FROM 
        @t 
    WHERE 
        id = @i 
    ORDER BY 
        empid, logindate

        
    IF (@curempid IS NULL)
    BEGIN
        SET @curempid = @empid
        SET @pnum = 1
    END
    ELSE
    BEGIN
        IF (@curempid = @empid)
        BEGIN
            SET @pnum = @pnum + 1
        END
        ELSE
        BEGIN
            SET @curempid = @empid
            SET @pnum = 1
        END
    END

    INSERT INTO @clock (empid, datetimelog, log_status, punch)
    VALUES (@empid, CAST(@logindate AS DATETIME) + CAST(CAST(@logintime AS TIME) AS DATETIME), 'IN', @pnum)
        
    SET @pnum = @pnum + 1
        
    INSERT INTO @clock (empid, datetimelog, log_status, punch)
    VALUES (@empid, CAST(@logoutdate AS DATETIME) + CAST(CAST(@logouttime AS TIME) AS DATETIME), 'OUT', @pnum)

    SET @i = @i + 1;
END;

Есть ли лучший способ сделать это? Я думаю о повороте, но я не знаю способа поворота. заранее спасибо