dbo.sp_id_validacion_salida

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO

CREATE OR ALTER PROCEDURE dbo.sp_id_validacion_salida
@dni varchar(50),
@tax_id varchar(50),
@birthdate varchar(50),
@name varchar(50),
@surname varchar(50),
@deceased varchar(50),
@address varchar(50),
@city varchar(50),
@state varchar(50),
@cp varchar(50),
@email varchar(50),
@telephone varchar(50),
@ID int 


AS
BEGIN
 SET NOCOUNT ON;
 update idmerit 
 set 
  OfirstName    = @name,
  OmiddleName    = null, 
  OlastName    = @surname, 
  OAddress1    = @address,
  OAddress2    = null, 
  Ocity        = @city,
  Ostate        = @state,
  [Zip Postcode] = @cp,
  oBirthdate     = @birthdate, 
  OnationalID    = @dni,
  Ophone         = @telephone,
  Oemail         = @email, 
  processed = 1
 where idFide = @ID
 
 select 'ok'


END
GO