Hi,
I have a database which stores data and keeps a record of the last
update date on that record. Say I have a table Employee. It has
columns Emp_ID, Emp Name, Dept, StartDate, EndDate and Updated By
Hence, when I insert data into this table I would insert as ("ABC","IT
Dept","UpdatedByUser")
The start date will be today's date and end date will be null. When
the second record is inserted, then it first updates the previous
records end date and inserts the record.
Like on 1st Jan: Employee table : ABC IT Dept-- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
