database query

See more:

SQL-Server-2005

SQL-Server

im a newbie,
i am using sql server 2005

i have a attendance_tbl 3 fields(columns),

table defn :
in_time datetime not null,-- unique key
out_time datetime null,
emp_id int null -- foreign key

table is used for storing employee in_time and out_time

i am inserting in_time and emp_id for corresponding employee when employee enters,

and update the out_time columns for employee logout,

PROBLEM is when i update the table for out_time all the records corresponding the that employee get updated, i mean all records out_time get updated