I'm confused, what is the question asking? I'd like to answer it today, but with this question it would all be a shot in the dark.

J M-314995 (12/9/2009)

---

Lynn Pettis (12/9/2009)

---

New code, does this help?

select

AcctNum,

ChargeCode,

ROW_NUMBER() over (partition by AcctNum order by ChargeDate) as ItemNum

from

...

New code, does this help?

create table dbo.Charges (

AcctNum int,

ChargeCode varchar(10),

ChargeDate datetime

);

insert into dbo.Charges

select 257...

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.