CREATE TABLE [dbo].[TempTable](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[TimeStamp] [datetime] NULL,
	[Direction] [nvarchar](5) NULL,
	[TimeOut] [datetime] NULL,
	[Name] [nvarchar](50) NULL)

SELECT *
FROM   [dbo].[TempTable] a
WHERE  NOT EXISTS 
(
       SELECT *
       FROM   [dbo].[TempTable] b
       WHERE  a.name = b.name
              AND b.Direction = 'OUT'
)
AND a.Direction = 'IN';

SELECT *
FROM TempTable
WHERE TimeOut IS NULL