Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dwain Camps A Hazard of Using the SQL Merge Statement RE: A Hazard of Using the SQL Merge Statement
P Jones
SSChampion
Points: 12353
More actions
April 3, 2013 at 3:38 am
#1603071
As another MERGE fan I'd use
WHEN NOT MATCHED BY SOURCE AND (t.ID = s.ID) THEN DELETE;
in the original merge statement.
But I've no complaints about the article - one size doesn't fit all so some will like and some won't.