I just finished making some code changes to get around a problem. I changed my code from doing a dynamic insert to using a stored procedure. Originally it was 20 lines of code for the dynamic process. Doing it the stored procedure way, by the time you defined all the parms it was 107 lines of vb code and 70 lines in the stored procedure.
Looking for the pros and cons and your personal preference over one method or the other.