Skip to content Skip to sidebar Skip to footer

Merge - Conditional "when Matched Then Update"

The highlights in the image below shows the logic I want to implement. I realize the syntax is incorrect. Is there a way to conditionally update a record in a MERGE statement only

Solution 1:

You might be able to use When Matched And (s.[Created Date] Is Not Null And t.[Created Date] Is Null) Then Update ....


Post a Comment for "Merge - Conditional "when Matched Then Update""