Need Help To Solve This Problem

Hi all

i have a problem in my stored procedureUSE [eLocalize_System]

GO

/****** Object: StoredProcedure [dbo].[Insert_Branch] Script Date: 05/15/2008 16:03:23 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author: <Author,,Name>

-- Create date: <Create Date,,>

-- Description: <Description,,>

-- =============================================ALTER PROCEDURE [dbo].[Insert_Branch]

(

@Building_No int

,@Street_Name nvarchar(50)

,@City nvarchar(50)

,@Postal_Code nvarchar(50)

,@Telephone nvarchar(50)

,@Fax nvarchar(50)

,@Client_Id int

,@Country_Id int

,@Row int output)

AS

Declare

@BranchCode int,

@Branch_Name nvarchar(50)

set @BranchCode=isnull((select Max(BranchCode) from dbo.Branch where Client_Id=(select Id from dbo.Client where Id=@Client_Id)),0);

set @BranchCode=@BranchCode+1

set @Branch_Name=(select City from dbo.Branch)+'+'+(select Name from dbo.Country where Id=(select Country_Id from dbo.Branch))INSERT INTO [eLocalize_System].[dbo].[Branch]

([Branch_Name],[BranchCode]

,[Building_No],[Street_Name]

,[City],[Postal_Code]

,[Telephone],[Fax]

,[Client_Id]

,[Country_Id])

VALUES

(@Branch_Name,@BranchCode ,

@Building_No ,@Street_Name

,@City ,@Postal_Code

,@Telephone ,@Fax

,@Client_Id

,@Country_Id)

set @Row = (select scope_identity())

return @Row

i want Branch_Name = City + Country

and how i do it if there is any update

Thanks for help