מנסה
Select * From (select ID, UserID, KindLog , TimeLog, Row_Number() Over(Partition By UserID Order By TimeLog) as RowNumber from Logins) a inner join (select ID, UserID, KindLog , TimeLog, Row_Number() Over(Partition By UserID Order By TimeLog) as RowNumber from Logins) b on a.UserID=b.UserID And a.RowNumber+1=b.RowNumber And a.KindLog='LogIn' and b.KindLog='LogOut'
Select * From (select ID, UserID, KindLog , TimeLog, Row_Number() Over(Partition By UserID Order By TimeLog) as RowNumber from Logins) a inner join (select ID, UserID, KindLog , TimeLog, Row_Number() Over(Partition By UserID Order By TimeLog) as RowNumber from Logins) b on a.UserID=b.UserID And a.RowNumber+1=b.RowNumber And a.KindLog='LogIn' and b.KindLog='LogOut'