Home Forums SQL Server 2008 T-SQL (SS2K8) Trigger with merge statement RE: Trigger with merge statement
mpowrie
SSC Rookie
Points: 39
More actions
July 7, 2015 at 8:54 pm
#1810837
A few years late with the reply, but as this came up in a Google search, try this:
WHEN NOT MATCHED BY SOURCE AND tgt.PK_INDEX = (SELECT PK_INDEX from Deleted)