Forgot to mention...in the stored procedure you might want to wrap all the update/insert/delete code inside a transaction. That way if for some reason it fails, it will roll the SQL table back to the way it was before and all you'll need to clean up is the temp table.
Tim ___________________________ Tim Furry Web Developer Foulston Siefkin LLP ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]