TRIGGER HELP!

Question

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 739542 More actions · Answer 1

use if

create trigger

as

if (select status from inserted) = 'Complete'

update table

set completedate = getdate()

from inserted

where table.pk = inserted.pk

else if (select status from inserted) = 'being processed'

....

Steve Jones