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""