SQL Server - Inserción de datos de 1 tabla a otra - ayuda

create TRIGGER [dbo].[Actualizar_Dato]

   ON  [dbo].[T_SNTP]

   AFTER INSERT

AS

BEGIN

	-- SET NOCOUNT ON added to prevent extra result sets from

	-- interfering with SELECT statements.

	SET NOCOUNT ON;

	declare @ID int

	declare @DNI varchar(50)

	declare @ESTADO smallint

	declare @IDWeb int

	select @IDWeb=0

	select @ESTADO=(Select Estado From Inserted)

	select @ID=(Select idSNTP From Inserted)

		select @DNI=(Select DNI From Inserted)

	select @IDWeb=(Select top 1 idSNTP from T_SNTP where DNI=@DNI and Estado=10)

	if @ESTADO=0

	begin

		if @IDWeb>0

		begin

			declare @APE varchar(50)

			declare @NOM varchar(50)

			declare @TELEF varchar(50)

			declare @DIREC varchar(50)

			declare @MAIL  varchar(50)

			select @APE=(Select APE from T_SNTP where idSNTP=@IDWeb)

			select @NOM=(Select NOM from T_SNTP where idSNTP=@IDWeb)

			select @TELEF=(Select TELEF from T_SNTP where idSNTP=@IDWeb)

			select @DIREC=(Select DIREC from T_SNTP where idSNTP=@IDWeb)

			select @MAIL=(Select MAIL from T_SNTP where idSNTP=@IDWeb)

			update dbo.T_SNTP set APE=@APE,NOM=@NOM,TELEF=@TELEF,DIREC=@DIREC,MAIL=@MAIL where idSNTP=@ID

		end

	end

END

select @ESTADO=(Select Estado From Inserted)

select @ID=(Select idSNTP From Inserted)

select @DNI=(Select DNI From Inserted)