The simplest way is to use a stored procedure: you hand it all the parameters, and it fills in the table updates. It would also be a good idea to do this within a transaction, so if any part of the update fails, the whole update can be rolled back - you can do the transaction within the procedure.
SQL stored Procedures[
^]