I have created an mssql database with a table called GYVEMAL in it and I have a procedure called AllEmail that pulls emails for everyone in our database. I want to schedule this procedure to run nightly and overwrite what ever is in the database table GYVEMAL. Can I do this and how do I do this? I've looked in the documentation and online and cannot see how to do this.

Thanks Trudy

This message has been edited. Last edited by: <Kathryn Henning>,

I would assume that you would need to clean out the table and replace the contents.

Have you looked into the MODIFY command ?

Or

Issuing SQL to delete the records and INSET statements ?