ALTER TRIGGER [dbo].[TemraSensorDataNotif_alter]
   ON  [dbo].[TemraSensorData_Notification]
   AFTER INSERT,update
AS 
BEGIN

  SET NOCOUNT ON;

if not exists (select * from deleted)
begin  
  update t
    set id_sensor   = A.id_sendor
       ,Sensor_Type = A.Type
  from  m2..TemraSensorData_Notification t 
  join (select i.id
              ,case when ISNULL(i.id_sensor,0) = 0 then sm.id_sendor else i.id_sensor end as id_sendor
              ,case when ISNULL(i.id_sensor,0) = 0 then sm.Type else i.Sensor_Type end as Type            
      from inserted i
           left join Reports..Shop_Mesto_Sensor (nolock) sm 
           on sm.ShopNo=i.ShopNo and sm.sensor_name like RTRIM(ltrim(i.Name_sensor))
     )A on t.id = A.id
end

  insert into _M(id, id_sensor1)
  select id, id_sensor
  from inserted
END

update TemraSensorData_Notification
set id_sensor = id_sensor
where id in('8EDB1A4D-D1DD-4421-ABD5-878F7416753C')