>It could be the case. I'm really unsure how locks will be accomplished (and how safe it will be) on server. I would prefer (if possible) to get everything under one umbrella (either one view or one stored procedure).

... or one transaction?