Jack,
Luis' answer fixed it. This is the query I ended up using that worked for me:
SELECT   candidate_id, first_name, last_name
FROM    Candidate AS c
WHERE   (NOT...

Super cool, Luis! Many graces!
This worked:
SELECT   candidate_id, first_name, last_name
FROM    Candidate AS c
WHERE   (NOT EXISTS
          (SELECT   1 AS Expr1
           FROM    Candidate...

Oh, super handy! Thanks for asking... I was playing with the SSRS end of this... Getting the count of selected values is easy in SSRS. It's the passing that back...

Jack,
I asked a question about how to do this in another forum. Check this out:
https://www.sqlservercentral.com/Forums/1922517/EXISTS-ALL#bm1922645

Jason,
Wow. I'll take a while to get my head around all this. Say I'm using SSRS as a front end to this - Essentially "Show me all candidates that...

Exercised my Google-fu... Relational division, anybody?
https://stackoverflow.com/questions/15977126/select-rows-that-match-all-items-in-a-list

I'm working on it... In T-SQL, it would be like this:
(Yes, I'm aware that this table design of Candidate is silly!!!)
.
CREATE TABLE Candidate(
    CandidateID INT...

One thing to do is go find the local SQL Server User Group and go to the meetings. Open positions are often announced at the beginning of each meeting. If...

Sue,
Okay, I'll try it and post back when/if I get it working with what I tried. Seems odd that MS can't keep this stuff straight.
Almost glad I'm not...

Lynn Pettis wrote a quick article on a bunch of useful date functions. It's here:
http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

I think I will. I could do the install once more (Imagine whiny kid voice "Again????!!!"), but once it's scripted, e-mail script to myself (or similar). Then I can just...

Sue,
Last question, since IT'S WORKING!!!
I know it's possible to script an install of SQL Server with a config file, but can I basically do it backwards (clone an...

Are you talking about ROW_NUMBER()?

The script wasn't for you, it was for the people trying to help you. Since you're new, I think you should read Jeff Moden's article on how to...

So what's the answer supposed to be? What should the query return?

Here's how to post sample data...
CREATE TABLE RouterData (
    RouterName char(2),
    A char(4),
    B...