same id,ID_SEQ,EID,TS_DT but differetn location id.

  • rajesh

    Grasshopper

    Points: 12

    Delete first 3 records and last two records as same day two locations should not be assigned to same id,id_seq,eid combination because it is wrong combination.

    ID | ID_SEQ| TS_DT | EID | LOCATION_ID

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

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

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

    123|1 |11/10/2019 | hello |A123

    124|1| 10/10/2019 | hello1 | S123

    124|1| 10/10/2019 | hello1 | S123

    124|2 | 10/10/2019 | hello1| A123

    456|2| 11/12/2019 | msg | A123

    456|2| 11/12/2019 | msg | S123

  • Site Owners

    SSC Guru

    Points: 80373

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply