maybe this might help?
;with src
as
(
select rowid = 3, name = 'sony', code = 101 union
select rowid = 4, name = 'LGI', code = 100 union
select rowid = 5, name = 'LGI' , code = 666
)
insert into @temp
select *
from src
where not exists(select 1 from @temp tgt where tgt.name = src.name)
and not exists(select 1 from @temp tgt where tgt.code = src.code)
select * from @temp