>>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?
>
>You really need to expound on that so we know what you need to do and what you are currently doing..
I was afraid you were going to say that. Right now, I pull local motor vehicle data from the mainframe, massage it in vfp, then craete a csv file that gets imported into SQL manually. I'd like to automate it. I thought about using a remote view, but that would take a long time, I think. Is that enough info?
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright