Thank you for your help, but I figured out what teh issue was. The reason I believe the inseretd logical table wasn't storing the values was because the application was first performing an insert into t_ccs_queue table to set the identity column and then updating this record with the app_id...
Sorry, I insert the values into another table. Here is the full trigger:
CREATE trigger ats_file_retrieve on dbo.t_ccs_queue for insert as
begin
declare @queue_name varchar(50)
declare @app_id int
select @queue_name = act.activity_desc, @app_id = inserted.app_id
from...
The variables @queue_name and @app_id are null in the following trigger. However, the app_id and queue_activity_id fields within the t_ccs_queue table are not null - seems like the inseretd table is not storing the values. Any suggestions?
CREATE trigger ats_file_retrieve on dbo.t_ccs_queue...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.