Home Forums SQL Server 2008 T-SQL (SS2K8) MERGE Statement DELETE from TARGET when not in SOURCE 'hanging' RE: MERGE Statement DELETE from TARGET when not in SOURCE 'hanging'
Cowboy DBA
SSCrazy
Points: 2135
More actions
June 21, 2013 at 7:53 am
#1626328
This help?
WHEN NOT MATCHED BY SOURCE AND
c_target.sessionid = @sessionid
AND c_target.offer_type = 'GWP'
THEN DELETE