Hi fareed.fd7,
You can pass Branch code too and check it with where condition like below
CREATE PROCEDURE CheckUserNameAndPersonName
@UserName VARCHAR(50)
,@PersonName VARCHAR(50)
,@BranchCode VARCHAR(50)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @Exists VARCHAR(20)
IF EXISTS(SELECT UserName,PersonName
FROM YourTableName
WHERE YourUserNameColumn = @UserName
AND YourPersonNameColumn = @PersonName
AND YourBranchCodeColumn = @BranchCode)
BEGIN
SET @Exists = 'Exists'
END
ELSE
BEGIN
--Your Update Statement Comes Here
SET @Exists = 'Not Exists'
END
RETURN @Exists
END
above will check the username and personName with the particular branchcode