ALTER PROCEDURE CompanyStoredProcedure
    @uspcompanyid INT NULL,
    @uspcompanyname VARCHAR(20),
    @uspaddress1 VARCHAR(30),
    @frmErrorMessage AS VARCHAR(256) OUTPUT,
    @RETURNVALUE AS INT OUTPUT,
    @RETURNID AS INT OUTPUT
AS 
BEGIN
 
SET NOCOUNT ON
 
/*
 
RETURN_VALUE Comments
1            Data Inserted
2            Data Updated 
-9            Other errors
*/
    DECLARE @companyid INT,
        @companyname VARCHAR(20),
        @address1 VARCHAR(30) 
 
--validation...
IF ( @uspcompanyname IS NULL OR @uspcompanyname = '' ) 
    BEGIN
        SET  @RETURNVALUE = -9
        SET  @frmErrorMessage = 'Company Name is empty'
        RETURN -9                        
    END     
 
IF EXISTS ( SELECT  * FROM Companymaster WHERE Companyid = @companyid ) 
    BEGIN
        UPDATE Company
        SET companyname = @companyname,
                address1 = @address1
        WHERE    companyid= @uspcompanyid
 
        SET  @frmErrorMessage = 'Company Name/Address  has been updated'
        SET @RETURNVALUE = 2
    END
ELSE 
    BEGIN
        INSERT  INTO companymaster ( companyname, address1 )
        VALUES  (@companyname,@address1)
 
        SET  @frmErrorMessage = 'Company Name/Address info has been Inserted'
        SET @RETURNVALUE = 1
    END
 
SET NOCOUNT OFF     
END