I'm getting a Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression eeror when running an update statement.
it's pretty basic and does not contain a subquery:
UPDATE IDO SET IDO.PARTNO = 'MIS56265' WHERE IDO.PARTNO = '047-000009-0001'
UPDATE IDO SET IDO.PARTNO = 'MIS56266' WHERE IDO.PARTNO = '047-000013-0000'
You'll need to make a minor alteration to the trigger code, but it won't affect how it works for every other UPDATE.
Add a "bypass" option based on the CONTEXT_INFO() value. Then, before your UPDATE, set the bypass on. Afterward, set it back off.
ALTER TRIGGER dbo.trigger_name
ON dbo.IDO
AFTER UPDATE
AS
SET NOCOUNT ON;
IF LEFT(CONTEXT_INFO(), 2) = 0xffff
RETURN;
...rest of trigger as before...
SET CONTEXT_INFO 0xffff
UPDATE IDO SET IDO.PARTNO = 'MIS56265' WHERE IDO.PARTNO = '047-000009-0001'
SET CONTEXT_INFO 0x00