I need to update a SQL Server table. I want to create a simple stored procedure on the server to do the update. How do I call the stored proc and send a param with sqlexec(). Or is sqlexec() even the best route.

Much Thanks
Miles