Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reading2009
Starting Member
22 Posts |
 Posted - 2011-10-24 : 14:22:39
|
| I have a table with a column called Country. Country has only unique data in it and it has more than 1000 names within the country.i want to extract all the data for only 400 country names.Instead of typing them one by one in where clause, is there a way for me to point the where caluse to a file which contains these 400 names and it pull me all data for these 400 only? |
|
|
craigwg
Posting Yak Master
154 Posts |
Posted - 2011-10-24 : 15:26:17
|
| Not that I know of. I would think it would be better to populate a view from the file using a job that runs periodically (twice a day perhaps). Then perhaps write some dynamic SQL that builds the where statement for you. It could even be done with a temp table. That would be my approach.Craig Greenwood |
 |
|
|
reading2009
Starting Member
22 Posts |
Posted - 2011-10-24 : 15:57:30
|
| thank you Craig. |
|
|
|
|
|
|
where clause to point to a file