I was having similar issues just today. The parameter value was there yet the procedure would not update and I couldn't get it to work except to update the...

This works great if you know the columns and it's only one table. Next task is to dynamically generate the insert and select statements dynamically from the columns of...