Time n attendance records

See more:

SQL-Server-2005

C#

SQL-Server

Hi ,

I'm currently doing a time & attendance project. its like when i click the download button, the code and dlls communicates with the attendance reader and fetches the datas in the following format(sql) ,

empCode in/outMode  date          time
5001        0       12/09/2011    09:05:34
5002        0       12/09/2011    09:33:13
5001        1       12/09/2011    18:05:09
5002        1       12/09/2011    17:44:34

where , in the in/out mode , o is the intime and 1 is the outtime.

i want to show these datas in a single record for each employees. that is , i want to show somethng like the following , (assume that i created a new table as below) ,

empCode  date        intime      outtime
5001     12/09/2011  09:05:34    18:05:09
5002     12/09/2011  09:33:13    17:44:34

How do i do that?.. can anyone pls guide me?...