Executing a stored procedure from an insert trigger?

[dougcoulter]

I am having difficulty executing a stored procedure from an insert trigger (and it appears to be syntax related). Uon an insert into this table, I would like to call a stored procedure requiring 2 parameters that correspond to 2 fields in the trigger table. For example (this is the statement in question):

EXECUTE spFaultDurations Inserted.Field1, Inserted.Field2

The stored procedure works fine when I manually call it. I have not worked with triggers before, so I am not sure if I am referring to the inserted fields correctly. Can anyone help?

Thanks!

 

[tlbroadbent]

Declare variables, assign values from the inserted table and pass the variables in the procedure call.

Declare @var1 <data type>, @var2 <data type>

Select @var1=field1, @var2=Field2 From inserted

EXECUTE spFaultDurations @var1, @var2 Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[dougcoulter]

Thanks Terry. I will definitely give it a shot this afternoon.

 

[dougcoulter]

Terry...

Thanks again. With you advice, I was able to get things working!

...Doug