SQL Server (Update A Query from External File)
Posted on 2013-06-21
Below I have a SQL Server Query where I am looking to return the Customer Name and Address for the specified CustomerID's.
I have to run this query on a regular basis. However, each time I run this I have to insert a long list of customer ID's into the query from an Excel spreadsheet. It's get to be time consuming as the list of CustomID's changes each time I need to run this query. I am looking for method where I can speed things up or automate the process of pointing the query at this list of customerID's that are stored in the Excel Spreadsheet. Thanks for any feedback.
Select CustomerName, Address
WHERE CustomerID in ('12345', 12346', '12347')