Yea, you could use a stored procedure. You also might want to see if Transaction Groups can help you here.