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 |
|
bamboo
Starting Member
5 Posts |
 Posted - 2007-11-05 : 23:57:35
|
| a list of cities in a text file is given. in sql 2000, has to get temperature of each city. any examples that have done this in a simple way?. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-05 : 23:59:44
|
use DTS or BCP or BULK INSERT to import the text file into table in a database. Use select query to retrieve what you want.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-06 : 02:34:59
|
The text file has a list of cities only.And you want to get the temperature of each and one of these cities?There are web sites where you can use web services to get their temperatures.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
query