out: update tbl_1 set field=  0  where field= 1  and ....
       insert into tbl_1(...field...) values(...'0'...) - забрал
in:   insert into tbl_1(...field...) values(...'1'...) - поставил
и по полю field определять текущее место положение .. каждого оборудования.
select * from tbl_1 where field='1' and ....

   insert into tbl_1(......) values(......) - забрал
   insert into tbl_1(......) values(......) - поставил
именно в таком порядке
и по мах( tbl_1.id ) определять .....
select * from tbl_1 where id in (select max(id) from tbl_1 group by ...)

select * from tbl_1 inner join #maxId on tbl_1.id=#maxId.id

insert into tbl_1 values(id,idType,idHost,[out],getdate(),user_id)
insert into tbl_1 values(id,idType,idHost,[in],getdate(),user_id)

select t.name, h.name, u.name, tb.date from
tb_1 tb inner join types t on tb.idType=t.id
inner join host h on tb.idHost=h.id
inner join sysusers u on tb.idUser=u.uid
where tb.id in (max(id) from tbl_1 group by (idType))

....
вместо where tb.id in (max(id) from tbl_1 group by (idType))
пишем where tb.field='1'