Need SQL query [repost]

See more:

SQL-Server-2005

SQL-Server

I m using a SQL Server database with a table names Attendence. The columns in the table are:

1) EmpCode int
2) AttendenceDate datetime
3) AttendenceTime Datetime
4) Status tinyint

Data in the table would be like this:

Code AttendenceDate AttendenceTime status
1001 3/27/2009      3/27/2009 9:05 1
1001 3/27/2009      3/27/2009 7:05 0


1003 3/29/2009      3/27/2009 7:05 1
1003 3/29/2009      3/27/2009 7:05 0
1001 3/30/2009      3/27/2009 7:05 1
1001 3/30/2009      3/27/2009 7:05 0

A value of "1" for Status means check-in and "0" means check-out. I need a query to show the results like this:

Code date      Timein Timeout
1001 3/27/2009 9:05   7:05

How can I make the perfect query for this?

Thanks in advance.