Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.
USE [Database] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[Ascent_UpdateSupplierStatus] ON [dbo].[ApSupplier] AFTER INSERT,UPDATE AS INSERT INTO [TriggerTablesAscent].[dbo].[SupplierStatus](SupplierCode, ActiveStatus, DateUpdated, UpdatedBy) SELECT i.Supplier, CASE i.OnHold WHEN 'Y' THEN 1 ELSE 0 END, CURRENT_TIMESTAMP, SYSTEM_USER FROM inserted as i LEFT OUTER JOIN [TriggerTablesAscent].[dbo].[SupplierStatus] tta ON i.Supplier = tta.SupplierCode WHERE CASE i.OnHold WHEN 'Y' THEN 1 ELSE 0 END <> tta.ActiveStatus
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.