Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yiru112
Starting Member
1 Post |
 Posted - 2006-05-20 : 14:03:34
|
helo..i'm new to SQL... could someone help me with this problem???i have a 'PROJECT' table with the fields (project_id, estimated cost, estimated time, actual end date, actual cost, project manager id) and 'EMPLOYEE' table with the fields (employee id, employee name, employee salary, employee area id). project manager id is the FK to employee id PK. i need to create a trigger to keep a history of any changes made to the estimated cost or estimated of a project. a new table would need to be created to store the project id, old and new values for the estimated cost and/or estimated time, actual end date, actual cost, date of the change and the user id of the person making the change. thank you...  |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
|
|
|
|
|
Trigger Help