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 |
|
Sambasivam
Starting Member
36 Posts |
 Posted - 2009-07-15 : 10:20:26
|
| Is it possible to write a sql query which fetches data from DB but the Where condition need input from scv files. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-15 : 12:43:51
|
| yup. its possible. but you need to make use of distributed query options like opendatasource or openquery. why not first transfer csv data to sql table using export import wizard and then use table for filtering? |
 |
|
|
Sambasivam
Starting Member
36 Posts |
Posted - 2009-07-15 : 13:11:54
|
| I cant do export import wizard because i have limited access / permission to DB. I would like to know how to use Opendatasource or openquery method. Can you please help using this. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-15 : 13:32:54
|
| http://technet.microsoft.com/en-us/library/ms179856.aspxbut for using this also distributed queries should be enabled |
|
|
|
|
|
|
Input of values from csv files for sql query