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 |
|
OMB
Yak Posting Veteran
88 Posts |
 Posted - 2001-05-31 : 04:47:48
|
| Please can someone help me with the followingI have a table that has several fields, one of these fields is a status field that changes maybe twice a day. I need to capture the value from (field A) when the status field changes to a certain status, and then insert this field into another table. I also need to make sure that any records inserted into the new table are not inserted again.I thought I could do this with a trigger but I understand you cant use triggers with insert into.... Hope this makes sense and someone can help!!!Thanks in advance |
|
|
|
|
|
SOME DIRECTION PLEASE!!!!!