J M-314995 (12/9/2009)

---

Lynn Pettis (12/9/2009)

---

Two questions. One, is itemnumber part of the table or just part of the output? Two, is the order of the charges per account...

Answering my own questions (Only part of the output, order of charge code immaterial), here is some code:

create table dbo.Charges (

AcctNum int,

ChargeCode...

Two questions. One, is itemnumber part of the table or just part of the output? Two, is the order of the charges per account important?

Jeff Moden (12/9/2009)

---

Lynn Pettis (12/9/2009)

---

If Jeff suggested that you do this, I suggest you figure out how to write the query using a while loop. Give it a shot....

What should the result set for these be? They are a part of the sample data as well.

select '2241','eex','8/21/2008 12:00am' union all

select '2241','co2','9/21/2008 12:00am' union all

select '2241','co2','9/23/2008 12:00am' union...

Correct, it is missing from the article, but it wasn't missing from...

Please don't describe the results you want, show us using the sample data. This way we have something to test against.

Would that depend on how the application passing the value back to the database? Not too familiar with ASP.

Okay, now how about the expected output based on the sample data provided?

Funny.

Our SSIS projects are saved in VSS (we aren't using Team Edition). If someone on my team creates a new project, I can just check it out from VSS...

clive-421796 (12/9/2009)

---

From Lynn:

Is the following order of records guarantteed, or could you get a type 1 with no following type 0, or could you get 2 consecutive type 1's or...

Would help if you posted your code. Not much help otherwise.

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.