Is it possible to update two different tables with one stored procedure or would I need a sp and a trigger? Or would I need a stored procedure with a transaction?

I basically need to change similar fields in both tables from 'null' to 'Yes' - any ideas on best practice?

Many thanks