Trigger can't insert dup key

[Greg25]

Here’s A trigger I created

Create Trigger TRG_status_change ON Order_entry
For Update
As
If update (Last_cost_center_code)
Begin
Insert Job_workflow (Cost_center_code, row_id)
Select Last_Cost_center_code, row_id
From inserted
End

I think it will work if I only knew how I could make the primary key unique or to select a number that has not been used yet

Thanks Greg

 

[Greg25]

I think i figured this out but still need to enter the time and date the cost center is changed to and from cost center

 

[foxdev]

Greg, I'm kind of reading between the lines, but it sounds like your problem is trying to identify a Pk in job_workflow.

I don't normally declare PKs for my audit trail tables, but that's just a personal failing of mine. If you want to, add a column for DateChanged and insert into it the value GetDate(), then make your PK include DateChanged. That way, multiple changes to a single row will still allow you a unique key. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com