ALTER PROCEDURE Suppliers.DeleteDuplicateSupplierNumber
	@S_Desc nvarchar(20) ,
    @S_Numb Suppliers.SupplierNumber ,
	@S_Date date ,
	@S_Type nchar (30) ,
	@S_Tel char(10) ,
	@S_Mail varchar(25)
AS 
BEGIN
    MERGE Suppliers.Suppliers AS target
    USING (SELECT @S_Desc, @S_Numb, @S_Date, @S_Type, @S_Tel, @S_Mail) AS source (S_Desc, S_Numb, S_Date, S_Type, S_Tel, S_Mail)
    ON (target.SupplierNumber = source.S_Numb)
    WHEN MATCHED THEN 
        UPDATE SET SupplierDescription = source.S_Desc
	WHEN NOT MATCHED THEN
		EXEC Suppliers.InsertNewSupplier
					@S_Desc ,
					@S_Numb ,
					@S_Date ,
					@S_Type ,
					@S_Tel  ,
					@S_Mail
					
END;
GO