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