Also as the article says, if you update a unique index column it will create this sort of issue. But Ideally in this scenario I am just doing an Update...

Jayanth_Kurup (10/26/2015)

---

you can start here

https://support.microsoft.com/en-us/kb/238254%5B/quote%5D

Thanks Jayanth, this is a great place to start with. Now that I understand a little what is happening, any idea how this can...

Jayanth Thanks for the quick reply... Transactional replication it is. I don't have the logs to share.. any other thoughts or places I can look at?

Thanks for the guidance, Once I am able to get the answer I will mark it as solution. it will be really helpful if you have a sample query by...

Hi Martin, sorry for not making it clear. I am trying to see if it's possible through MDX or if you can tell me the steps in excel also it...

What if there is a 3rd and 4th payer? How does the data look like? And how did the ID2 become 002 when nothing of such was in data? Can...

Can you not use SSIS and remove the duplicates using the SORT transformation since you said its a nightly job? If you have to do it only the T-SQL way,...

I am sorry Wayne, I gave you the wrong output values.

SELECT 1 AS IssueID, 'Very Low' AS IssueStatus

UNION ALL

SELECT 1, 'Low'

UNION ALL

SELECT 1, 'Medium'

UNION ALL

SELECT 1, 'High'

UNION ALL

SELECT 1, 'Critical'

UNION...

Thank you wayne, I will wait for your answer.

Thank you for your quick reply. Sorry about the confusion. Yes, you are right when I mean status Id I was referring to issuetypeid.

I provided the output in...