>Ok; If I were to go about this task the correct way/approach, what would I need to do (conceptually)? Pass value for each field/column to the stored procedure as a variable?
>
Yes, pass values for each column and write an insert statement listing all fields and values.
If it's not broken, fix it until it is.
My Blog 
