• This?

    DECLARE @TableA TABLE

    (

    EmployeeIDINT

    ,EmployeeLoginDateTimeDATETIME

    ,JobFunction VARCHAR(25)

    )

    INSERT @TableA

    SELECT 123,'2012-02-01 01:00:24','Coding'

    UNION ALL SELECT 123,'2012-02-01 3:00:00','Programming'

    UNION ALL SELECT 123,'2012-02-01 5:00:00' ,'LogOut'

    UNION ALL SELECT 234,'2012-02-01 01:00:24','Coding'

    UNION ALL SELECT 234,'2012-02-01 3:00:00','Programming'

    UNION ALL SELECT 234,'2012-02-01 5:00:00' ,'Coding'

    SELECT EmployeeID

    ,EmployeeLoginDateTime

    ,JobFunction

    FROM @TableA OutTab

    WHERE NOT EXISTS ( SELECT 1 FROM @TableA InrTab

    WHERE InrTab.JobFunction = 'LogOut'

    AND InrTab.EmployeeID = OutTab.EmployeeID)