--create
alter trigger [dbo].[trigger_sqsj]
on [dbo].[lctnrcrd]
after INSERT as
BEGIN
declare @id char(50)
select @id = (select top 1 id from [lctnrcrd] order by CONVERT(char(16),dlr,120) desc)
print @id
delete from [lctnrcrd]
--select * from [lctnrcrd]
where id = @id and
idowner+CONVERT(char(16),dlr,120) in
(select idowner+CONVERT(char(16),dlr,120) from [lctnrcrd] where id not in(@id))
--select * from [lctnrcrd] order by CONVERT(char(16),dlr,120) desc
END
--select * from [lctnrcrd] order by CONVERT(char(16),dlr,120) desc
