The below doesn't work, since the @Date variable is inside the nested query. How can I get this to work? select employee_id, name from dbo.DisplayName as dn where not exists (select userid from ...

I'm starting another project and I'm currently designing our schema. I've got a couple many-to-many joins. I was wondering if a nested table is a better solution than simply creating an intersection ...