Is there a way too connect a web service's information to a MS SQL 2005 server database?
For example say a database has a select statement that takes all the stock symbols from a table and then uses the web service to get the stock symbol closing price data. When the web service gets the data it executes a procedure to update the data into a table. This process is done once a day after the markets close say 6pm Eastern Standard Time.
Is there a way to do this I would like to now how to do this because I think telling a web service what to get from a database and then having the XML uploads go directly to a database would be a great tool to use in my database.Thank you in advance for your help.PR