Dear thank you very much for your help I served much. In published procedure I have modified so that if the record exists only actualize me but I get the fol error:
An exception of type 'System.Data.SqlClient.SqlException' Occurred in System.Data.dll but was not handled in user code
Additional information: Subquery returned more than 1 value. This is not permitted When the subquery Follows =,! =, <, <=,>,> = Or When the subquery is used as an expression.
IF EXISTS (SELECT CustomerId FROM Customers where CustomerId= (SELECT Id FROM @tblCustomers ))
UPDATE Customers
SET Name=(SELECT Name FROM @tblCustomers ), Country=(SELECT Country FROM @tblCustomers )
WHERE CustomerId=(SELECT Id FROM @tblCustomers );
Else
INSERT INTO Customers (CustomerId, Name, Country)
SELECT Id, Name, Country,Fecha FROM @tblCustomers