Okay, that helps but then how do you get a count of 1 from this, I'd assume it would be 2:

select '92232','eex','10/21/2008 12:00am' union...

Gus,

Here is my take on this, since it is on a SQL Server 7, 2000 forum and based on the original post. The OP has the SQL Server 2005...

Jeff Moden (12/9/2009)

---

Lynn Pettis (12/9/2009)

---

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. ...

The only problem I have the Colorado Springs SQL Server Users Group is the day they have chosen to meet, I'm sorry but Wednesday night is not a good night...

Just ran a quick test, you probably have null values as an empty string does not return an error.

Rob-350472 (12/10/2009)

---

@Lynn, I tried your method, which worked fine on the small sample you gave, however, when I try it on my table I get :

Msg 1014, Level 15, State...

Bru Medishetty (12/10/2009)

---

ray 78019 (12/10/2009)

---

Hi Greg,

If I understand correctly, if I open the DTS in SQL Server Management Studio (2005) and save it under a different name, it'll still be...

Rob-350472 (12/10/2009)

---

I did wonder if the words cursor would lead to criticism! - I'll read through the other replies above and give them a go when I get a chance.

It's...

Agreed, the cursor solution, though workable, is not scalable. Of the three alternatives presented here at this time, IMHO, the tally version is actually the most scalable solution. ...

Here is the fun part of living in Colorado. This past week we have had tempatures down to -13F (not including wind chill factor) and during the day between...

Here is another alternative. The following code is a how I would accomplish this task followed by the code for my function.

create table dbo.TestData (

ID...

At this point all we can do is guess at what you are trying to accomplish. Help us help you, read the first article I reference below in my...

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...