Exult SQL Server makes it very easy to keep the data from XML feeds updated with the latest.
http://www.example.com/path/to/File.xml?date=01/01/08
Note that the parameter date=01/01/08 is considered an integral part of the URL and used when checking for updates. Now if the date changes and the URL now looks like:
http://www.example.com/path/to/File.xml?date=02/01/08
the data will be imported as new rather than updated.
To get around this, consider downloading the XML file separately to a specific path and importing/updating from that path.
The following walk-through demonstrates how to update XML feed data in SQL Server.
Create Pivot Tables and Pivot Charts from Large Datasets.
Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Import XML data into automatically created MySQL tables.