Avatar of RUA Volunteer2?
RUA Volunteer2?
Flag for United States of America asked on

Given a task to cross check a list in Excel against a SQL database for personnel to create a Query

I was given a long list of 10k employees that called in to a help desk but did not connect to a person to solve a problem. The situation is that they were ordered to fill out a form to apply for but they did not fill out this form in time. There is now an effort to see who tried to call in to get help with this form but did not connect. If I have an excel  list of the personnel phone numbers who did not complete this task and a SQL database which tells us who (the personnel we need to match on) to send communications from call backs to emails. How do I match that up. So....

Excel list of personnel phones                      Over here a SQL query with Personnel information.

How do I tie the two together to build a query that contains Personnel Phone Email etc...Any examples helpful.

I wonder if I have to create a new table that points to the excel file and generates the records to join to the SQL ...(maybe an SP) I have ideas but no clarity on direction. 
SQL* Excel TableMicrosoft SQL Server

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
RUA Volunteer2?

ASKER
Not sure what this is 'save the Excel file to a csv and use bcp to load the data.'   what is BCP

What would be an example of the brute force. Is that like repeating a statement 10k times? making copies of it and executing that in a Select statement?

I understand joins I use Notepad + +
SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.
fblack61