Home Forums SQL Server 2008 T-SQL (SS2K8) Slow Script RE: Slow Script
homebrew01
SSC Guru
Points: 55544
More actions
October 5, 2013 at 7:46 pm
#1656133
Chris, is this the equivalent of a LEFT JOIN based on 4 columns ?
AND NOT EXISTS (SELECT 1 FROM T3
WHERE T3.COL1 = T2.COL1
AND T3.COL2 = T2.COL2
AND T3.COL3 = T1.COL1
AND T3.COL4 = T1.COL2)