i am not much clear but i think you need similar. this is just an example.
create table Attendance
(
Emp varchar(10),
LoginDateTime datetime,
AttendanceType tinyint
)
insert into Attendance values ('John', GETDATE()-1,0)
insert into Attendance values ('John', GETDATE(), 1)
SELECT Emp as 'Employee', [0] as 'Intime', [1] as 'Outtime'
FROM (
SELECT
AttendanceType,
LoginDateTime, Emp
FROM Attendance
) as temp
PIVOT
(
max(LoginDateTime)
FOR AttendanceType in ([0], [1])
)AS pvoit