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 |
|
Sher
Starting Member
3 Posts |
 Posted - 2008-11-23 : 19:12:58
|
| I have a text file that has over 4000 values in it. Is there a way for me to do a Select statement using where in and point to the text file for the IN values? |
|
|
cvraghu
Posting Yak Master
187 Posts |
Posted - 2008-11-24 : 04:33:36
|
| Why don't you import the text file in to a table and use it? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-24 : 04:36:37
|
You can use OPENROWSET to use the external file as a table.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-24 : 04:45:22
|
| http://doc.ddart.net/mssql/sql70/oa-oz_5.htm |
|
|
|
Sher
Starting Member
3 Posts |
Posted - 2008-11-24 : 08:31:51
|
| Can someone give me an example of how to use the openrowset with a text file that doesn't have an odbc connection user and password? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-24 : 08:42:17
|
http://www.connectionstrings.com/?carrier=textfile
E 12°55'05.63"N 56°04'39.26" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-24 : 08:46:52
|
http://www.databasejournal.com/features/mssql/article.php/10894_3331881_3/OpenRowSource-and-OpenRowSet-in-SQL-Server-2000.htm
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Sher
Starting Member
3 Posts |
Posted - 2008-11-24 : 11:02:39
|
| Thank you very much!!! |
|
|
|
|
|
|
SELECT Where In