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 |
|
kellog1
Starting Member
35 Posts |
 Posted - 2008-09-11 : 11:22:02
|
| Hi,I have around 500 ClientID's saved in a Txt. So I want to run a query against the Client table and see how many of them exists in the database.My question is how do I pass all these 500 values stored in Txt file in the Query? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-11 : 11:37:20
|
You can use OPENROWSET function.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-09-12 : 03:19:02
|
| or import data to staging table and do join with the client tableMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Passing Parameter Values from Txt file