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 ...

How? I've tried every variation that I can think of and it will never let me complete a nested query...<BR><BR>Example:<BR><BR>q = "(SELECT TOP 5 * FROM data WHERE ID ...