Alternatives

ALTERNATIVES OF NOT IN

Most importantly, NOT EXISTS and LEFT JOIN / IS NULL are almost equal, while NOT IN is not. These differ in handling of NULL values in the RIGHT side TABLE. Some Alternatives of NOT IN LOgic - Example Code - IF OBJECT_ID('Tempdb..#SampleTable1') IS NOT NULL DROP TABLE #SampleTable1; IF OBJECT_ID('Tempdb..#SampleTable2') IS NOT NULL DROP TABLE… Continue reading ALTERNATIVES OF NOT IN

Advertisement