I have tried to avoid NOT IN clauses, I couldn't remember why but here it is.

I usually use outer joins eg

select * from #Employees e

left outer join #NullOperation n

on e.EmployeeID = n.NullableColumn

where n.NullableColumn IS NULL

so that I get what I expect, which is what we all want!