update [dbo].[t_g_counting_denom]   set flschet1=isnull(flschet1,0)+1 where id_card in (select id_card from inserted)	and source in (select source from inserted)

ALTER TRIGGER [dbo].[counting_denom_update] 
   ON  [dbo].[t_g_counting_denom] 
   AFTER UPDATE

alter TRIGGER [dbo].[counting_denom_update1] 
   ON  [dbo].[t_g_counting_denom] 
INSTEAD OF UPDATE 
AS 
BEGIN
	SET NOCOUNT ON;
update [dbo].[t_g_counting_denom]   set flschet1=isnull(flschet1,0)+1 where id_card in (select id_card from inserted)	and source in (select source from inserted)
END

UpdateCommand затронула 0 из ожидаемых 1 записей.

CREATE TABLE [dbo].[t_g_counting_denom](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[id_counting] [bigint] NOT NULL,
	[id_card] [bigint] NOT NULL,
	[id_denomination] [bigint] NOT NULL,
	[id_condition] [bigint] NULL,
	[creation] [datetime] NOT NULL,
	[lastupdate] [datetime] NOT NULL,
	[last_user_update] [bigint] NOT NULL,
	[workstation] [nvarchar](50) NULL,
	[count] [int] NULL,
	[reject_count] [int] NULL,
	[fact_value] [decimal](19, 4) NULL,
	[source] [int] NOT NULL,
	[serial_number] [nchar](30) NULL,
	[serial_number2] [nchar](30) NULL,
	[description] [nchar](30) NULL,
	[description1] [nvarchar](50) NULL,
	[flschet1] [int] NULL,
 CONSTRAINT [PK_t_g_counting_denom] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[t_g_counting_denom] ADD  CONSTRAINT [DF_t_g_counting_denom_flschet1]  DEFAULT ((0)) FOR [flschet1]
GO

ALTER TABLE [dbo].[t_g_counting_denom]  WITH CHECK ADD  CONSTRAINT [FK_t_g_counting_denom_t_g_cards] FOREIGN KEY([id_card])
REFERENCES [dbo].[t_g_cards] ([id])
GO

ALTER TABLE [dbo].[t_g_counting_denom] CHECK CONSTRAINT [FK_t_g_counting_denom_t_g_cards]
GO

ALTER TABLE [dbo].[t_g_counting_denom]  WITH CHECK ADD  CONSTRAINT [FK_t_g_counting_denom_t_g_denomination] FOREIGN KEY([id_denomination])
REFERENCES [dbo].[t_g_denomination] ([id])
GO

ALTER TABLE [dbo].[t_g_counting_denom] CHECK CONSTRAINT [FK_t_g_counting_denom_t_g_denomination]
GO

ALTER TABLE [dbo].[t_g_counting_denom]  WITH CHECK ADD  CONSTRAINT [FK_t_g_counting_t_g_counting_denom] FOREIGN KEY([id_counting])
REFERENCES [dbo].[t_g_counting] ([id])
GO

ALTER TABLE [dbo].[t_g_counting_denom] CHECK CONSTRAINT [FK_t_g_counting_t_g_counting_denom]
GO

ALTER TRIGGER [dbo].[counting_denom_update1] 
   ON  [dbo].[t_g_counting_denom] 
INSTEAD OF UPDATE 
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	

	
	update [dbo].[t_g_counting_denom]   set flschet1=isnull(flschet1,0)+1 where id_card in (select id_card from inserted)	and source in (select source from inserted)
	

	

END