|
rico_bano
Starting Member
35 Posts |
 Posted - 08/10/2007 : 09:15:40
|
Can anyone give me some advice on the best way to do this.
I need to create a stored proc that updates different columns of a table depending on a users action. There will be two actions. save and submit. saving will populate a createddate and createdby field, whereas submitting will populate a submitteddate and submittedby field. Both actions update some common columns.
Im thinking the best way to do this is to create two updates in the stored proc. One that handles the common column updates and then one that updates the non common.
Does this sound like a good plan or should i maybe use some dynamic sql?
thanks |
|
stored procedure advice
