Based on your sample table and data:

with CombinedData as (

select

row_number() over (partition by ItemId order by LocationDateTime asc) as RowNum,

ItemId,

...

Try this:

SELECT DISTINCT

PER_NR,

isnull(CHCM.OUTGOING_DATA, IPC.STATUS) AS 'STATUS',

SOC_MAPPING

FROM

CHCM_TO_PSOFT_MAPPING CHCM --Master Table used for mapping the data

...

In SQL Server, triggers are fired once regardless if it is one row or multiple rows. You need to write triggers to handle both situations.

Before I look, could you at least answer my question?

GSquared (12/9/2009)

---

The rumor mill is seriously overclocked at this point. I think it's running...

Here is a little more knowledge that will be beneficial here on SSC. Read the first article I reference below in my signature block regarding asking for assistance, then...

Post the code for your trigger. Since you have made changes, it would be helpful to see the new code.

Bru Medishetty (12/8/2009)

---

ray 78019 (12/8/2009)

---

I have SQL Server 2005 and I need to create DTS packages (not SSIS packages). I installed the DTS add-on but the DTS node only allows...

GSquared (12/9/2009)

---

I just checked the...

Hope this code helps:

select substring(YourColumn, 1, charindex('-',YourColumn) - 1), substring(YourColumn, charindex('-',YourColumn) + 1,len(YourColumn) - charindex('-',YourColumn))

Bru Medishetty (12/9/2009)

---

Lynn Pettis (12/9/2009)

---

Krasavita (12/9/2009)

---

This is what I get:

Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft...

Hard to help with just the problem description provided. Please read the first article I reference below in my signature block regarding asking for assistance. If you follow...

jcrawf02 (12/9/2009)

---

I have to say, jokes aside, I'm impressed with the group's psychic abilities, to be able to help someone with so little to work with. I think I've...

Thank you, Gus. There are times I can't post certain code snippets from work, and this was one of them. Can't include d r o p t...

Repost the code for your trigger. Since you have made changes we really need to see what you are actually running.