ALTER PROCEDURE [dbo].[fm_Company_InsertUpdate]

@INCMP int = -1,
@CNAME VARCHAR(40),
@LEGAL VARCHAR(40),
@TAXID VARCHAR(40) = null,
@CMP int OUTPUT

AS

BEGIN 
    
    -- Update the row if it exists.     
	Update dbo.fm_Company SET company_name=@cname, company_legal_name=@legal, company_tax_id=@taxid
	Where company_id=@INCMP; 
	SET @CMP = @INCMP;

	-- Insert the row if the UPDATE statement failed.     
    IF (@@ROWCOUNT = 0) 
    BEGIN 
        	--Insert record
			INSERT INTO dbo.fm_Company ([company_name],[company_legal_name],[company_tax_id])
			VALUES (@CNAME, @LEGAL, @TAXID)
			SET @CMP = SCOPE_IDENTITY();  
    END
END

 -- Update the row if it exists.     
        Update dbo.fm_Company SET company_name=@cname, company_legal_name=@legal, company_tax_id=@taxid
        Where company_id=@INCMP; 

         SET @RC = @@ROWCOUNT

         SET @CMP = @INCMP;

        -- Insert the row if the UPDATE statement failed.     
    IF (@RC  = 0)      --  @RC didn't get reset when @@ROWCOUNT did
    BEGIN