Hi chetan,

You have to use SQL EXISTS function to check whether record exist or not based on Email. Then do your rest insert and update process.

Check the below sample query. Now please take its reference and correct your query.

SQL

CREATE PROCEDURE ProcedureName
      @Email NVARCHAR(50),
      @ContactPerson NVARCHAR(50)
AS
BEGIN
      SET NOCOUNT ON;
      IF EXISTS(SELECT ContactPerson FROM cmp WHERE Email = @Email)
      BEGIN
            --Your Update Query.
            UPDATE cmp
            SET ContactPerson = @ContactPerson
            WHERE Email = @Email
      END
      ELSE
      BEGIN
            --Your Insert Query.
            INSERT INTO cmp (ContactPerson,Email) VALUES (@ContactPerson,@Email)
      END
END

For more details refer below article.

Stored Procedure: Return True if record exists and False if record does not exist in SQL Server

Hi chetan,

Please refer below Query and Change your Procedure.

SQL

DECLARE	@comapanyinfo AS TABLE(ID INT IDENTITY, Dataid INT, companyname VARCHAR(20))
INSERT INTO @comapanyinfo VALUES(1,'Test')
INSERT INTO @comapanyinfo VALUES(2,'Test 1')

DECLARE	@emailinfo AS TABLE(ID INT IDENTITY, Dataid INT, email VARCHAR(20))
INSERT INTO @emailinfo VALUES(1,'test@test.com')
INSERT INTO @emailinfo VALUES(2,'test1@test.com')

DECLARE @Email VARCHAR(20)
DECLARE @CompanyName VARCHAR(50)
SET @CompanyName = 'test 5'
SET @Email = 'test1@test.com'
DECLARE @Dataid INT
SELECT @Dataid = Dataid FROM @emailinfo WHERE Email = @Email
IF @Dataid IS NULL
BEGIN
    --Email Not Exist.
    SELECT @Email Email,@CompanyName Name
END
ELSE
BEGIN
    --Email Exist.
    UPDATE @comapanyinfo
    SET companyname = @CompanyName
    WHERE Dataid = @Dataid
	SELECT * FROM @comapanyinfo
END

Output