>>I have to update a table in SQL Server each week, and I've been doing it with a manual process until now. Does someone have a sql script for updating fairly large tables?
>
>Look at the Upsizing Wizard code included in Sedna. There is a BulkXMLLoad program included. This is a REALLY FAST way of loading data into SQL. We use it for loading data nightly; stuff that took 45 minutes the usually way take only a couple of minutes (at worst) now. You basically just create your cursor in VFP, call this function with a few parameters and you're good to go.
Thanks Paul, I'll give it a look.
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright