Here is a UDF I was playing with just last night. I'm trying to get time data in a HH:MM AM/PM format from the SQL server.

USE your_db

GO

IF EXISTS (SELECT *...

Very helpful, thanks for sharing

Wilton,

You should try placing your delete and insert operations in your sproc inside Begin and end statements:

Begin

  Delete from aTable

End

Begin

  Insert stuff

End

Good luck, Doug

I highly recommend http://www.maximumasp.com. I've used this service provider for 4 years and have been very happy with them. I believe these guy's and gal's are considered the best for...