How to get In/Out log in SQL Server?

You can achieve this through UNPIVOT operator which transform the column based data into rows. I have written the query based on your provided data. you can modify it accordingly. (If needed)

SELECT empcode [UserId],
       logdate [LogDate],
       CONVERT(VARCHAR(5), LogTime, 108) [LogTime],
       CONCAT(logdate, ' ', LogTime) [LogDateTime],
       CASE WHEN (ROW_NUMBER() OVER (ORDER BY (SELECT 0))) % 2 = 0 THEN 1 ELSE 0 END [Status]

FROM tblEmployeeLog -- tblEmployeeLog is your main table
UNPIVOT
(
    LogTime
    FOR logtimeval in (timein1, timeout1, timein2, timeout2, timein3, timeout3, timein4, timeout4, 
    timein5, timeout5
)
) unpiv;