Same id with different values in another columns

[rajesh]

I need to delete only the records if the location id is different and values in the remaining columns are same.
In below example, first 3 records and last two records has to to be deleted

ID | ID_SEQ |TS_DT | EID |LOCATION_ID

123 |1 | 10/10/2109 | hello | W123
123 |1 | 10/10/2019 | hello | A123
123 |1 | 10/10/2019 | hello | A123

123 |2 | 10/10/2019 |hello | A123

124 |1 | 10/11/2019 |hellos | A231
124 |1 | 10/11/2019 |hello | A231

124 | 3 | 10/13/2019 | mgs | E123
125 | 3 | 10/13/2019 | mgs | E123

124 |2 | 10/12/2019|hello | A231

345 |3 | 11/10/2019 |rgs | A123
345 |3 | 11/10/2019 |rgs | W123

Expected output: delete records if location id is different and values in the remaining columns are same (On the same day, Should not be map two different location id(s) to same ID,ID_SEQ_ID and EID combination)

ID | ID_SEQ |TS_DT | EID | LOCATION_ID
123 | 1 | 10/10/2109 | hello | W123
123 | 1 | 10/10/2019 | hello | A123
123 | 1 | 10/10/2019 | hello | A123

345 | 3 | 11/10/2019 | rgs | A123
345 | 3 | 11/10/2019 | rgs | W123

[harishgg1]

hi please see what i did is okay !!!!

there is mistake typing in your data
123 |1 | 10/10/2109 | hello | W123

here its 2109 it should be 2019 ..

please click arrow to the left for drop create data ..

drop table #data 
go 

create table #data 
(
ID int,
ID_SEQ int,
TS_DT date,
EID varchar(10),
LOCATION_ID varchar(10)
)
go 


insert into #data select 123 ,1 , '10/10/2019' ,'hello' , 'W123'
insert into #data select 123 ,1 , '10/10/2019' ,'hello' , 'A123'
insert into #data select 123 ,1 , '10/10/2019' ,'hello' , 'A123'
insert into #data select 123 ,2 , '10/10/2019' ,'hello' , 'A123'
insert into #data select 124 ,1 , '10/11/2019' ,'hellos', 'A231'
insert into #data select 124 ,1 , '10/11/2019' ,'hello' , 'A231'
insert into #data select 124 ,3 , '10/13/2019' ,'mgs'   , 'E123'
insert into #data select 125 ,3 , '10/13/2019' ,'mgs'   , 'E123'
insert into #data select 124 ,2 , '10/12/2019' ,'hello' , 'A231'
insert into #data select 345 ,3 , '11/10/2019' ,'rgs'   , 'A123'
insert into #data select 345 ,3 , '11/10/2019' ,'rgs'   , 'W123'
go 

select * from #data

please click arrow to the left for DELETE statement

DELETE FROM a 
FROM   #data a 
       JOIN #data b 
         ON a.id = b.id 
            AND a.location_id <> b.location_id 
            AND a.id_seq = b.id_seq 
            AND a.ts_dt = b.ts_dt 
            AND a.eid = b.eid