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

The MSSQLSERVER (NT Service) has full permissions to the file(s). I never moved the files between uninstalling SQL Server and reinstalling it. Still no joy.

Thanks for the help, Sue. I *think* I have it finally.
Either the SSRS documentation is awful or I seriously don't know how to read. I'm almost tempted to write...