Stored procedure: how to update multiple tables, how to avoid database lock, how to return multline table

is it possible to combine your two SP in one SP or is it the best practice to separate SPs based on their rolls

I also notice in the 2nd SP dont output or return the results from Select statment? is your 2nd SP

[dbo].usp_getData

return table