richard.maw (4/29/2010)

---

There may be other motives for the method shown that I'm not getting but it seems to be an insanely inefficient and complicated way to do it: read service, write to file, read file, parse text, convert text, wrap it in dataset, iterate over dataset and then run the update. You can do it in two steps (1) read service into text variable (2) pass the text variable to the update statement. The parsing is done in SQL like this:

Update CurrencyConversion

Set USD_Amount = Amount * convert(xml,?).value('(//double)[1]','float'),

ConvertedDate = getdate()

Where USD_Amount IS NULL